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.

Hey,

I have a google sheet with thousand of rows in it, populated by Zapier.

I want the new row always to enter in the last free row (if 2100 rows exist, next row will be 2101)

I’m facing kind of a problem, although i think its by design - and i’m looking for a quick solution:

When i’m filtering the data in the sheet, lets say now the sheet shows only 4 rows (row no. 101, 220, 340, 500), and the zap is triggered, the new row will enter in row number 501, pushing all the rows 1 forward - although i need it to enter in 2101 as its the next free row in the sheet.

I didn’t find a solution for it though a dedicated zap action or setting. Am i missing something? Maybe theres even a setting in google sheet side that i’m not aware of? 

I solved it for now by managing a forumla in another sheet that calculates the next free row, and edited all my zaps to edit an existing row (which is empty) in that row number instead of adding a new one.

I’m looking for a more simple solution, as this one has some risks in it - if the formula gets it wrong for some reason, my new rows can be overrun.

 

Any help or ideas will be much appreciated :) 

 

 

Hi there!

As you mentioned, I believe this is by design, given how Google Sheets works. When you have your rows filtered and the Zap sends a new row to your sheet, it will add it after the last row that’s shown (with your filter active) as opposed to the absolute bottom of the worksheet. I tested it out to make sure, and just as you described it, my row was added after the last visible row.

BUT, if you use a Filter View instead, it appears to add it at after the last row that contains data. So…

 

 

Can you test it with a Filter View instead of just using Create a filter?

Dude, You’re a genius! That solves my problem perfectly, and makes my zaps simpler.

Thank you so much for taking the time,

Much appreciated, Ron.

Terms & Conditions