Airtable and Google Sheets integration

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 commences with the n8n Form Trigger node, where users provide their name, location, and email address. Subsequently, the data seamlessly flows through nodes like Google Sheets, Code, Set, Airtable, Gmail, and Gmail1 for processing and storage.

• n8n Form Trigger: Gathers user input data, including Name, City, and Email.
• Google Sheets: Manages data operations related to Google Sheets.
• Code: Executes JavaScript code to manipulate data fields.
• Set: Formats and sets data values for further processing.
• Airtable: Facilitates data operations specific to Airtable.
• Gmail: Sends custom emails to the provided Email address.
• Gmail: Sends additional emails using different templates.

Each node within the workflow performs specialized tasks such as extracting date and time fields, formatting data, appending it to Google Sheets and Airtable, and sending personalized emails to the submitter. This streamlined process ensures effective handling of collected information and enhances overall data management efficiency.

Workflow Description:

1. n8n Form Trigger:

   • A trigger node that initiates the workflow upon form submission.
   • Captures essential user details like Name, City, and Email.

2. Extracting Date and Time Fields from 'submittedAt' Field:

   • Utilizes a code node to extract Date and Time information from the submitted data.

3. Format the Fields:

   • Standardizes the format of extracted fields (Name, City, Date, Time, Email) for consistency.

4. Airtable:

   • Creates a new record in Airtable with the formatted data.
   • Includes columns for Name, City, Email, Time, and Date.

5. Google Sheets:

   • Appends the formatted data to a designated Google Sheet.
   • Includes columns for Name, City, Email, Date, and Time.

6. Gmail:

   • Sends an email to the provided Email address with a customized message.
   • Subject: "Testing Text Message Delivery"
   • Message: Personalized content with a Name placeholder.

7. Gmail1:

   • Sends another email using a different template.
   • Subject incorporates the Date field for variation.
   • Message content tailored to the subject line.

Workflow Connections:

• n8n Form Trigger -> Extracting Date and Time Fields -> Format the Fields -> Google Sheets & Airtable -> Gmail
• Google Sheets -> Gmail1

This comprehensive workflow efficiently collects user data, processes it to extract Date and Time fields, stores the formatted information in Google Sheets and Airtable, and delivers tailored emails to the recipients.

Copy these templates to get started :

• Google Sheet
• Airtable

Links to Node Documentation:

1. n8n Form Trigger Documentation
2. Code Node Documentation
3. Set Node Documentation
4. Airtable Node Documentation
5. Google Sheets Node Documentation
6. Gmail Node Documentation