The latter comes to the picture if you want to thank the user for their response and time.
Now, there are two ways of going forward with this.
you’re able to either shoot off an email based on any response on your form.
And as noted earlier, both methods need the aid of an external add-on.
Now that we have it settled, lets get started, shall we?
The aptly named Form Notifications add-on lets you send simple thank you emails to the users.
This will take you to the Google Marketplace.
Step 2:Now, search for Form Notifications and hit it to install it.
Next, create the form.
If you want to send the emails to the respondent directly, check the Collect emails checkbox under controls.
Step 3:Once done, pick the little Add-on icon and select Form Notifications.
You will see a prompt in the lower-right corner.
Toggle the button for Thank you email.
As noted earlier, you could either go with the Automatically field or the Form field.
choose the one which fits your requirement the best.
Step 4:Next, add the Subject and Body of the email, and thats about it!
This is a simple add-on and configuring it is simple and straightforward.
And the Published by Google Cloud tag makes it a tad reliable as well.
To do so, toggle the button for Notify on form response.
The creators email will be auto-populated on the recipient field.
Its not hard-coded and you’re able to enter other email addresses as well.
Once done, add the notification threshold and hit the Save button.
From now on, your form will shoot off an email once it crosses the response threshold.
How to Send Responses Based on Responses
Let us put it right there.
Here, you will have to tinker with the App Script of the connected Spreadsheet.
Thankfully, if you have a simple form, it should be easily doable.
In our case, we have a simple form where we ask the respondents for their preferred holiday location.
Naturally, the code can be tweaked as per the requirement of your form.
This will connect your form to a spreadsheet.
Once that data is captured, the For statement will cycle through the array to bring you the data.
In the end, the form data for that particular response will be assigned to theprefLocationvariable.
Here, select From Spreadsheet as the Event Source and On Form Submit as the Event throw in.
And on submission, it will only pull data from the connected spreadsheet.
Its a one-time process though.
To get your code running, submit your form.
If everything is in the right place, the odds are that you will get an email.
To Code or Not to Code
The second method may look a tad complicated.
This one is designed for sending emails based on conditional responses.
Was this helpful?
The content remains unbiased and authentic and will never affect our editorial integrity.
