Automated Call Data Collection and Update Workflow

This n8n workflow automates the process of managing candidate call data. It starts with a Google Sheets trigger that detects new rows added to a specific sheet, initiating the data collection process. The workflow then makes a call via an API to engage with the candidate, retrieves the call transcript, and analyzes the conversation using the Google Gemini Chat Model to extract key candidate details such as experience, CTC, and availability. The extracted information is processed through a structured output parser for clarity. Subsequently, the workflow updates the Google Sheet with the latest data, ensuring real-time information management. This automation is ideal for HR teams or recruitment agencies aiming to streamline candidate interactions and data updating, reducing manual effort and improving accuracy.