Learn to Magically Send Emails from your Google Form Responses

Max Brawer
6 min readJun 20, 2018

2023 UPDATE: We’ve launched www.sheetswizard.com, home to ready-to-use apps for saving custom themes, integrating to calendar, formatting your data for analysis, and soon a form notifier — check them out and let us know what you think. Custom themes is free for September only! https://workspace.google.com/marketplace/app/custom_sheet_themes/773536777209

I am always looking to get more and more users to tap into the power behind Google Drive for Enterprise AND to learn to code at the same time.

Back in the old days, we used to try to automate business process with VBA + Excel, which is no fun because VBA is a dead language. But here, in Google land, you’ll be learning some JavaScript and telling your friends you can code in no time!

This example came from a friend who wants to send form submissions automatically to specific email addresses and possibly put them in their own doc. Let’s get into what we need to do, step by step:

Step 1: Create an Apps Script File from your Form Response Spreadsheet

--

--

Max Brawer

People Tech & Analytics leader @ Atlassian, formerly Twitch, BuzzFeed, Google, Nielsen | Try his apps @ sheetswizard.com