Instant Gmail Notifications for Google Form Submissions

This n8n workflow provides a streamlined way to receive instant email notifications whenever a new submission is made to your Google Form. By integrating Google Sheets as the trigger, it ensures you're immediately alerted to new data, allowing for quick follow-up or action.

What it does

This workflow automates the following steps:

1. Listens for new Google Form submissions: It acts as a trigger, constantly monitoring a specified Google Sheet for new rows, which typically correspond to new form submissions.
2. Processes the submission data: Once a new row is detected, the workflow captures the data from that submission.
3. Sends an instant Gmail notification: It then uses the captured data to compose and send an email notification via Gmail, alerting you to the new submission.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n instance: A running instance of n8n (self-hosted or cloud).
• Google Account: A Google account with access to Google Sheets and Gmail.
• Google Form: An existing Google Form that is configured to save submissions to a Google Sheet.
• Google Sheets Credential: An n8n credential configured for Google Sheets (OAuth2).
• Gmail Credential: An n8n credential configured for Gmail (OAuth2).

Setup/Usage

1. Import the workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON code and click "Import".
2. Configure Google Sheets Trigger:
   • Locate the "Google Sheets Trigger" node.
   • Double-click it to open its settings.
   • Select your Google Sheets credential.
   • Specify the Spreadsheet ID of the Google Sheet where your form submissions are stored.
   • Specify the Sheet Name (usually "Form Responses 1" or similar).
   • Set the Trigger When option to "New Row".
   • Click "Execute Workflow" to test the trigger.
3. Configure Gmail Node:
   • Locate the "Gmail" node.
   • Double-click it to open its settings.
   • Select your Gmail credential.
   • Set the To email address (this is where the notifications will be sent).
   • Configure the Subject and Body of the email. You can use expressions to dynamically include data from the Google Form submission. For example, to include the form data in the body, you might use an expression like {{ JSON.stringify($json.current) }} or access specific fields like {{ $json.current.Name }}.
4. Activate the workflow:
   • Once all credentials and nodes are configured, click the "Activate" toggle in the top right corner of the workflow editor to enable it.

Now, whenever a new submission is made to your Google Form, you will receive an instant email notification via Gmail!