# Send upon Google form submission

Source: https://yamm.com/help/usage/launch-campaign/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.

[Watch the video on YouTube](https://www.youtube.com/watch?v=5f9oIJwizAs)

## Link a form to your spreadsheet

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-1.png)

2. Select **Create a new spreadsheet** and click **Create**.

   ![Select destination for responses dialog with Create a new spreadsheet selected and the Create button](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-1b.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-1c.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-2.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-3.png)

   - **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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-4.png)

   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?](https://yamm.com/help/usage/troubleshooting/account-delivery-scheduling/index.md#why-cant-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](https://yamm.com/help/usage/track-campaign/about-tracking/index.md) 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.

[Watch the video on YouTube](https://www.youtube.com/watch?v=OZYxwnVGxUI)

Warning: This feature works only if the specific cell is automatically filled by a script or another add-on (like [Form Publisher](https://workspace.google.com/marketplace/app/form_publisher/827172627657)) 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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/delay-mail-merge-until-specific-column-has-been-filled-1.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/delay-mail-merge-until-specific-column-has-been-filled-2.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/delay-mail-merge-until-specific-column-has-been-filled-3.png)

## 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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-7.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-8.png)

   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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-9.png)

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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-10.png)

## 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](https://yamm.com/help/images/docs/usage/launch-campaign/send-upon-google-form-submission/configure-google-form-submission-notifications-6.png)

3. Click **Save**.

YAMM stops sending notifications for new form submissions.

## What's next

- [Send each recipient a prefilled form link](https://yamm.com/help/usage/create-campaign/personalize-links-and-images/index.md#send-prefilled-google-form-links) to ask them to verify or update their data.

- [Track your campaign results.](https://yamm.com/help/usage/track-campaign/about-tracking/index.md)