ChatGPT generated records to AIrtable

Hi Make.com Community,

I’m trying to automate the process of generating a record from ChatGPT via the OpenAI Assistant module in Make.com and passing that record directly to Airtable. Specifically, I want to request structured data from ChatGPT (fields like Category, Main Advice, Emojis, and Hashtags) and insert that data as a new record in Airtable.

Here’s the flow I’m looking to achieve:

  1. Request a record from ChatGPT: Use the OpenAI Assistant module to generate structured responses based on my prompts.
  2. Pass the data to Airtable: Once I get the response from ChatGPT, I want to create a new record in Airtable with the data. i was able to ask ChatGPT to answer in XML but i can’t map it to airtable either.

I’m not familiar with using webhooks, I’m wondering if there’s a more direct solution, perhaps by linking the OpenAI module and Airtable directly. If anyone has experience with a similar setup, I’d love to hear about:

  • How to generate and structure multiple fields in ChatGPT responses for Airtable.
  • Whether it’s possible to bypass Webhooks and pass data directly from OpenAI to Airtable.
  • How to map the fields from ChatGPT’s response into Airtable.

Thanks in advance for any advice!

Hi Ridz,

Webhooks are simply ways to contact a remote service without connecting directly to that service. So when you create a scenario in Make and you call it with a web browser, you’re calling a webhook.

There is an Airtable module that you can use within Make to add data to one of your tables, Are you using that at all?

As for the structured data, you can ask ChatGPT to generate JSON output, parse the JSON with the Parse JSON module of Make, then take those parsed results and insert them directly into Airtable as a new record.

Does that make sense to you? If not, ask more questions and someone will be glad to help!

L

was able to do it via the openai text to record module. thank you!

3 Likes