I have an automation in which with every call booked on Calendly, the and there details are put onto a google sheet, currently its in order of what time booked but want to switch it to chronological order of when the calls themselves are
Best answer by MohSwellam
View original
+8
Hi
This is something to do in Google Sheets, you just need to change the sorting to be for the field you want.
+14
Hi
Good question.
Be aware that sorting a GSheet can break the Zaps.
You’d be better served using Airtable instead of GSheets.
Airtable has Views, which are segments of data. (sort, filter, group, show/hide fields, reorder fields)
If your Google Sheets trigger stops working suddenly, first check if you’ve accidentally inserted a blank row anywhere in the spreadsheet. Zapier interprets a blank row as the end of the spreadsheet and may have trouble finding any new rows below it.
In addition to this, making the following changes to your spreadsheet while the Zap is turned on can cause errors:
If you need to make any of those changes to your Google Sheet, turn your Zap off while you work on the spreadsheet, and then turn it back on again.
TipTry Zapier Tables as a replacement for Google Sheets steps. Zapier Tables is a data storage solution built for automation and made to work with Zaps.
+8
I totally agree with
this is why you would use Filter Views in Google Sheets (found at the very end of the tool bar, right before the Sigma sign).
I do vote for Airtable as well though
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
