Skip to main content
Question

Trouble syncing Google Sheets with ChatGPT and back to Google Sheets


 

What I’m trying to do is have Zapier detect new spreadsheet entries under the “Article” column in google sheets, take that article into various different chatgpt prompts, then send it back to Google sheets in different columns but the same row. It all works perfectly if I use “Test Zap” through each stage, but when I turn it on it doesn’t automatically detect the new article, I’ve tried putting the article when the zap is on, and when it’s off, with neither having any luck. 

 

Any ideas? Thanks!

Did this topic help you find an answer to your question?

2 replies

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2203 replies
  • February 12, 2025

Hi ​@will2,

 

Welcome to the Community.

 

If your Zap isn't detecting new entries in Google Sheets when turned on, it could be due to a few common issues. First, ensure your trigger is set to "New Spreadsheet Row" and running in real time. Test the trigger with a fresh entry after turning on the Zap, as Zapier may not recognize existing rows. Check Google Sheets permissions to confirm Zapier has access, and review any Delay or Filter steps that may be interfering. Ensure column mapping is correct in both the trigger and action steps, and verify you're using the same data entry method for testing.

 

I hope this helps. Let us know if you need further assistance.


Troy Tessalone
Forum|alt.badge.img+14

Hi ​@will2 

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

You will want to add a Filter as Zap step 2 to check the desired column has a value.

 

Check your Zap History for Zap Runs to help you troubleshoot: https://zapier.com/app/history/

 

I’d recommend using Airtable instead of GSheets.

https://zapier.com/apps/airtable/integrations#triggers-and-actions