Using FormMule to enhance & automate Google Forms
formMule is an addon that can send personalized emails whenever a form is submitted by users from your Google Form.
Here are a few applications of formMule:
Send a Thank You or Confirmation whenever a user submits an inquiry on your website.
Send a notification with details to yourself or your sales\support staff whenever a user submits an inquiry .
Capture support requests from your website & send the details to your helpdesk\support department for immediate action.
Capture requests for information \ catalogs from your customers\prospects and send them the desired information whenever they submit a form. Very handy for getting responses from a Email or Online Marketing Campaign.
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
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.
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!
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.
Check out this Video Tutorial on how to use Form Mule to send Automated Response whenever a user submits a Form.