Hello Zapier friends!
I have a Google Sheet which I use as a database for articles. I’d like to convert these articles into shorter forms using Chat GPT, and return the shorter form content to the original database. This way, the database will automatically populate every time I add a new article. At least that is the idea.
The articles and the prompts are found on the same rows in the Worksheet. I want the Zap to trigger when a new article is created. This step works.
Secondly, I’m sending the article and the prompt (hard coded in the article) to Chat GPT using the API. Then Chat GPT returns the answer. This works fine as well.
Lastly – as mentioned – I’d like to return the answer from Chat GPT to the original worksheet/database, on the same row but in a separate (given) column. This does not work. In fact, I can’t even find the original spreadsheet in the dropdown menu when setting up the action.
I suspect there is a simple solution to this, but I don’t know what do look for.
Really appreciate any help.
Thanks
