Tags

Formulas

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

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. 
Create multiple functions that run with the result of other functions.
Add a Custom Menu
Create Native-like Functions
Get URL and Sheet ID's via Apps Script
A Few things to know about Developing Google Sheet Add-ons
Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"
Learn how to add multiple rows to your google sheets by hand, and automatically. 
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.
Sync more than two tabs with Apps Script
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
Create an embeddable NPS system on a web page.
Create your own AI writer with these google sheets tips and tricks and code.
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.

Displaying items 1-20 of 92 in total