Tags

Formulas

585Google 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

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why.  Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.
Reasons you may want to avoid the tiered approach, if you’re looking to sell your first spreadsheet. A tiered version can cause more confusion than you can ever imagine. You’re so familiar with your sheet, you know the ins and outs. Buyers and potential customers do not.  You can almost always change just about everything at nearly any time.
Know what to add, what to take away, and ultimately how to create a spreadsheet anyone can buy at any price.  For example you can create a free template, add in custom formulas and automations into a Pro version.
You can also create an ideal version first at a higher price and release simpler versions for a lower price later.
Pricing is an art. Learn to balance affordability with profitability, understand market expectations, and apply different pricing models to maximize revenue.
But in some instances you will need to make a Free version for people to see, smell, tire-kick. Give’em a little taste. It summons the influential power of “Reciprocity”.
Why “Free” sucks and how to make something people will buy. Sure I’m going to make a whole other course about freebies and lead magnets but for us, right now, right here, free sucks.

Don’t sell a spreadsheet. Feature the problem and solution, not the sheet itself. It just so happens to be a spreadsheet.
How to write a great sales page, that solves problems, and happens to mention it’s a Google Sheet.
Turn Google Sheets into Revenue Streams with a simple sales page. Tell the story your users want to buy into.
Create a short function that runs every time a spreadsheet file is open. Redirects the user to the START tab. You can use this to direct anyone opening your file to a specific tab you want them to start on.
Create an Email form that sends a few books to AI and gets back a book recommendation. Build the backend in Google Sheets Apps Script while using Carrd to easily make an online form.
How to use Google Sheets as a database by turning it into a REST API with Google Apps Script. This makes Google Sheets a powerful tool for managing data online, allowing for easy data entry and retrieval without manual sharing or updating.

This allows you to add and get data from the sheet over the internet without sharing the sheet. It shows how to:
  • Write code in Google Sheets that listens for web requests.
  • Use doGet and doPost functions to handle these requests.
  • Insert data into the sheet and fetch a summary of this data through the web.
  • Deploy the script as a web app to get a URL for accessing the API.
  • Test the API with tools like Postman or embed it in a web form.


The video tutorial demonstrates how to leverage Google Sheets and Google Apps Script to create a simple API for managing and checking the status of jobs or projects. This is particularly useful for project or product managers who need a straightforward system for tracking job statuses without exposing their entire Google Sheet to external users. The process involves:

  1. Setting up a Google Sheet as a database: The sheet contains job IDs and their corresponding statuses. This setup acts as a backend where job statuses can be updated.
  2. Creating an API with Google Apps Script: By writing a custom script, a doGet function is deployed as a web app. This function allows users to query the Google Sheet by job ID via a URL, returning the job's current status.
  3. Deploying a web app: The script is deployed as a web application, which generates a unique URL. This URL acts as an endpoint for the API, where requests can be sent to check job statuses based on job IDs.
  4. Front-end form for checking job status: A form is created using an online tool (like CARRD) where users can input a job ID. Upon submission, the form sends a request to the API, retrieves the job status from the Google Sheet, and displays it to the user.
  5. Securing data visibility: This method ensures that only the relevant job status information is shared with external users, without revealing the entire content of the Google Sheet.
  6. Integration with other Sheets: The API can also be used in conjunction with other Google Sheets using the IMPORTDATA function, allowing for the automated retrieval of job statuses into other spreadsheets without manual data entry or revealing the original data source.

This approach is valuable for project management, allowing for real-time status checks of various jobs with minimal setup and without the need for complex database systems or advanced coding knowledge.
How to leverage Apps Script to create an API in less than 20 minutes. Create a license key for use in your own apps or as a cloud based API service. We'll create the API using Apps Script and the front end system using a basic Carrd page. Also I'll show you how to test your API in Postman, a free api checker web app.
How to turn a spreadsheet in your Google Drive into a sellable product. Step-by-step, I will show you exactly how I do it. If you're selling a sheet you use, then you must do this!
Set up automated email notifications based on Google Sheets data. Super simple apps script to start this. Learn how to automate this for users very easily with a custom menu and programmable Triggers.
A brief description of types of automation. I go way more in depth in “Master Spreadsheet Automation” on Udemy and “Spreadsheet Automation 101” on Better Sheets
- Built-in Formulas that seem like automation IF()
- Custom Functions in Apps Script
- Time Driven Triggers
- Event Driven Triggers
Create custom scripts to make your spreadsheets more like tools.
How to imbue your sheets with a little bit of magic to delight your customers without learning Apps Script. Using the IF/ISBLANK formula combination.

Displaying items 81-100 of 585 in total