Automating candidate data entry and skills mapping in airtable using GPT

I want to automate the process of entering a candidate into Airtable.

Flow:

  1. Webhook: When a CV is submitted, it will be uploaded as an attachment to Airtable.
  2. PDF to Text Conversion: The CV will be sent to a PDF to Text converter, and the resulting text will be sent in JSON format to GPT.
  3. CV Parsing: GPT will parse the CV and return essential candidate information such as name, surname, address, phone number, email, etc. It will also identify the candidate’s skills and technologies.
  4. Skills and Technologies Mapping: In Airtable, I have a table with predefined skills and technologies. I want these skills and technologies to be automatically mapped to those of the candidate. If a candidate has a skill or technology that is not already in Airtable, it should be added to the system automatically.

Issue: I have successfully automated the entry of the name, surname, phone number, email, etc. However, I am stuck on the part of mapping and adding skills and technologies.

How can I achieve this mapping and automatic addition in Airtable?

Make.com basic scenario:

Hi,

  1. Easiest way. Your GPT should return always the same JSON structure so you will be able to map it to existing Airtable fields. For example, if skills in Make are not mentioned by the candidate, they should get a value of null. There is no option to map it dynamically with the native “Update a Record” module.
    However, you can always try to build a custom API request to Airtable.

  2. To add fields, you must use the “Make an API Call” module. Refer to the Airtable API documentation for creating fields: Airtable API Documentation.

Hey,

I don’t know if i am aware to share something external to Make here, but this is précisely what askair.ai is doing

First you set up your table with every columns you need, and you add description to your columns
Second you connect askair to it, you obtain an email for the extractor
Third, you send your document to the extractor email, it parses the document and it fills an airtable record for you !