Developer & DevOps
Extract Airtable Records and Send Formatted Gmail Messages
13 nodes
277
156
Scheduled trigger
Workflow Description
A scheduled automation that retrieves records from Airtable tables and transforms them into formatted email messages sent automatically via Gmail. This eliminates manual data distribution and enables consistent delivery of reports and updates on a defined schedule.
How it works
- 1.Execute the automation according to a predefined schedule
- 2.Connect to Airtable and fetch records from the specified table
- 3.Process and transform data into formatted text using custom code
- 4.Format the content as HTML for professional email presentation
- 5.Send the formatted message via Gmail to designated recipients
Use cases
- Send weekly project status reports from Airtable to team members
- Distribute updated task lists from Airtable to department stakeholders
- Deliver scheduled data summaries and performance metrics to management
Requirements
- Active Airtable account with a table containing data to extract
- Enabled Gmail account with sending permissions configured in n8n
- Defined recipient list and desired execution schedule
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Airtable
Gmail
Details
Trigger
Scheduled trigger
Nodes
13
Apps
2
Views
277
Downloads
156
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (13)
/
Everyday at 7PM
Schedule Trigger
Airtable Get Today's Orders
Airtable
Yesterday Date
Code
HTML
HTML Page
Set Order Fields
Set
Send to Gmail
Gmail
Store Order
Airtable
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Webhook
Webhook