This Google Sheets add-on was created to provide users with a simple way to merge selected spreadsheet row(s) with user defined Google Docs or email templates. Simple merge markers and row selection make this the easiest merge utility in the G Suite Marketplace. Header rows are not required and row content can be merged to templates with simple column data markers such as @colC@ or @colF@. If the sheet does have a header row in the first row, then templates can merge headers using simple column header markers such as %colC% or %colF%. The current @date@ and @time@ can also be used in templates. Email templates can be plain text, importing from Gmail Drafts, or users can past in custom HTML for true customization.
The add-on only utilizes Google services and does not share any data with me as the developer. The script has limited access to your email in order to send emails and read and import a specific draft email. The script also has access to your Google Drive in order to copy and create new documents. The only information I receive is your email address and billing zip code if you subscribe to our premium version or provide feedback information.