Extract Airtable records and distribute via Gmail automatically
Workflow Description
Scheduled automation that retrieves records from Airtable tables, processes them with OpenAI to extract key information, removes duplicates, and routes the organized data through conditional logic to send formatted emails via Gmail to designated recipients.
How it works
- 1.Trigger scheduled scan and fetch records from your Airtable base
- 2.Process text with OpenAI to extract relevant information and insights
- 3.Remove duplicate entries and organize extracted data
- 4.Route data through conditional paths and send formatted emails to Gmail
Use cases
- Automatically send customer updates from Airtable to team members on a recurring schedule
- Distribute periodic reports extracted from Airtable tables to specific email addresses
Requirements
- Active Airtable account with organized data tables and API access
- Gmail account and OpenAI API key for intelligent text processing and email delivery
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
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 (24)
Grants to List
Split Out
Get Grant Details
HTTP Request
OpenAI Chat Model
OpenAI
Summarize Synopsis
Information Extractor
Eligibility Factors
Information Extractor
OpenAI Chat Model1
OpenAI
Merge
Merge
Save to Tracker
Airtable
Only New Grants
Remove Duplicates
AI Grants since Yesterday
HTTP Request
Get New Eligible Grants Today
Airtable
Generate Email
HTML Page
Everyday @ 9am
Schedule Trigger
Everyday @ 8.30am
Schedule Trigger
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Get Subscribers
Airtable
Send Subscriber Email
Gmail
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note