Skip to main content

Send upon Google form submission

Use YAMM to automatically send a personalized email every time someone submits a Google form — ideal for confirmations, acknowledgements, and onboarding sequences. The notification uses a standard Gmail draft as its email template, so you can add an alias, cc/bcc, attachments, inline images, and more.

Ensure a Google form is linked to your spreadsheet.

  1. In your Google form, select Responses, then click Link to Sheets.

    Responses tab of a Google form with the Link to Sheets button

  2. Select Create a new spreadsheet and click Create.

    Select destination for responses dialog with Create a new spreadsheet selected and the Create button

A response spreadsheet is created. You can start configuring YAMM from there.

New response spreadsheet with a Form Responses 1 tab and the form questions as column headers
info

Form notifications are set up at the spreadsheet level, not the individual sheet level. The notification feature isn't available for spreadsheets with multiple forms.

Set the notification rules​

  1. In the response spreadsheet, select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Configure form submission notifications. If the item isn't there, close and reopen your spreadsheet.

    Configure form submission notifications in the Extensions menu

  2. In the Set Notification rules sidebar, select:

    • Notify one or more addresses of all responses: Each response is sent to the addresses in the recipient field of your Gmail draft selected under Email Template.

      Set Notification rules sidebar with the option to notify one or more addresses of all responses

    • Notify address submitted by the form: Each response is sent to the address the respondent submitted. Select the Gmail draft under Email Template, then choose the column holding the addresses under Recipients column.

      Set Notification rules sidebar with the option to notify the address submitted by the form

    Select both rules to notify your own addresses and the respondent, each with its own email Template.

    info

    Switched your email to a new domain? YAMM may block changes to this sidebar — see Why can't you set notification rules after switching email domains?

  3. (Optional) Enter a Sender Name, and check Track emails opened, clicked or bounced to get tracking stats for the notifications.

  4. Click Save.

warning

Don't delete the Gmail drafts you selected as email templates — YAMM reuses them every time a notification is sent.

Delay until a specific column is filled​

If a form submission triggers another script or add-on, you may want it to finish before YAMM sends the notification. For example, you can delay sending until:

  • A column value has finished calculating from the submitted data and other variables.

  • A file has been created so it can be attached.

warning

This feature works only if the specific cell is automatically filled by a script or another add-on (like Form Publisher) after submission. It does not work if you manually fill in the data.

  1. In the response spreadsheet, select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Configure form submission notifications. If the item isn't there, close and reopen your spreadsheet.

  2. In the Set Notification rules sidebar, select Wait until a specific column is filled before sending the email.

    Wait until a specific column is filled option checked, with a Column to check dropdown set to PDF URL

  3. Select the column to check.

  4. Click Save.

If the chosen column is still empty when the form is submitted, YAMM waits 60 seconds for the other process to finish.

Response spreadsheet where the latest row has an empty PDF URL cell and a Wait 60s merge status

If the column is still empty after 60 seconds, YAMM tags the row with an error and sends no email. That row is retried on the next form submission.

Response spreadsheet where the latest row has an Error merge status and a tooltip explaining that the PDF URL cell is empty

Attach respondents' files​

When your form has a File upload question, YAMM can send the files the respondent uploaded back out as email attachments. This is useful for confirming a submission with the documents attached, or for forwarding a signed form, an application, or a receipt to whoever reviews it.

Rename the response column so YAMM attaches the uploaded files:

  1. Open the spreadsheet linked to your form responses.

  2. Locate the column corresponding to the File upload question.

    The column header is the form question

  3. Rename that column header to Attachment or Attachments. Unlike regular markers, this name is case-sensitive.

    The column header corresponding to the form question is renamed Attachment
    info

    Rename only the column in the response spreadsheet, not the form question itself.

  4. In your Gmail draft, use the marker {{Attachment}} or {{Attachments}}.

    "{{Attachment}}" is added at the end of the draft

The files uploaded to the Google form question are attached to the notification email upon form submission.

Received notification email carrying the uploaded PDF as an attachment, labeled with the YAMM campaign label

Deactivate notifications​

  1. In the response spreadsheet, select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Configure form submission notifications.

  2. In the Set Notification rules sidebar, uncheck both options.

    Set Notification rules sidebar with both notification options unchecked, before clicking Save

  3. Click Save.

YAMM stops sending notifications for new form submissions.

What's next​