How do I add a new row below the header and above other data in an order board?

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

Page 1 / 1

Hi @horti

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)

@Troy Tessalone Interesting! I’ll take a look.

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

@horti

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

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.

Hi @horti,

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!

Sign up