n8n templatesn8n templates

Streamline Data from an n8n Form into Google Sheets and Airtable

This workflow is designed to automate the collection and management of user data. It gathers information through customized forms and breaks down the submission time into date and time fields. The organized data is then synchronized and saved to Google Sheets and Airtable. At the same time, the system automatically sends personalized emails to the submitters, enhancing user experience and feedback efficiency. This workflow is suitable for scenarios such as marketing, customer support, and event registration, effectively reducing manual operations and improving work efficiency.

Workflow Diagram
Streamline Data from an n8n Form into Google Sheets and Airtable Workflow diagram

Workflow Name

Streamline Data from an n8n Form into Google Sheets and Airtable

Key Features and Highlights

This workflow collects user data from a custom n8n form, automatically extracts and separates the submission timestamp into date and time components, and synchronizes the formatted data to both Google Sheets and Airtable databases. Additionally, it sends two personalized test emails based on the submitted email address, achieving fully automated data collection, multi-platform synchronization, and user feedback.

Core Problems Addressed

  • Simplifies the manual process of organizing and entering form data, eliminating redundant work and preventing data loss;
  • Automatically extracts and splits the submission timestamp field to enhance readability and improve efficiency for subsequent data analysis;
  • Enables multi-platform data synchronization, ensuring data is updated simultaneously in Google Sheets and Airtable;
  • Automates email notifications to improve user experience and feedback efficiency.

Use Cases

  • Scenarios requiring collection and centralized management of basic user information (name, location, email);
  • Situations where form data needs to be saved across multiple data platforms for use by different departments or tools;
  • Cases requiring automatic email confirmation or follow-up with submitters, suitable for customer service, marketing event registrations, data collection, and similar applications.

Main Workflow Steps

  1. n8n Form Trigger: Listens for and triggers on form submissions, capturing information such as name, city, and email.
  2. Code Node (Extracting Date and Time Fields): Parses the submittedAt timestamp field, splitting it into separate Date and Time fields.
  3. Format the Fields: Standardizes the name, city, email, date, and time fields for consistent downstream processing.
  4. Write Data to Airtable: Adds the formatted data as a new record in Airtable.
  5. Write Data to Google Sheets: Appends the same data to a specified Google Sheet.
  6. Send Emails (Gmail & Gmail1): Sends two personalized test emails to the submitted email address using separate email templates.

Systems and Services Involved

  • n8n Form Trigger: Collects form data and initiates the workflow
  • Code Node: Custom JavaScript code for processing the timestamp field
  • Airtable: Cloud database for structured data storage
  • Google Sheets: Online spreadsheet for data viewing and sharing
  • Gmail: Email service used to send automated notifications

Target Users and Value

  • Businesses and teams needing efficient user data collection and management;
  • Marketing, customer support, event registration, and other departments requiring multi-channel data synchronization and automated communication;
  • Automation enthusiasts and technical teams looking to quickly build no-code or low-code data flow solutions to boost productivity and reduce human error.