Hey there,
Are there any plans to add functionality to add a new row below the header and above other data? Or is there a workaround someone knows?
We add orders to an order board with newest at the top.
Thank you!!
Best answer
How do I add a new row below the header and above other data in an order board?
- Tinkerer
Best answer by horti
we’re just going to stop putting new orders at the top and put them at the bottom instead. this will solve our issues with automation.
We appreciate the help fellow Zapier enjoyers.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Good question.
You may want to consider using Airtable instead of GSheets.
Airtable has Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)
- Tinkerer
I wonder if theres a workaround involving adding a blank row underneath the headers, then a trigger adds the content, and another blank row above?
I will test this
+14- Zapier Orchestrator & Solution Partner
Help articles to reference for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help
NOTE: The below feedback may impact other Zaps you have configured with GSheets.
Yes, it’s possible, but involves using the GSheets API: https://developers.google.com/sheets/api/guides/concepts
- Tinkerer
- Answer
we’re just going to stop putting new orders at the top and put them at the bottom instead. this will solve our issues with automation.
We appreciate the help fellow Zapier enjoyers.
+6- Zapier Staff
Hi
That’s awesome! Glad to hear you were able to get it sorted!
Additionally, Zaps are intended to only add rows to the end of the spreadsheet and not any other row. More about this here:
If you have any other questions, please don’t hesitate to reach out to 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.