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?
Best answer by ken.aBest answer by ken.a
Hi
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! 😊
+6Hi
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! 😊
+6Hi
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! 😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
