ChatGPT Table Output to Google Sheets

[Robert_B]

Hello Make Community,

Hoping someone can help me figure out the best way to accomplish this in the most elegant way…

I am using the OpenAI (ChatGPT) module to generate data that OpenAI returns as a table. Basically it’s 5 columns of different data across several rows.

I’d like to get this ChatGPT output into a Google Sheet (properly structured in rows/columns).

I was thinking the best way is to instruct ChatGPT to return a CSV value, and then somehow parse the CSV data into a Google Sheet… but I’m not sure that’s the best way.

I’m also running into issues where the ChatGPT data has a comma “within” one of the cells, then it gets all messed up because now there’s an extra comma.

I’m sure others will want to go from ChatGPT to Google Sheets as well, so ideally in the future this will helps others, too!

If anyone can show me a scenario flow that does this successfully that would be amazing and very much appreciated.

Thanks in advance!

[samliew]

Yes, that is possible. You’ll need these four modules:

This is just an example. Your final solution may or may not look like this depending on your requirements.

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

— @samliew