Apps Script for Beginners

Unlock efficiency with your gateway to Google Workspace automation. In just 10 minutes, you’ll build a script to auto-sort your Google Sheets.

Your Inaugural Automation

Consider the advantage of a client database that consistently maintains alphabetical order by name. This eliminates repetitive manual intervention.

The Goal

Create a script that automatically sorts your sheet by the first column whenever you open it.

Let’s Get Coding

Access Your Target Google Sheet

Open the Google Sheet intended for automation.

Navigate to the Apps Script Editor

From your active Google Sheet, select Extensions > Apps Script.

A new browser tab will open with the editor.

Implement the Automation Script

Delete everything there and paste this code:

function autoSortSheet() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet 1"); // <<-- Change to your sheet name!

// Sorts from row 2 down to the last row
var range = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn());

// Sorts by the first column (A) in ascending order
range.sort({column: 1, ascending: true});
}

Save & Authorise

Click the disk icon to save. Then click Run.

You will need to review permissions and “Allow” the script.

Configure Trigger

To run automatically, set up a trigger (alarm clock icon).

Event Source: From spreadsheet
Event Type: On open

Why Choose Empower Automation?

You’ve just experienced a taste of efficiency. But genuinely transformative automation requires a deeper understanding. We craft bespoke solutions that solve your exact pain points.

Get Expert Help

Apps Script for Beginners: Your First Automation in 10 Minutes