Question

How do I auto-sort my Google Sheet by a column after Zap creates a new row without relying on external tools?


Hello all,

Pretty new to Zapier but I’m finding it an extremely productive tool.

The last thing I need to figure out is how to automatically sort the Google sheet based on one column’s entry after the Zap has completed creating the row.

Not sure if this is a Zapier question or a Google Sheets question. I have scoured YouTube and Google and all I hear is “use something else besides Google Sheets”. I have an onChange function in Google Sheets to do it but it won’t launch if Zapier creates a new row,

Any help would be greatly appreciated.

-Gabe


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

okay thanks @Troy Tessalone 

Userlevel 7
Badge +14

@oneillg 

Otherwise, I’d recommend using Airtable instead of GSheets.

Airtable has Views.

Views can be sorted.

https://support.airtable.com/docs/sorting-records-in-airtable-views

Userlevel 7
Badge +14

Hi @oneillg 

Perhaps use Filter Views in GSheets: https://support.google.com/docs/answer/3540681?hl=en&co=GENIE.Platform%3DDesktop