278 Google Sheet Tutorials

💡

An exclusive library of Google Sheet Tutorials

🚀
Efficient: Automation techniques to supercharge your workflow and automate repetitive tasks.
🎯
Precise: Ensure your data is always accurate and your analysis is clear.
🌈
Creative: Discover new ways to use Google Sheets.
Can't Find a Video?: Members can reach out and ask me anything!

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

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 right, or the end of the google sheets tabs.
Embed Email Form and Name Form into Website to Google Sheets

Embed Email Form and Name Form into Website to Google Sheets

Add names to the Email2Sheet apps script and code.
Get Sheets Wrapped 2024 | Your Year in Google Sheets

Get Sheets Wrapped 2024 | Your Year in Google Sheets

How to Create AI Images From Google Sheets

How to Create AI Images From Google Sheets

Use the Open AI API and Dall-e-3 to create image in Sheets
Email Certain Department Based on Google Form Entries

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.
Write Email Subject Variations Fast! A Simple Google Sheets Automation

Write Email Subject Variations Fast! A Simple Google Sheets Automation

Create a simple automation for adding text to a cell of text. Really easy example is to create a lot of email subject lines from one single cell of text.
Generate Google Search Phrases

Generate Google Search Phrases

Create a lot of search phrases from one simple automation trick. Generates a lot of phrases without having to ask AI.
Take Screenshots from URLs in Google Sheets

Take Screenshots from URLs in Google Sheets

Use Screenshot One api to quickly get cached images of Screenshots and then go and download them. Check this out and let me know how you'd use it.
Send a Button from Google Sheets in an Email

Send a Button from Google Sheets in an Email

quick fun video to show you how to add a button to emails when you send emails from Google Sheets.
Get Every Editor on Every Google File I Own

Get Every Editor on Every Google File I Own

Get every editor if you're looking for the sheets and documents you've shared with other people and forgot them! Or just want to get a list of them into a Google Sheet. 
Enter Google Drive File Name Get URL

Enter Google Drive File Name Get URL

Create a simple automation with an installable trigger that allows you to enter the Google Drive file name and get the URL inside your Google Sheet.
Scrape Google Maps

Scrape Google Maps

Scrape Google Maps Added Phone and Reviews

Scrape Google Maps Added Phone and Reviews

Added two helper functions to get Phone numbers and reviews of the Google Maps Results.
Google Maps Scraper for Outreach

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly message via Whatsapp.  Then Manage the outreach.
Create a new Spreadsheet from just a Name in a Sheet.

Create a new Spreadsheet from just a Name in a Sheet.

Create the Apps Script to create a new sheet from some data inside your sheet. Script included in the sheet below.
How to Trigger Macros Daily

How to Trigger Macros Daily

Automate your apps script and macros you can record.
6 Ways to Make Your Checkboxes Better

6 Ways to Make Your Checkboxes Better

Learn How to Take Your Google Sheets Checkbox to the Next Level and Get More Organized! Click Now to Discover Creative Ways to Use Checkboxes and Boost Your Productivity!

We're going to take a basic function of Google sheets, which is the checkbox, and we are going to take it to its nth degree.
Richard Asks: Copy Template Tab and Rename to Date Every Week

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

Member Richard asks this question. Answer: use Google Script and a Trigger.
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
Spreadsheet Automation 101: Introduction to Pre-course Videos

Spreadsheet Automation 101: Introduction to Pre-course Videos

Learn how to automate spreadsheets with Apps Script. The pre-course videos equip you with the fundamentals of coding before you start.

Displaying items 181-200 of 278 in total