Hello!
I have a question about Google Sheets.
The structure of document is like that:
I want to:
Is it possible and how to make it?
Thanks a lot!
Best answer by GetUWiredBest answer by GetUWired
Hi there,
It is possible if you add a search column to your sheet. Technically, those rows you are wanting to create already exists. Zapier has the ability to find a row and to update a row. We just need to tell it what to look for. I’ve outlined a workaround below that will accomplish what you are hoping to do.
First, you will need to add a column somewhere in your sheet that makes it easy for Zapier to search. The search value will get added every time when creating the new row. To start, you’ll just add it to the top row in your sheet.
Next, you’ll need to make a “Lookup Spreadsheet Row in Google Sheets” Zapier step. In this step, you’ll search for the lookup value on your sheet. The included screenshot is all you have to configure in this step.
When this runs, it will return the first match which will be the top row.
Next, you’ll need to do the math to the returned row value from this step using the “Formatter by Zapier” action. I’ve outlined it below. This subtracts 1 from the returned row above.
Lastly, you will set up a step to “Update Spreadsheet Row in Google Sheets”. Configure similarly to the next screenshot, using the output from the math operation for the row id, and a formula to auto increment the number,
Once it runs, it will auto increment like you’re wanting! Happy Zapping!
+10Hi
Sadly, it’s not possible - Zapier can only add a new row to the bottom of an existing Google Sheet. There is no way to override this.
+12Hi there,
It is possible if you add a search column to your sheet. Technically, those rows you are wanting to create already exists. Zapier has the ability to find a row and to update a row. We just need to tell it what to look for. I’ve outlined a workaround below that will accomplish what you are hoping to do.
First, you will need to add a column somewhere in your sheet that makes it easy for Zapier to search. The search value will get added every time when creating the new row. To start, you’ll just add it to the top row in your sheet.
Next, you’ll need to make a “Lookup Spreadsheet Row in Google Sheets” Zapier step. In this step, you’ll search for the lookup value on your sheet. The included screenshot is all you have to configure in this step.
When this runs, it will return the first match which will be the top row.
Next, you’ll need to do the math to the returned row value from this step using the “Formatter by Zapier” action. I’ve outlined it below. This subtracts 1 from the returned row above.
Lastly, you will set up a step to “Update Spreadsheet Row in Google Sheets”. Configure similarly to the next screenshot, using the output from the math operation for the row id, and a formula to auto increment the number,
Once it runs, it will auto increment like you’re wanting! Happy Zapping!
Thanks for the solution
It looks like magic)
I will try to repeat this and tell you about the results!;)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
