Automate Your Interview Scheduling with Cal.com and Google Sheets
detail.loadingPreview
Streamline your hiring process by automatically fetching Cal.com bookings and updating your Google Sheets with candidate interview schedules. This workflow ensures accurate record-keeping and efficient candidate management.
About This Workflow
This n8n workflow automates the critical task of managing interview schedules derived from your Cal.com bookings. It begins by triggering on manual execution and then makes an HTTP request to the Cal.com API to retrieve booking details. Essential information like attendee email and interview start time is then extracted and formatted. This data is subsequently merged with your existing candidate records in a Google Sheet, appending the interview schedule. The workflow then refines the data by splitting out the email field for further processing and implements a data cleanup logic to ensure only relevant entries are maintained. Unmatched or incomplete entries are identified and deleted from the Google Sheet, keeping your applicant tracking system clean and up-to-date.
Key Features
- Automated Booking Fetching: Leverages the Cal.com API to pull in new interview bookings.
- Intelligent Data Formatting: Extracts and formats attendee emails and interview times for easy use.
- Seamless Google Sheets Integration: Updates your Google Sheets with relevant interview schedule data.
- Data Cleanup & Validation: Automatically removes incomplete or unmatched candidate records.
- Efficient Candidate Management: Ensures your applicant tracking is accurate and current.
How To Use
- Trigger: Manually click 'Execute workflow' to start the automation.
- Cal.com API Request: Configure the 'HTTP Request' node with your Cal.com API key and the booking ID you want to fetch.
- Data Formatting: Use the 'Edit Fields' node to format the attendee's email to lowercase and set the 'Interview Schedule' to the formatted start time.
- Google Sheets Update: Configure the 'Google Sheets' node ('Adding Time & Date for interview') with your Google Sheet's Document ID and Sheet Name. Map the 'Email' and 'Interview Schedule' fields to the correct columns in your sheet.
- Split Data: The 'Split Out' node separates the 'Email' field for further processing.
- Data Cleanup Logic: The 'Check for unmatched Emails' node filters rows in your Google Sheet where the 'SUMMARY ' column is not equal to '='. This effectively identifies rows that may not have relevant data.
- Delete Unmatched Rows: The 'Deleting' node is configured to remove rows from your Google Sheet based on the 'row_number' identified in the previous step, ensuring only valid entries remain.
Apps Used
Workflow JSON
{
"id": "78641783-e0fd-4f44-b327-408e9f2ba8cc",
"name": "Automate Your Interview Scheduling with Cal.com and Google Sheets",
"nodes": 16,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 78641783-e0fd...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.