Using FormMule to enhance & automate Google Forms

Install formMule in a few clicks on any Google Sheet from the Add-on Gallery for Sheets.  Once installed, you can launch formMule from any other Google spreadsheet in your Drive.

BASIC USE

1. Merge settings - Identify the sheet that you will use to create merged emails. This sheet must have unique headers in the first row, and one row of data per email you want to send.  Indicate whether you want to run the merge manually or on form submit -- this means your merge source can be the same sheet that accepts Google Form responses.

2. Email template(s) and send conditions - indicate how many unique templates you want to use in your merge setup (up to 10 allowed).  For simple cases, this will typically be just one, but imagine sending different templates for different reasons, depending on the values in your sheet.  This is where "Send Condition" comes in -- use this to set a specific flag that must exist in a column in the source data in order for a particular template to send.  Imagine the possibilities!

3. Build / preview your template(s) - Handy template editor lets you create and preview the To, CC, BCC, Reply-to, Subject, Body, and auto-translated Body via Google Translate language codes.  With click-button menu for all available headers, dropping merge tags into your template has never been easier. Preview your template interacts with your sheet data in real-time.

FEATURES

• • Works great for bulk-sending batches of merged emails OR for automated merges on each new form submission.

  • Allows you to create up to 10 different email templates, each with its own send condition -- e.g. only send Template A if column B = "Yes", etc.

  • Fancy new template editor lets you drop in merge tags and header labels (in body) with a swift little click.  Satisfying!

  • Can be set to create unique case number per form submission, useful for keying together multiple forms that include follow ups.

  • Works together with the copyDown Add-on to allow formulas to be copied down on form submit, opening up the possibility for VLOOKUP, COUNTIF, and other useful functions to play a role in your communications logic.