Automated Candidate Analysis and Interview Preparation

This n8n workflow streamlines the process of managing candidate data, generating interview preparation materials, and sending personalized PDFs via email. It begins by parsing an uploaded CSV file containing candidate information, creates a Google Spreadsheet to organize the data, and performs various data manipulations such as selecting specific rows based on certain criteria. The workflow integrates AI language models (Ollama Chat Model and Job Interview Prep Agent) to analyze candidate data, generate tailored interview questions, and prepare PDFs containing essential information. It also includes search functionalities and updates to the spreadsheet to track interview statuses or additional data. Practical use cases include HR departments or recruitment agencies aiming to automate candidate data processing, generate interview guides, and send personalized insights or assessments efficiently.