Tags

Formulas

104Google Sheet Tutorials

Discover the Power of Productivity

An Exclusive Library of Google Sheet Tutorials!

Why Choose Our Google Sheet Tutorials?

🚀 Efficient:

Learn the best Google Sheets formulas and spreadsheet automation techniques to supercharge your workflow. Discover how to automate repetitive tasks effortlessly, saving you valuable time and effort.

🎯 Precise:

Master Google Sheets formulas to ensure your data is always accurate and up-to-date.

🔧 Automate Your Sheets

Delve into the world of Google Apps Script. Automate reporting. Automate your data. Automate your business

Jump in and watch this quick run through of what is SheetOps. It's not just an automated task list, it's a business operations command center. Command the chaos! Get it at https://BetterSheets.co/tools/sheetops
While creating SheetOps, a new product, I came up with this idea of an automatic emailer that I can just enter an email and select a series of emails to send them. Needs an unsubscribe link. And so I made it in less than 45 minutes. Here it is. You can start using this right now for free if you're a member.
create a tour of your sheet for users who might be using your sheet and need to know what to do on each tab.
Build a tracking number google site with Google Sheets as a backend.
Create a script that sends an email to ask for proof of life every month, or it will destroy the google sheet.
How to and why to upgrade from V5 Rhino to V8 Runtime in Add-ons
Message a certain department when google form is submitted.
Adding to the Form Automations:
Allow User to Reopen form without Apps Script access
Set Limit in a Sheet, not in Apps Script
Set Limits for different Forms
Create an email automatically when someone fills out a google form. include a url that has a clickable confirmation link and a unique id.
Create a simple automated help desk ticketing system.
  • Create tickets
    Closed dropdown
  • Calculate time to close
    Create dashboard
Create automations to change date format based on the format you want, inside your sheet.
Add names to the Email2Sheet apps script and code.
I go through a few of the darkest parts of selling spreadsheets and how you can fix them. I offer how to do updates that generate revenue and what marketplaces to sell on to avoid marketing into the void.
Create tasks in Google Tasks from Google Sheets using Apps Script
I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hour live stream here.

In this video I update it a bit, and show off that it works!! 

Learn how to build trigger builders and use user properties to store data you don't want a user to change (easily)
Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
10x your expertise driven content. Create new sections and fun additions to your own content. Make your writing more engaging and more educational.
Automate copying a template for new form submissions with user data inserted into the new sheet.
Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
How to update your add-on when you update your code for fixes or add functionality. 

Displaying items 1-20 of 104 in total