Home › Automations › Auto-sort a Google Sheet when a row is added
Trigger: Row addedAction: Sort sheet

Auto-sort a Google Sheet when a row is added

New rows always land at the bottom — and out of order. Sheet Automation re-sorts the sheet the moment a row is added, so the data is always in the right place.

Add to Google Sheets — free See the template

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

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

What it does

This automation watches for new rows (typed, pasted, or from a form) and immediately sorts the sheet by your chosen column, ascending or descending. Use it to keep leaderboards ranked, schedules in date order, and intake lists alphabetized without anyone touching the sort menu.

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 when a row is added” template.
  3. Choose the sort column and direction.
  4. Save. Add a row anywhere — the sheet snaps back into order.

The ready-made template

Auto-sort when a row is added — Trigger: a new row is added → Action: sort the sheet by column A ascending. 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 when a row is added”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

Can I sort by multiple columns?
Yes. Add more columns to the sort action — e.g. by date, then by name.
Does it sort when rows are edited too?
Use the Sheet Updated trigger instead of Row Added if edits should also re-sort the sheet.
Will it move my header row?
No. Sorting respects the frozen header row.

Related automations

Auto-sort a sheet every hour Remove duplicate rows daily Auto-number rows in Google Sheets Add a timestamp when a row is updated