Connect Google Calendar with Clearbit andGmail
Workflow Description
Automatically retrieve scheduled events from Google Calendar, enrich attendee information through Clearbit's database, and send comprehensive email summaries containing company details and contact information via Gmail at regular intervals.
How it works
- 1.Trigger scheduled execution to fetch upcoming Google Calendar events
- 2.Process and split each event to extract attendee names and email addresses
- 3.Send attendee data to Clearbit API to retrieve company information and enriched profiles
- 4.Merge enriched data with event details and format using HTML template
- 5.Deliver formatted email via Gmail containing event summary and enhanced attendee information
Use cases
- Prepare professional meetings by gathering comprehensive attendee background information beforehand
- Track client and partner interactions by linking personal data with their company profiles
- Generate automated pre-meeting reports with attendee backgrounds and company information
Requirements
- Authenticated connections to Google Calendar, Gmail, and active Clearbit account
- Enabled Clearbit API access for retrieving company data
- Pre-configured HTML email template for displaying enriched information in organized format
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 (19)
Get recetn tweets
HTTP Request
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
Format LinkedIn Posts
Code
Format Tweets
Code
Combine all activity for a company
Merge
Extract data for email
Set
Prepare email template
HTML Page
Switch
Switch
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Keep only ones with the domain
Filter