Automate interview scheduling and data cleanup with Cal.com and Google Sheets
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.cal.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetching Booking Information (HTTP Request): calls api.cal.com
- HTTP Request: calls api.cal.com
- Converting to time (Code): runs custom JavaScript code
- Edit Fields (Edit Fields (Set)): sets 2 fields: Email, Interview Schedule
- Adding Time & Date for interview (Google Sheets): append or update
- Google Sheets: uses Google Sheets
- Split Out: splits a list into separate items
- Iterate over emails (Loop Over Items (Split in Batches)): loops over the items in batches
- Check for unmatched Emails (If): checks a condition and branches into true / false
- Deleting (Google Sheets): delete
Services it uses
HTTP calls to: api.cal.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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
Workflow Description Automate your candidate interview pipeline with precision. This powerful integration pulls booking data from Cal.com, extracts interview details (name, email, date & time), and syncs them directly into your Google Sheets tracker. It…