Notifications
Clear all
Topic starter
I'm looking to automate the process of adding a candidate to Airtable.
My intended workflow is as follows:
- Webhook: When a CV is submitted, it will be uploaded as an attachment in Airtable.
- PDF to Text Conversion: The CV will be sent to a PDF to Text converter. The resulting text will then be forwarded in JSON format to GPT.
- CV Parsing: GPT will parse the CV and extract key candidate details like name, surname, address, phone number, and email. It will also identify the candidate's skills and technologies.
- Skills and Technologies Mapping: Within Airtable, I maintain a table of predefined skills and technologies. The goal is to automatically map these to the candidate's identified skills and technologies. If a candidate possesses a skill or technology not currently listed in Airtable, it should be automatically added to the system.
The Challenge: I've successfully automated the entry of basic information such as name, surname, phone number, and email. However, I'm encountering difficulties with the mapping and automatic addition of skills and technologies.
How can I implement this mapping and automatic addition functionality within Airtable?
A basic scenario using callin.io:
Posted : 16/07/2024 10:18 am
Hi,
-
The most straightforward method is to ensure your GPT consistently returns the same JSON structure, allowing you to map it to your existing Airtable fields. For instance, if a candidate doesn't mention skills, they should receive a
nullvalue. The native “Update a Record” module doesn't offer dynamic mapping for this.
Alternatively, you could explore building a custom API request to Airtable. -
To add fields, you'll need to utilize the “Make an API Call” module. Consult the Airtable API documentation for guidance on creating fields: Airtable API Documentation.
Posted : 16/07/2024 1:22 pm
Hi everyone,
I'm not sure if I should be sharing external tools here, but this is exactly what askair.ai does.
- First, you set up your table with all the necessary columns and add descriptions for each.
- Next, you connect askair.ai to it, and you'll receive an email address for the extractor.
- Then, you send your document to the extractor's email. It parses the document and populates an Airtable record for you!
This process allows you to automate data entry into Airtable using documents.
Posted : 07/10/2024 5:55 pm