Enrich Google Calendar attendees with Clearbit data and email summaries via Gmail
Workflow Description
A scheduled automation that extracts Google Calendar events, retrieves attendee intelligence from Clearbit, generates AI-powered summaries using OpenAI, and delivers formatted reports through Gmail.
How it works
- 1.Extract scheduled calendar events from Google Calendar
- 2.Query company and attendee information from Clearbit for each participant
- 3.Process and filter data, then generate analytical summary with OpenAI
- 4.Format report as HTML and send via Gmail to recipients
Use cases
- Build attendee profiles and company backgrounds before important meetings
- Automatically track and report on companies participating in scheduled events
- Create intelligent meeting summaries and distribute them to your team
Requirements
- Active Google account with Calendar and Gmail API enabled
- Valid Clearbit API key for company data enrichment
- OpenAI API key for text summarization and analysis
- List of recipient email addresses for automated report 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 (21)
Setup
Set
Every morning @ 7
Schedule Trigger
Get meetings for today
Google Calendar
Get attendees email domains
Set
Split Out
Split Out
Get recent LinkedIn posts
HTTP Request
Enrich attendee company
Clearbit
Gmail
Gmail
Combine all activity for a company
Merge
Extract data for email
Set
Prepare email template
HTML Page
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Keep only ones with the domain
Filter
Extract important data
Set
Extract important data again
Set
Ask AI to summerize
OpenAI
Switch
Switch
Wrap everything together
Merge
Sticky Note2
Sticky Note
Get latest tweets
HTTP Request