Utilities

What it does

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

Methods used

.base64Decode() .base64Encode() .formatDate() .newBlob() .sleep()

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

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

Build a License Key Generator and API in 20 Minutes

How to leverage Apps Script to create an API in less than 20 minutes. Cr...

Advanced

Build Your Own AI Writer in Google Sheets

Create your own AI writer with these google sheets tips and tricks and c...

Advanced

SUBSTITUTE()

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.

Intermediate

DAY() MONTH() TODAY() YEAR()

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. ...

Intermediate

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkbox...

Daily Writer's Word Count Tracker

Walk through creating an awesome automatic word count tracker that's eas...

Intermediate

CONCATENATE() COUNTIF() ROUND() SUM() TEXT() +1 more

Deep Inside Dark Habits Google Script

Go inside this apps script and sheet. See how it's designed and created.

ARRAYFORMULA() CONCATENATE() COUNTIF() FILTER() IFNA() +3 more

Email Myself a Daily Random Motivational Quote

Quickly make a daily email to myself with a motivational quote.

Beginner

Embed Quote and Author to Daily Quote Website

Step by step tutorial to update random quote site to show both Quote and...

Advanced

Every Google Drive File Created in Last 24 Hours

Create a simple report in a Google Sheet that documents every file in yo...

Intermediate

Fast FAQS

New Tool for you: Fast FAQs. Create a quick 10 question FAQ for any new ...

How To Download All Tabs as CSV in a Zip File

Download All Tabs as CSV in a Zip File, instead of downloading each one ...

Intermediate

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far ...

Intermediate

How to Format Timestamp to Day and Month

Create a formatted timestamp to the full name of the day and month. Form...

How to Power Testimonials with Google Forms and Sheets

I show you how I use a Google Form and a Google Sheet to power the testi...

Advanced

FILTER() IFNA()

MicroManager: Hourly Email Reminders

I'll show you how to set up a super powered checklist that can act like ...

Advanced

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: w...

Advanced

IF() IMPORTRANGE()

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.

Advanced

IF() IMPORTRANGE()

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled...

Intermediate

Shaman: AI Blog Writer

I will introduce you to the power of AI writing in Google Sheets using a...

Intermediate

Timestamp When Done (With Code)

Automatically create a timestamp when a certain cell is marked as Done. ...

Beginner

Tweet From a Sheet

See how to tweet from a sheet and get the code below.

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets

Beginner

Ultimate Prompt Writer and Prompt Rater

Create a chat interface inside of Google Sheets using GPT-4. Insert rows...

Data validation Advanced

FILTER() IFERROR()

Visicalc 2023 Design Walkthrough

Design walkthrough of VisiCalc 2023. Watch this if you'd like to see the...

Intermediate

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk throug...

Beginner

SUM()

Explore

Related methods

More Apps Script

5 Ways to Create Coupon Codes | Create UUIDs

Add NPS to Your Google Site

Americano Tournament Template With Four Automations

Automate Form Response to Confirmation Email

Automatically Backup a Spreadsheet

Build a License Key Generator and API in 20 Minutes

Build Your Own AI Writer in Google Sheets

Can I Automatically Rename a Sheet based on a Date?

Create an Automated Task List

Creating A Dark Mode Theme | Announcing Dark Habits

Daily Writer's Word Count Tracker

Deep Inside Dark Habits Google Script

Email Myself a Daily Random Motivational Quote

Embed Quote and Author to Daily Quote Website

Every Google Drive File Created in Last 24 Hours

Fast FAQS

How To Download All Tabs as CSV in a Zip File

How To Duplicate a Tab and Move it to the End in Google Sheets

How to Format Timestamp to Day and Month

How to Power Testimonials with Google Forms and Sheets

MicroManager: Hourly Email Reminders

Password Protecting Data In a Google Sheet

Password Protecting Data In a Google Sheet Part 2 The Basics

Richard Asks: Copy Template Tab and Rename to Date Every Week

Send Better Email When Google Form Filled Out

Shaman: AI Blog Writer

Timestamp When Done (With Code)

Tweet From a Sheet

Twitter App Clone in a Google Sheet

Ultimate Prompt Writer and Prompt Rater

Visicalc 2023 Design Walkthrough

Visicalc 2023 Quick Walkthrough

Related blog posts

What's Better Than Google Sheets?

How to Send Google Forms Entries Automatically with Apps Script

Explore Coding in Google Sheets