1. Home
  2. Google Sheets
  3. Automation

New form response

As it names implies, this automation will trigger when a new Google Form response is added to your spreadsheet. So first, you need to create your Google Form and then link it to a spreadsheet. Once done, open the spreadsheet and follow these steps:

  1. Open your spreadsheet already linked to a Google Forms.
  2. From the extensions menu, select Mailmeteor > Automations.
  3. In the “Templates” section, click on New form response.
  4. Click on Send an email with Mailmeteor to configure the email to send.\

  5. In the To section, enter either an email address to send all new responses to (for example if you collect feedback, enter [email protected]) or the column in your spreadsheet that contains email addresses.
  6. Write your message by entering a subject line and content.
  7. Scroll down to access more options then click Save.
  8. Click on Create automation to start sending emails on new form response.