Automate Data from n8n Form to Google Sheets & Airtable

What this workflow does

This workflow takes the data from each form submission. It then splits the submission time into date and time. After that, it fixes field names for easy use. Then it adds the data to Google Sheets and Airtable. Finally, it sends two custom emails to the submitted email address. This stops any copying mistakes and saves time.

Who should use this workflow

This workflow is good for someone who gets many online form entries daily. It helps avoid manual entry errors. It also sends auto confirmation emails. You should have basic n8n knowledge and accounts on Google Sheets, Airtable, and Gmail. This suits small business owners or workshop organizers who want less manual work.

Tools and services used

• n8n Form Trigger: Receives participant data from the form.
• Code Node: Extracts date and time from submission timestamp.
• Set Node: Renames fields to uniform database keys.
• Google Sheets Node: Adds form data as new rows in spreadsheet.
• Airtable Node: Creates new records in Airtable base and table.
• Gmail Nodes (2): Sends confirmation emails to participants.

Inputs → Processing → Outputs

Inputs

• Form submissions with Name, City, Email.
• Submission timestamp (submittedAt field).

Processing steps

• Transform timestamp into separated Date and Time.
• Remove original timestamp field to reduce confusion.
• Rename user question fields to standard keys: Name, City, Email, Date, and Time.
• Append formatted data to Google Sheets.
• Make new records in Airtable with the same data.
• Send two personalized emails to the participant’s email address.

Outputs

• New rows in Google Sheets with participant details and date-time.
• New Airtable records matching form entries.
• Two different Gmail messages sent to the participant as confirmation.

Beginner step-by-step: How to build and run this workflow in n8n

Import the workflow

1. Inside the n8n editor, use the Download button to save the workflow file.
2. Go to your n8n editor dashboard and click “Import from File.”
3. Select the downloaded workflow file and import it.

Configure before running

1. Add required credentials for Google Sheets, Airtable, and Gmail nodes (API Keys or OAuth2 as needed).
2. Update Spreadsheet ID, Sheet name, Airtable Base ID, Table ID if your setup is different.
3. Check mapped email fields in Gmail nodes to ensure correct recipients.
4. If Code node content is missing, use this JavaScript to split date/time:

   // Loop over input items and separate date and time into two new fields
   for (const item of $input.all()) {
     const submittedAt = new Date(item.json['submittedAt']);
     const date = submittedAt.toISOString().split('T')[0]; // Extract date
     const time = submittedAt.toISOString().split('T')[1].split('.')[0]; // Extract time
   
     delete item.json['submittedAt'];
   
     item.json['Date'] = date;
     item.json['Time'] = time;
   }
   
   return $input.all();
   

Test and activate

1. Send a test submission through your form URL to trigger the webhook.
2. Check Google Sheets and Airtable for new entries.
3. Confirm you receive the two emails at the submitted address.
4. When working, toggle the workflow “Active” in n8n to run live.
5. Optional: For better hosting control, consider self-host n8n on your own server.

Customization ideas

• Add or modify form fields in the n8n Form Trigger to collect phone numbers or preferences.
• Change email message text in Gmail nodes for more personalization or include HTML.
• Insert an IF node after field formatting to filter which data goes to Google Sheets or Airtable.
• Switch Airtable operation from “Create” to “Update” to avoid duplicate records based on emails.
• Add a Slack node to send team notifications when new entries come in.

Common edge cases and how to fix failures

Email not sending or wrong recipient

The email field may be mapped wrongly between nodes, causing delivery failure.

Check email references like {{ $json.fields.Email }} or {{ $json.Email }} to match each node output.

Airtable authentication issues

An invalid or expired Personal Access Token causes API failures.

Re-enter the Airtable API Key in n8n credentials to fix this.

Google Sheets data not saving

Wrong Spreadsheet ID or sheet name (gid) will stop appending.

Verify the Spreadsheet ID and Sheet gid in node settings.

Summary of Benefits

✓ Saves time by removing manual copying from form to sheet and database.

✓ Prevents errors from manual data entry.

✓ Automatically sends personalized confirmation emails.

✓ Keeps Google Sheets and Airtable updated with fresh data.

✓ Supports easy customization to fit specific needs.