About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

New spreadsheet row triggers (Google Sheets)

  • 27 February 2020
  • 7 replies
  • 314 views
W
Userlevel 2

We used to have the option to trigger a new row based on a certain column; now I seem to be getting errors when a new row is added and the columns are filled one by one. How can I avoid this issue?

Ex:

A recruiter is at a fair. A potential client fills in Name, then Phone number, then Field of studies.

The flow seems to be triggering as soon as the name as filled, and since phone number and field of studies are filled after the name (and after the row is created) it is marking an error even though the information does get filled in later on.

I understand that a potential workaround would be to only copy in fully filled rows, but it kind of defeats the purpose of having the automation automatic.


icon

Best answer by WebmasterWI 5 March 2020, 15:55

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Danvers
Userlevel 7
Badge +12

With the New or Update Spreadsheet Row trigger it is possible to specify that the Zap should only trigger if a certain column changes.

Could I trouble you to please share a screenshot of the trigger set up so that we can see if there's something there that's causing the Zap to trigger when any column is filled?



W
Userlevel 2

Captura de Pantalla 2020-02-28 a la(s) 9.30.42 a. m..pngthe weird thing is that I USED to have the option to select the column but now it doesn't let me... It DOES have column headers - are they not selectable if the first row is frozen?


Danvers
Userlevel 7
Badge +12

Frozen rows or columns can sometimes mess up Google Sheets Zaps, so it would definitely be worth unfreezing that row and trying again.


W
Userlevel 2

How frustrating!

I just removed the frozen row, and also added a new row which has no filters, but it still doesn't give me the option to select which row is the trigger. Any other tips?

Captura de Pantalla 2020-03-04 a la(s) 10.37.10 a. m..pngCaptura de Pantalla 2020-03-04 a la(s) 10.39.38 a. m..png


W
Userlevel 2

Also just gave it a try with a completely new and fresh spreadsheet and still no luck!

Captura de Pantalla 2020-03-04 a la(s) 10.49.37 a. m..png


Danvers
Userlevel 7
Badge +12

Hmm, that's an odd one.

Could you do a bit of an experiment and delete the row with filters completely? So that you just have one header row with the titles of each column. You can do that in your new test sheet to make sure that you're not messing with the original data.

Then make sure sure that you click the 'Refresh fields' button in the Zap so that it goes back to the sheet to check for the header row.


W
Userlevel 2

Hello!

Good news - I was able to find the option to select the column. I was expecting to see it in the screen where I was selecting the Spreadsheet and Worksheet, but it turns out I was selecting the wrong trigger and the Column selector wasn't until the next step in the process.

Yesterday I was able to get it working :)


Terms & Conditions