n8n Workflow: Parse CVs from Emails with OCR & GPT for Notion Database

This n8n workflow automates the process of extracting information from CVs received via email, potentially using OCR for image-based CVs, and then leveraging OpenAI's GPT to structure and save this data into a Notion database.

It streamlines the candidate screening process by automatically populating your Notion recruitment database with key details from incoming resumes.

What it does

1. Triggers on New Emails: Listens for new emails in a specified Gmail inbox.
2. Processes Email Content: Extracts relevant information from the incoming email.
3. Applies Conditional Logic: Checks for specific conditions within the email or its attachments (e.g., if a CV is present or requires OCR).
4. Performs OCR (Implicit): While not explicitly shown as an OCR node, the HTTP Request node can be configured to interact with an OCR service if the CVs are in image format.
5. Extracts & Structures Data with OpenAI: Sends the CV content (text or OCR output) to OpenAI's GPT model to parse and extract structured information (e.g., name, contact, experience, skills).
6. Prepares Data for Notion: Transforms the extracted data into a format suitable for a Notion database entry using the Edit Fields (Set) node.
7. Saves to Notion Database: Creates a new page/item in a specified Notion database with the parsed CV data.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Gmail Account: Configured as a credential in n8n for the Gmail Trigger node.
• OpenAI API Key: Configured as a credential in n8n for the OpenAI node.
• Notion Account: Configured as a credential in n8n for the Notion node, with access to the target database.
• OCR Service (Optional): If you expect image-based CVs, you might need an external OCR service (e.g., Google Cloud Vision, AWS Textract, or a self-hosted solution) and configure the HTTP Request node to interact with its API.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the Gmail Trigger, OpenAI, and Notion nodes.
   • Click on each node and select or create the necessary credentials for your Gmail, OpenAI API Key, and Notion integration.
   • For Notion, ensure your integration has access to the database where you want to store the CV data.
3. Configure Gmail Trigger:
   • In the Gmail Trigger node, specify the mailbox and any filters (e.g., sender, subject keywords) to ensure it only processes relevant emails containing CVs.
4. Configure HTTP Request (for OCR, if applicable):
   • If you need OCR, configure the HTTP Request node to send the attachment content to your chosen OCR service's API. You'll need to handle authentication and parse the response.
5. Configure OpenAI Node:
   • Adjust the prompt in the OpenAI node to accurately guide GPT on how to extract specific fields from the CV text. Provide examples of the desired output format (e.g., JSON).
6. Configure Edit Fields (Set) Node:
   • Map the output from the OpenAI node to the desired field names for your Notion database.
7. Configure Notion Node:
   • Select the Notion database where you want to add the parsed CV data.
   • Map the fields from the Edit Fields (Set) node to the corresponding properties in your Notion database.
8. Activate the Workflow:
   • Once all configurations are complete, save and activate the workflow. It will now automatically process incoming emails according to your setup.