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.

Unique ID First Last Start Date Placeholder Notes Cancellation Checkbox
HA-X47 =ArrayFormula( =ArrayFormula( =ArrayFormula( =ArrayFormula(   FALSE
HA-32C John Smith 2/24 ... Needs Late Checkout FALSE
HM326 Jane Doe 5/9 ...   TRUE
IND416 Happy Gilmore 4/16 ...    
             

 

Trying to figure out why I’m not getting a zap run for a multi-step zap when adding a new row to my spreadsheet (Google Sheet). Help much appreciated. I’ve long used a Google Sheet to manage my short-term rentals and I use the booking ID as the unique ID. The rest of the columns populate with Array Formulas except Column 6 and 7 which are text notes and a checkbox for if/when a guest cancels. I don’t have the checkboxes hanging below the lowest filled-in row, in fact I generally wait a while before adding the checkboxes. Is the problem:

  1. The Unique ID + Array Formula combo doesn’t actually make Google/Zapier communicate a “New Spreadsheet Row” like it would if I were just typing in values or pasting one in whole?
  2. The blank column 6 (Notes) that only has data in some cells is the problem
  3. The Checkboxes in Column 7 are the issue
  4. Blank empty rows at the bottom of the sheet are affecting it
  5. Something else?

I created a duplicate Zap and switched the initial trigger to run off of any changes to Column A. That worked just fine so I’ll probably roll with that but would still love clarity as to what the issue is as asked above from someone who saw the post and shook their head knowingly!

Hi @Crayhead! 👋

I’m so glad you were able to get things up and running by creating a duplicate Zap that triggers for changes in a Column. 🙂

As for why the original Zap didn’t work, were any changes made to the spreadsheet like deleting rows or columns while the Zap was switched on? If so, perhaps that’s what caused a disconnect with the Zap. You can see the full list of changes that might have affected caused a disconnect here: Turn your Zap off before making changes to your sheet

Do you think that might have been the cause of the issue? If so, can you turn the original Zap off then back on again, then add a new row and let us know whether that gets it triggering again?

Reply


Terms & Conditions