Better Sheets

Apps Script APIs > SpreadsheetApp > getRange

SpreadsheetApp.getRange()

What it does

Tutorials and snippets that call getRange() in code that also uses SpreadsheetApp.

Official Google docs

20 Better Sheets tutorials

2 New Ways To Add Emoji Reactions

Revolutionize the way you react with emojis! Discover two new methods t...

5 Ways To Use Google Sheets for Advanced Project Management

Here are 5 advanced ways to manage projects inside of Google Sheets Man...

Intermediate

COUNTIF() FILTER() IF() INDEX() ISBLANK() +3 more

Access the Dictionary API to get Definitions for Words in Google Sheets

Advanced

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no l...

Advanced

HYPERLINK()

Add NPS to Your Google Site

Create buttons on your Google Site to get an NPS, or Net Promoter Score ...

Intermediate

AVERAGE()

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script

Advanced

Anika Asks: How To Set Text Overflow All The Time

Learn to set text wrap, overflow, or clip. Great for designing better te...

Intermediate

Automated Project Management in Google Sheets

Create automatic notifications when a project is assigned, a project nee...

Intermediate

Automate Emails

Set up automated email notifications based on Google Sheets data. Super ...

Beginner

Automate Form Response to Confirmation Email

Create an email automatically when someone fills out a google form. incl...

Advanced

Automate Google Sheets With Zero Experience

By the end of this video you should be knowledgeable about how to automa...

Beginner

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system. • Create tickets C...

Advanced

AVERAGE() COUNTA() COUNTIF() FILTER() IF()

Automate Move Blank Rows

Automate the apps script we just created that moves blank rows from one ...

Intermediate

Automatically Align Top

Automate formatting cells to align top. Either by a time-based trigger o...

Automatically Check Past Stages

Create an automation that runs whenver we check off a checklist item the...

Beginner

Automatically Clear Content | Refresh Reuse Recycle Templates

Create automatic functions to clear content.

Intermediate

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, ge...

Intermediate

Automatically Uncheck A Daily Checklist

Create an automatic unchecker for a daily checklist. Fun way to learn Ap...

Beginner

Automatic Calculations

Create custom scripts to make your spreadsheets more like tools.

Beginner

Basic CRM - Add a Powerful Script To Move Row Based on Status

we're going to be adding a very powerful script to our CRMs or any datab...

Advanced

20 Snippets using this methods

SpreadsheetApp.getRange()

2 New Ways To Add Emoji Reactions

5 Ways To Use Google Sheets for Advanced Project Management

Access the Dictionary API to get Definitions for Words in Google Sheets

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Add NPS to Your Google Site

Add Tasks to Google Tasks From Google Sheets

Anika Asks: How To Set Text Overflow All The Time

Automated Project Management in Google Sheets

Automate Emails

Automate Form Response to Confirmation Email

Automate Google Sheets With Zero Experience

Automate Help Desk Ticket Closing

Automate Move Blank Rows

Automatically Align Top

Automatically Check Past Stages

Automatically Clear Content | Refresh Reuse Recycle Templates

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically Uncheck A Daily Checklist

Automatic Calculations

Basic CRM - Add a Powerful Script To Move Row Based on Status

Related blog posts

How to reference a different Google Spreadsheet in Apps Script?

What's Better Than Google Sheets?

Getting Started Coding in Apps Script