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.

Hi

We have a few automations with gsheets. Whenever someone sorts the columns or moves rows, zaps go crazy. I have tried every such workaround

Is there anything new to overcome this? Even asking the employees to let me know when its happening, still doesnt always work. 

I was thinking, can i create a tab in the gsheet that is a simple on/off and when the cell turns to off, the zap will trigger itself to turn itself off. Is this possible? If not, is there another workaround? 

we dont use airtable or zapier tables. i even tried having zaps send to airtable or zapier tables and then zap from there, but it still duplicated and didnt do the job

Hi @danielle879235 

GSheets have a fair amount of limitations to be aware of when used in Zaps.

GSheets actively touched by humans are at high risk for breaking Zaps or causing lots of Zap Runs to fire thus wasting Tasks.

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

 

I’d recommend using Airtable instead of GSheets.

Airtable has Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)

Views can be used to trigger Zaps. (e.g. New Record in View > Zap runs)

Views can be locked to prevent editing the configured conditions.

Airtable has defined field types, which helps with data normalization/standardization/consistency.

 

 

Sounds lovely and all, but our entire operation works with gsuite (unfortunately). 

Is there a way to keep gsheets as the main data entry and have it zap to an airtable account/sheet and then zap what we really need from there?

@danielle879235 

You’ll likely encounter the same issues trying to send the data from GSheets to Airtable due to the human interference while interacting with the GSheet.

 

Terms & Conditions