Templates / Streamline data from an n8n form into Google Sheet, Airtable and Email Sending

Streamline data from an n8n form into Google Sheet, Airtable and Email Sending

Ready for 3.0

by AlQaisi ✓ · 6,345 views · created 2024-02-08 · Lead Generation

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 7 nodes and runs when someone submits an n8n form (“Data Colleacation”). Along the way it connects Airtable, Google Sheets and Gmail.

How it runs

Trigger: When someone submits an n8n form (“Data Colleacation”).

Extracting Date and Time Fields from 'submittedAt' Field (Code): runs custom JavaScript code
Format the Fields (Edit Fields (Set)): sets or maps fields
Google Sheets: append
Airtable: create
Gmail: uses Gmail
Gmail: uses Gmail

Services it uses

Airtable Google Sheets Gmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

n8n Form Triggern8n-nodes-base.formTrigger
Coden8n-nodes-base.code
Edit Fields (Set)n8n-nodes-base.set
Airtablen8n-nodes-base.airtable
Google Sheetsn8n-nodes-base.googleSheets
Gmailn8n-nodes-base.gmail

From the author

Streamline data from an n8n form into Google Sheet Airtable and and Email Sending Video for workflow process This workflow facilitates efficient data collection and management by leveraging the capabilities of various nodes within the n8n platform. It…
Excerpt from AlQaisi's description on n8n.io.

View the original on n8n.io → Check your own copy

Streamline data from an n8n form into Google Sheet, Airtable and Email Sending

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (6)

From the author

Get the weekly “what broke” email