Best answer

How do I add a row in Google Sheet using Zapier as the next blank row?

  • 4 June 2023
  • 3 replies
  • 105 views

Userlevel 1

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?

 

 

icon

Best answer by ken.a 5 June 2023, 04:23

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.

3 replies

Userlevel 7
Badge +6

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! 😊

Userlevel 1

@ken.a That worked, thank you!

Userlevel 7
Badge +6

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! 😊