Hello community,
I am parsing data between OpenAi and Google Sheets. I need to structure the data into columns in Google Sheets.
I don’t have enough knowledge of Make yet to handle this myself, and the chatbot isn’t helping with this issue.
How can I make sure that the sections Title, Ingredient, Instructions, Cooking time, Category, Cuisine, and Difficult are in a separate bundle so that I can transfer it to Google Sheets?
Thank you in advance for your help!
cod output.txt (5.9 KB)
Hello,
Welcome to the community.
The easiest way is to force your LLM to output JSON.
In Make.com and OpenAI modules, you can do this very simply by toggling on “Advanced settings” and changing the type to JSON Schema or JSON Object.
Schema must be configured in the module, while Object can be defined within the prompt.
Then, after the first run, Make.com will parse the output and allow you to use it as mappable items.
If you need further assistance- please send us more details about your output and the problems blocking you.
If that helps - mark the solution - it will help others!
It works! I had to tinker with the code for this section a bit, but it all worked out! Now OpenAI provides structured information and I can transfer it further as I need!
Thank you for your help!
You’re welcome! Glad it works!
