Skip to main content

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

I’m trying to get Zapier to add a row in my Google Sheet, but not at the very bottom. I want it to be the next blank row. Any ideas on how to do this?

 

 

Hi @mattydphoto,

Welcome to the Community! 🎉

If you use the Create Spreadsheet Row” action, rows will be added to the first blank line that the Zap sees. I recommend deleting all of the empty rows on your spreadsheet and test the Zap again to see if the rows will get added correctly.

Please keep us posted! 😊


@ken.a That worked, thank you!


Hi @mattydphoto,

You are most welcome! I’m glad it worked!

Also, I just want to add our help article regarding the common problems with Google Sheets here: https://help.zapier.com/hc/en-us/articles/8495995099533

If you have any other questions, please don’t hesitate to ask in the Community. We’re always happy to help! 😊