How can I get the different information out of this ChatGPT response, so that I can save it into different columns in a Google Sheet?
E.g.: Booking Date, Time, Booking Tour Name, etc.
Please help 
I’d recommend learning about JSON responses from OpenAI
Some ideas are at Help Needed: Structuring Website Form Data into a JSON Array - #2 by drnic
For example the OpenAI module “Transform Text to Structure Data”. Then you’ll have nice make objects you can pull data from.
1 Like
Welcome to the Make community!
The most reliable way is to probably use the OpenAI “Transform Text to Structured Data” module, or the free Groq “Create a JSON Chat Completion” module.
Example
Here is a Groq example on how to specify the variables that you want to match from the text content. This setup is also similar to what you’d do with the OpenAI Structured Data module.
Output
(Google’s about page didn’t contain any Google email or phone numbers, so it was left empty)
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!