I want to automate the process of entering a candidate into Airtable.
Flow:
- Webhook: When a CV is submitted, it will be uploaded as an attachment to Airtable.
- 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.
- 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.
- 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: