Mapping Response/Results from ChatGPT Vision to Google Sheets

I’m using the ChatGPT Vision module to extract “Distance” and “Time” details from an image, which it does so successfully every time. However, I’m finding it challenging to parse the ChatGPT response into something usable that can be mapped to a Google Sheet or database.

Any suggestions?

Welcome to the Make community!

Try using the OpenAI “Transform Text to Structured Data” module:

Identifies information in a prompt’s text and returns it as structured data.

For more information, see https://www.make.com/en/integrations/openai-gpt-3, and https://www.make.com/en/help/app/openai-gpt-3 in the help centre.

You can also try the Groq “Create a JSON Chat Completion” module:

Creates a model response for a given chat conversation with JSON response type.

Where to get a free Groq AI API key

  1. Go to https://console.groq.com/keys

  2. Register for a free account

  3. Click on “Create API Key”

For more information, see https://www.make.com/en/integrations/groq, and https://www.make.com/en/help/app/groq in the help centre.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Hi @jmlokitz, have you tried asking chatgpt to provide an answer in a standard json format ? Then you could json parse it.