Automate CV Parsing and Airtable Storage with OpenAI

Overview

This n8n workflow is designed to automate the process of collecting and organizing job applications. It begins with a form trigger (Step 1 of 2 - Upload CV) that allows applicants to submit their CVs. The uploaded PDF file is then processed by the Extract from File node to extract its content. This extracted text is fed into an OpenAI Chat Model (OpenAI Chat Model2) to classify the document, ensuring it's a CV. If classified as a CV, another OpenAI Chat Model (OpenAI Chat Model1) is used to parse the CV's content into a structured JSON format based on a predefined schema, capturing details like Name, Address, Email, Education, Skills, Experience, and a Cover Letter. A Structured Output Parser node ensures the output adheres to the defined schema. Finally, the parsed data is saved to an Airtable base using the Save to Airtable node, and the original PDF file is also attached to the Airtable record via the Upload File to Record node. A Form Success node provides a confirmation message to the applicant.