Hi all,
May you help me ? I need to update a google sheet with a chat gpt result.
I do not know how to get add the result value in the google sheet. any help welcome.
Hi Greg,
You first need to ensure that your prompt returns a JSON formatted string or uses a function like ‘split’ to separate the output into distinct values.
Afterward, use ParseJSON if it’s in JSON format, which allows picking the desired values easily. If it’s text-based, applying split functions will break down the information into individual variables.
Once you have these variables, you can then map them back into your Google Sheets by using an “Add Rows” module to update the sheet with the new information
Thanks Fario,
I have never used parsejson function - I understand that I should use it in the ChatGPT block to generate differently the result - but may you precise me exactly how to use it ? may thanks 