HomeAutomationsAuto-sort a Google Sheet every hour
Trigger: Hourly scheduleAction: Sort sheet

Auto-sort a Google Sheet every hour

Keep your data tidy automatically. Sheet Automation re-sorts your sheet every hour, so it’s always in order without you lifting a finger.

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation runs on an hourly schedule and sorts the sheet by a column you choose (ascending or descending). Great for leaderboards, queues, priority lists, and any sheet that should stay ordered as data changes.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your sheet.
  2. Pick the “Auto sort every hour” template and choose the sheet and sort column.
  3. Choose ascending or descending order.
  4. Save — the sheet now re-sorts automatically every hour.

The ready-made template

Auto sort every hour — Trigger: an hourly schedule → Action: sort the sheet by a column. Edit it live below:

Loading preview…

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

  1. Click Add to Google Sheets to install Sheet Automation (free).
  2. Open it from your sheet: Extensions → Sheet Automation → Open.
  3. Open the Templates tab and choose “Auto sort every hour”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

Is it free?
Yes — this automation works on the free plan. Paid plans add more monthly runs and advanced actions.
How often does it run?
Every hour. You can also use daily or other schedules on the trigger.
Can I sort by multiple columns?
Yes. Add more columns to the sort action, each ascending or descending.
Do I need Zapier or Make?
No. Sheet Automation runs inside Google Sheets, so there’s no third-party connector to pay for or maintain.

Related automations