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.

I have a zap setup to update a google sheet (Sheet A) when a sale is made, and then within Google (Sheet 😎 I pull data from Google (Sheet A) but when the zap triggers it adds another row to sheet B for some reason so the data cant be pulled (i.e. row 18 to row 18). Did I set this up wrong?? How would I fix it?

Hi @Kevin Wathey 

Please provide screenshots of how your Zap steps are currently configured.

Also, please outline a specific example and what you’re expecting the behavior to be.

Thanks.

 

Make sure to check the available help articles for GSheets related to Zaps: https://zapier.com/apps/google-sheets/help

Hi Troy,

Customer buys a product.
Sheet (TMM Zapier Spreadsheet) Updated Customer Information -*This works correctly
Sheet (TMM Sales Analytics) Pulls Data From Above Sheet (='TMM Zapier Spreadsheet'!C23)
 - I have the =’xx’ formula filled out for the entire sheet so essentially when a new sale gets made it should just pull that row from the previous sheet and cell, but what’s happening is what was formatted as C23 changed to C24 and every cell moves up a number and then doesn’t correspond with the row it was supposed to be affiliated with so the new data entry doesn’t pass from sheet to sheet...

Hi @Kevin Wathey 

The way Zapier works with GSheets is that it actually adds new rows (aka inserts rows) to the GSheet, meaning the number of Rows in the GSheet grows, which is why your formulas on the other tab break.

 

You may want to explore more advanced GSheet formulas

INDIRECT + ROW

FILTER

IMPORTRANGE

QUERY

ARRAYFORMULA

Thank you for the answer. 
I noticed that which is why I had it being added to a separate sheet and then trying to pull the data from that sheet as a workaround, but it adds a row to the sheet the data is being pulled into and I don’t know how to fix that...

@Kevin Wathey I suggest exploring these more advanced GSheet formulas, to isolate the desired data.

INDIRECT + ROW

FILTER

IMPORTRANGE

QUERY

ARRAYFORMULA

Hey @Kevin Wathey, hope you’re well, I just wanted to check in here!

Were you able to get things working with the info from Troy, or can we still help out here?

Terms & Conditions