Google Form Instant Email Notification Setup - n8n Workflow

• Business owners needing real-time lead alerts.


• Teams managing customer feedback or support requests submitted via Google Forms.


• Developers looking for robust n8n templates to handle web submissions.


• Users seeking to implement a serverless notification system using an n8n node trigger.

This n8n workflow solves the common problem of delayed notifications for crucial Google Form submissions. By leveraging the Google Sheets n8n trigger, the system provides immediate, actionable alerts via Gmail. This ensures that sales inquiries or critical customer feedback are addressed without delay, significantly improving response times and operational efficiency. This specific n8n workflow template demonstrates high-speed data processing and automated communication using core n8n features, allowing users to build reliable infrastructure with minimal code through the use of powerful n8n node configurations.

The entire n8n workflow is designed for maximum efficiency and immediate response:

1. Trigger Setup: The n8n workflow begins with the Google Sheets Trigger n8n node (Trigger when a row is added), which is configured to monitor a specific Google Sheet (the one receiving Google Form responses). It acts as an instant n8n trigger, executing whenever a new row is detected.


2. Data Extraction and Email Generation: The Code n8n node (Email generation) receives the full submission data from the Google Sheet row. It executes custom JavaScript to extract key fields, such as the submitter's email and the specific request content, and structures them into a readable HTML body.


3. Instant Notification: The final step utilizes the Gmail n8n node (Instant email) to send the custom-generated HTML content immediately. This robust n8n node ensures the designated recipient receives a detailed, instant notification upon form submission, closing the automation loop efficiently.

To deploy this n8n workflow template successfully, follow these setup steps:

1. Import: Copy the n8n workflow JSON provided and paste it into your n8n instance using the "Import from JSON" feature.


2. Google Sheets Trigger Setup: Configure the Trigger when a row is added n8n node. You must set up Google Sheets credentials, linking your account and granting permission to access the specific spreadsheet tied to your Google Form responses. Configure the Document ID and the exact sheet name.


3. Gmail Credential Setup: Configure the credentials for the Instant email n8n node. Ensure your Gmail account is authenticated with n8n so it has permission to send emails.


4. Recipient Configuration: In the Gmail n8n node, update the Send To parameter to the desired, fixed email address that should receive the instant notifications (e.g., your sales or support inbox).


5. Activation: Test the n8n workflow by submitting a test form entry. Once confirmed working, set the n8n workflow to "Active" to begin real-time monitoring.

Trigger when a row is added (Google Sheets Trigger)
Function: Serves as the primary n8n trigger. It monitors the specified Google Sheet every minute for new row additions, indicating a new Google Form submission.
Key Configuration: Event is set to rowAdded. Requires configuration of the Google Sheets credentials, Document Id, and Sheet Name.
Email generation (Code)
Function: A data transformation n8n node that processes the incoming submission data. It generates a clean, structured HTML message body by mapping specific form field names (e.g., "Adresse e-mail" and "Please write your request") to variables.
Key Configuration: Uses custom JavaScript to create an html output variable containing the formatted message.
Instant email (Gmail)
Function: Executes the final action of the n8n workflow, sending the compiled notification email instantly using the configured Gmail account.
* Key Configuration: Subject is static ("The requests you received today"). The Message field dynamically uses the output from the previous n8n node via an expression: ={{$json.html}}.