This workflow automates data collection from an n8n form, processes it, and stores it in Airtable and Google Sheets, while also sending confirmation emails. It starts with a form trigger that fires upon submission, collecting user inputs such as name, city, and email. A code node then extracts the date and time from the submission timestamp, splitting it into separate fields. These formatted fields are set up in a ‘set’ node to organize the data for storage. The data is then appended to an Airtable base and a Google Sheet for record-keeping. Additionally, two Gmail nodes send personalized emails: one to confirm receipt of the data and another with a timestamped subject for further communication. This workflow is ideal for automating user submissions, record management, and automated email notifications, making it perfect for event registrations, surveys, or customer feedback forms.
Data Collection & Notification Workflow with n8n
Node Count | 6 – 10 Nodes |
---|---|
Nodes Used | airtable, code, formTrigger, gmail, googleSheets, set, stickyNote |
Reviews
There are no reviews yet.