Google Sheets Tutorials · Better Sheets

Count Merged Rows

Count the number of cells or rows in a merged cell. This is a quick little code you can add to your sheets with the onOpen code.

Intermediate

Sync Tabs in Different Sections

How to sync different sections on different tabs. In this case we're taking data from multiple tabs putting into one, and syncing between those.

Advanced

Sync Many Tabs without ImportRange()

Sync more than two tabs with Apps Script

Advanced

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

Automatically Check Past Stages

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

Beginner

Automate Move Blank Rows

Automate the apps script we just created that moves blank rows from one sheet to the other sheet. Original tutorial to write the apps script

Intermediate

Move Blank Rows

Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here

Intermediate

Build Your Own PROPER() Custom Apps Script Function to Capitalize Each Word

There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.

Intermediate

Embed Quote and Author to Daily Quote Website

Step by step tutorial to update random quote site to show both Quote and Author separately. Example site: https://todayquote.carrd.co/

Quick tutorial to show you how to build a random quote site →Here

Advanced

Automatically Align Top

Automate formatting cells to align top. Either by a time-based trigger or every time you edit cells.

Build Your Own Net Promoter Score (NPS) Survey on a Web Site

Create an embeddable NPS system on a web page.

Advanced

Build Your Own AI Writer in Google Sheets

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

Advanced

Timestamp When Done (With Code)

Automatically create a timestamp when a certain cell is marked as Done. I show you how to customize this scrip and where to get the script. I hope this is simple enough for beginners to start automating you sheets. If you want to see more automations and dive deeper into apps script enroll in Spreadsheet Automation 101
and see more examples of Apps Script at BetterSheets.co/snippets

Beginner

Automatically Backup a Spreadsheet

Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script. Two are shown here. to back up a tab or back up a spreadsheet file.

Intermediate

Count Unique Attendees For Each Event

Find out how many people attended each event even if they are double counted in attendee lists.

Beginner

Invoicing in Google Sheets for Freelancers

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.

Beginner

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

Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.

Intermediate

Optimize SEO with Google Sheets and Google Search Console

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()

Beginner

Email Myself a Daily Random Motivational Quote

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

Beginner

Quickly Build a Daily Random Motivational Quote Website

Build a website from scratch using a little bit of Google Sheets as the backend. Using Carrd to build a html website from the data and display a random quote every time you refresh the page. All the code including the HTML embed is in the sheet below.

Intermediate

Displaying items 1-20 of 538 in total

538Google Sheet Tutorials

Discover the Power of Productivity

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

🎯 Precise:

🔧 Automate Your Sheets