In “Row Number” value, what should i incert for it to update one row below every time.
My Zap is connected to WIX form, after form is filled, i need Zapier to update empty row with user’s info
Best answer
How to update next row every time in Google Sheets
- Beginner
Best answer by Danvers
Hi
If you want the Zap to fill in the next empty row in a sheet, you need to use the Create Spreadsheet Row action rather than Update Spreadsheet Row.
One thing to remember is that the Google Sheet Row must be completely empty. For example, if there is a formula in a column the Zap will read that row as having something in it and will not treat it as an empty row.
I hope that's clear, please let us know if you have any questions!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Staff
- Answer
Hi
If you want the Zap to fill in the next empty row in a sheet, you need to use the Create Spreadsheet Row action rather than Update Spreadsheet Row.
One thing to remember is that the Google Sheet Row must be completely empty. For example, if there is a formula in a column the Zap will read that row as having something in it and will not treat it as an empty row.
I hope that's clear, please let us know if you have any questions!
- Beginner
Hi
If you want the Zap to fill in the next empty row in a sheet, you need to use the Create Spreadsheet Row action rather than Update Spreadsheet Row.
One thing to remember is that the Google Sheet Row must be completely empty. For example, if there is a formula in a column the Zap will read that row as having something in it and will not treat it as an empty row.
I hope that's clear, please let us know if you have any questions!
Im using formulas in a few columns, so i need Zapier just to update some of them im row. Can i make it so it will update the empty one?
+8- Zapier Staff
Hi
Before moving forward, I want to make sure I am clear on what you are trying to accomplish. Are you looking to only update some rows under specific columns?
- Beginner
Hi
Before moving forward, I want to make sure I am clear on what you are trying to accomplish. Are you looking to only update some rows under specific columns?
Yes, that is right. How do i use the filter in this case?
+8- Zapier Staff
Choose the specific column you’d like to trigger under.
And then map the same fields over when using the Filter Step
I’m not sure which approach you’d like to use, but choose one of the conditions, and fill in the rest of the information as pertains to the flow you’d like to set up.
Hope this helps a bit! If not, you can always reach out to one of our experts who will be able to help you get this set up 1:1 😀
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.