Automated meeting attendee enrichment with Apollo.io and Google Sheets
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs on Calendly events (invitee.created) (plus 1 other trigger). Along the way it connects Google Sheets. It also calls api.apify.com over HTTP.
How it runs
Trigger: On Calendly events (invitee.created) (plus 1 other trigger).
- Extract Data (Edit Fields (Set)): sets 5 fields: Name, Email, Company …
- Extract data (Edit Fields (Set)): sets 5 fields: Name, Email, Company …
- Log entry (Google Sheets): append or update
- Generate Query (Edit Fields (Set)): sets or maps fields
- Create URL (Code): runs custom JavaScript code
- Scrape Apollo (HTTP Request): calls api.apify.com (POST)
- If: checks a condition and branches into true / false
- Google Sheets: append or update
- Google Sheets: append or update
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Cal.com Trigger
n8n-nodes-base.calTrigger - Code
n8n-nodes-base.code - Calendly Trigger
n8n-nodes-base.calendlyTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if
From the author
Meeting Prep: Automated Meeting Attendee Enrichment Overview This workflow automates the process of gathering critical information about your meeting attendees right after they book a meeting. Whether they book through Calendly or Cal.com, this workflow…