Abdulaziz This workflow corresponds to n8n.io template #5481 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "da1d59c5-9f44-41b2-9239-9656a5524bc8",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
60,
60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "be3c688c-ca01-42b8-8fd6-6b715a187683",
"name": "HTTP Request1",
"type": "n8n-nodes-base.httpRequest",
"position": [
560,
60
],
"parameters": {
"url": "https://api.cal.com/v1/bookings",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "apiKey",
"value": "YOUR API KEY HERE"
},
{
"name": "id",
"value": "={{ $json.attendees[0].bookingId }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ba372028-e10d-46c8-bac9-eb3400e5c2f4",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
960,
60
],
"parameters": {
"include": "selected",
"options": {},
"assignments": {
"assignments": [
{
"id": "7084df2d-5689-48c1-a048-2a3861261073",
"name": "Email",
"type": "string",
"value": "={{ $json.email.toLowerCase() }}"
},
{
"id": "320d00bf-cc25-46b5-b4e9-ee4ecd45db66",
"name": "Interview Schedule",
"type": "string",
"value": "={{ $json.startFormatted }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"id": "b9c03922-faf8-4c5c-87ba-cd44b8919aaa",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1440,
60
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "SUMMARY "
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY/edit#gid=0",
"cachedResultName": "Accepted"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY/edit?usp=drivesdk",
"cachedResultName": "Resumes"
}
},
"credentials": {},
"typeVersion": 4.6
},
{
"id": "06ea5046-9679-47d3-876c-d9963a5bd47c",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
1660,
60
],
"parameters": {
"include": "allOtherFields",
"options": {},
"fieldToSplitOut": "Email"
},
"typeVersion": 1
},
{
"id": "8d2456b4-8074-4b95-9f2d-9beca4f47f3a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
-260
],
"parameters": {
"content": "## \ud83d\udcc5 Cal.com Calendar Setup\nThis section fetches all bookings from your Cal.com event.\n\n- Pulls booking data via Cal.com API\n- Extracts attendee name, email, and interview time\n\n\ud83d\udd10 Be sure to insert your Cal.com API Key."
},
"typeVersion": 1
},
{
"id": "73f5783e-f0e4-40e8-88e2-067bc86880b3",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
940,
-280
],
"parameters": {
"color": 3,
"width": 420,
"height": 280,
"content": "## \ud83d\udd01 Link to Resume Screening Template\nThis workflow can be connected to the resume evaluation system.\n\n- Automatically assigns interview schedules\n- Matches bookings to existing applicants in your sheet\n\n\ud83d\udccc Useful for aligning candidate records with scheduled interviews."
},
"typeVersion": 1
},
{
"id": "4c2e0432-6b9c-4142-a17f-cb65cd31697e",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1820,
-220
],
"parameters": {
"width": 460,
"height": 220,
"content": "## \ud83e\uddf9 Data Cleanup Logic\nThis section ensures only valid candidates remain in the sheet.\n\n- Compares booking emails with accepted applicants\n- Deletes rows with missing or unmatched data (e.g. no summary)\n\n\u2705 Keeps your applicant tracking clean and relevant."
},
"typeVersion": 1
},
{
"id": "f61ef94a-6f49-4495-aa2c-9d4e8e3c02fd",
"name": "Iterate over emails",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1900,
60
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "e896a142-0045-4b18-bb84-23381fda6343",
"name": "Check for unmatched Emails",
"type": "n8n-nodes-base.if",
"position": [
2120,
160
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8aa988a0-0225-49fc-9953-e97746bc7c9b",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json['SUMMARY '] }}",
"rightValue": "="
}
]
}
},
"typeVersion": 2.2
},
{
"id": "231eee7f-33cc-4879-ab32-701543a83ec2",
"name": "Deleting",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
140
],
"parameters": {
"operation": "delete",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY/edit#gid=0",
"cachedResultName": "Accepted"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY/edit?usp=drivesdk",
"cachedResultName": "Resumes"
},
"startIndex": "={{ $json.row_number }}"
},
"credentials": {},
"typeVersion": 4.6
},
{
"id": "7fa5068c-5b7c-4bb5-bd0c-a41560221141",
"name": "Adding Time & Date for interview",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
60
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "JUSTIFICATION ",
"type": "string",
"display": true,
"required": false,
"displayName": "JUSTIFICATION ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SUMMARY ",
"type": "string",
"display": true,
"required": false,
"displayName": "SUMMARY ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Q1",
"type": "string",
"display": true,
"required": false,
"displayName": "Q1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Q2",
"type": "string",
"display": true,
"required": false,
"displayName": "Q2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Q3",
"type": "string",
"display": true,
"required": false,
"displayName": "Q3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Q4",
"type": "string",
"display": true,
"required": false,
"displayName": "Q4",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Q5",
"type": "string",
"display": true,
"required": false,
"displayName": "Q5",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"handlingExtraData": "ignoreIt"
},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY/edit#gid=0",
"cachedResultName": "Accepted"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/18vvSKGbAiodQvNsdNTJ1pBuhEcv2ADAmQKtDNAK7VQY/edit?usp=drivesdk",
"cachedResultName": "Resumes"
}
},
"credentials": {},
"typeVersion": 4.6
},
{
"id": "a30e3a25-b55e-41bd-bd25-ac6821bdec32",
"name": "Converting to time",
"type": "n8n-nodes-base.code",
"position": [
760,
60
],
"parameters": {
"jsCode": "return $json.bookings.map(booking => {\n const date = new Date(booking.startTime);\n const formatted = date.toLocaleString(\"en-GB\", {\n timeZone: \"Asia/Riyadh\",\n day: \"2-digit\",\n month: \"long\",\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: true\n });\n\n return {\n json: {\n name: booking.attendees[0].name,\n email: booking.attendees[0].email,\n startFormatted: formatted\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "365dad27-686d-4f38-9bbd-6beeb83573ca",
"name": "Fetching Booking Information",
"type": "n8n-nodes-base.httpRequest",
"position": [
340,
60
],
"parameters": {
"url": "https://api.cal.com/v1/attendees",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "apiKey",
"value": "your API KEY HERE"
}
]
}
},
"typeVersion": 4.2
}
],
"connections": {
"Deleting": {
"main": [
[
{
"node": "Iterate over emails",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Iterate over emails",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Adding Time & Date for interview",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request1": {
"main": [
[
{
"node": "Converting to time",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"Converting to time": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Iterate over emails": {
"main": [
[],
[
{
"node": "Check for unmatched Emails",
"type": "main",
"index": 0
}
]
]
},
"Check for unmatched Emails": {
"main": [
[
{
"node": "Deleting",
"type": "main",
"index": 0
}
],
[
{
"node": "Iterate over emails",
"type": "main",
"index": 0
}
]
]
},
"Fetching Booking Information": {
"main": [
[
{
"node": "HTTP Request1",
"type": "main",
"index": 0
}
]
]
},
"Adding Time & Date for interview": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Fetching Booking Information",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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 matches applicants using…
Source: https://n8n.io/workflows/5481/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This n8n workflow fetches URLs from an RSS feed, checks which URLs have a valid RSS feed and if true, fetches the latest articles from those URLs. It then stores the article details, including the art
RSS Feed Read, Stop And Error, Google Sheets +1
This workflow allows you to generate QR codes (Barcodes) in bulk from a Google Sheets file and store the generated QR images automatically in Google Drive. Each QR code contains a unique identifier (i
Google Drive, HTTP Request, Google Sheets
Automatically extracts all page URLs from website sitemaps, filters out unwanted sitemap links, and saves clean URLs to Google Sheets for SEO analysis and reporting.
Form Trigger, HTTP Request, Google Sheets
Validate and enrich phone numbers from Google Sheets using the [](https://rapidapi.com/skdeveloper/api/phone-number-validator11) API.
Google Sheets, HTTP Request
I built this tool because we faced a real, recurring problem: managing hundreds of client projects in a weekly automated loop.
Stop And Error, Redis, Execute Workflow Trigger +2