Better Sheets

Utilities

What it does

Hash, encode, decode, format dates, sleep, and other helper utilities.

Methods used

10 Related snippets

Official Google docs

Explore

Related methods

.formatDate()
Formats a date using a pattern and time zone.
.base64Decode()
Decodes a Base64 string back into raw data.
.base64Encode()
Encodes a string or bytes as Base64.
.computeDigest()
Returns a hash digest of a string or blob.
.jsonStringify()
Converts a JavaScript object into a JSON string.

More Apps Script

5 Better Sheets tutorials

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to...

CHAR() DEC2HEX() MID() RANDBETWEEN()

Add NPS to Your Google Site

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

Intermediate

AVERAGE()

Americano Tournament Template With Four Automations

Created a tournament template with 4 automations. So tabs can be copied ...

Intermediate

SORT() SUM() SUMIF() UNIQUE()

Automate Form Response to Confirmation Email

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

Advanced

Automatically Backup a Spreadsheet

Make a copy and rename to BACKUP plus the Date of the backup. Execute th...

Intermediate

Related blog posts

Written guides about Utilities in Google Apps Script.

Browse the blog

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

How to Send Google Forms Entries Automatically with Apps Script

Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.

Explore Coding in Google Sheets

Did you know you can actually code in Google Sheets?