Zum Inhalt springen
ai-agentPro — €97

Streamline data from an n8n form into Google Sheet and Airtable

90/100
10 Nodes

Beschreibung

Workflow with 10 nodes using Form Trigger, Code, Set...

Setup-Anleitung

### Workflow Description:

1. **n8n Form Trigger:**
   - A trigger node that initiates the workflow when a form is submitted.
   - Form fields include Name, City, and Email.

2. **Extracting Date and Time Fields from 'submittedAt' Field:**
   - A code node that extracts Date and Time from the submittedAt field.

3. **Format the Fields:**
   - Sets the format for the extracted fields (Name, City, Date, Time, Email).

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 Google Sheet.
   - Includes columns for Name, City, Email, Date, and Time.

6. **Gmail:**
   - Sends an email to the provided Email address.
   - Subject: "Testing Text Message Delivery"
   - Message: Customized message with Name placeholder.

7. **Gmail1:**
   - Sends another email using a different template.
   - Subject includes the Date field.
   - Similar message content with a different subject line.

### Workflow Connections:
- n8n Form Trigger -> Extracting Date and Time Fields -> Format the Fields -> Google Sheets & Airtable -> Gmail
- Google Sheets -> Gmail1

This workflow collects data from a form submission, processes it to extract Date and Time fields, saves the formatted data to Google Sheets and Airtable, and sends customized emails to the submitter.

Benötigte Integrationen (7)

Form Trigger

Form Trigger

Code

Code

Set

Set

Airtable

Airtable

API Key

Sticky Note

Sticky Note

Google API

Google Sheets

API Key

Gmail

Gmail

API Key

Workflow freischalten

Kaufe das Pro Bundle für €97 — erhalte sofortigen Zugang zu diesem und allen weiteren Starter + Pro Workflows als ZIP-Datei zum Import in n8n.

Sichere Zahlung via Stripe. 7-Tage Geld-zurück-Garantie.
← Zurück zum Marketplace