Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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

 

Hey @earlybird, welcome to the Community!

Hmm, if you can’t select the existing spreadsheet from the list of available options in the Spreadsheet field’s dropdown menu there’s a couple things I’d suggest trying:
 

1) Start typing the name of the spreadsheet in the list then click on the Load more button (you may need to do it a few times depending on how many spreadsheets you have) to pull in more spreadsheets:

316785101b05dc8949fe3958bac70652.png
That should allow the Zap to then load in the missing spreadsheet.

2) Alternatively you can temporarily add a Google Drive Find a File action to search for the Spreadsheet and obtain it’s ID number. Then you can copy the ID number from the ID field that’s output when testing:
125cf67b1e87830b8bafaecdb1b1babc.png

Next, in the Update Spreadsheet Row action, use the Custom value option to manually select the spreadsheet that way:
f4203379b199bad48140c44a4f869c77.png

Then you can remove that Find a File action it won’t be needed if the Zap is going to be updating the same spreadsheet every time.

Can you give either of those a try and let me know how you get on?

Reply


Terms & Conditions