Google Sheets

100 Custom Google Sheets Functions Built with Apps Script — Your Ultimate Power Toolkit

by

Get the code on Github https://github.com/lsvekis/100-custom-Google-Sheets-functions Google Sheets is already one of the most versatile tools in the Google Workspace ecosystem, but when you combine it with Apps Script, it becomes a full-fledged programmable powerhouse. Today, I’m sharing something special:👉 100 custom Google Sheets functions written entirely in Apps Script — clean, flexible, fast, and … Read more

Automating the Testing of 100 Google Apps Script Examples in Google Sheets

by

Download files When I released my 100 Google Apps Script examples for Google Sheets, one of the most common follow-up requests was: “Can I run all the examples automatically, without launching them one by one?” The answer is yes—and the solution is a master runner function that launches and tests all the functions in the … Read more

100 high impact copy pasteable Google Sheets Apps Script snippets

by

100 high-impact, copy-pasteable Google Sheets Apps Script snippets  How to use A. Setup & Quality-of-Life 1) Add a Custom Menu Creates a “Sheet Tools” menu with quick actions. function onOpen() {   SpreadsheetApp.getUi()     .createMenu(‘Sheet Tools’)     .addItem(‘Clear Selected Range’, ‘clearSelectedRange’)     .addItem(‘Timestamp Selected Cells’, ‘timestampSelection’)     .addToUi(); } function clearSelectedRange() {   const range = SpreadsheetApp.getActiveRange();   if (range) range.clearContent(); } … Read more

Send Custom Emails from Google Sheets Using Apps Script

by

📧 Send Custom Emails from Google Sheets Using Apps Script If you’ve ever needed to send personalized emails to multiple recipients—such as confirmation emails, reminders, or announcements—Google Apps Script offers a powerful way to automate this process using data from a Google Sheet. In this post, you’ll learn how to create a simple mail merge … Read more

Unlock the Power of Google Sheets: 100 Custom Formulas You Can’t Live Without

by

Google Sheets is a remarkable tool for everything from personal budgeting to enterprise-level data analysis. But the built-in functions sometimes leave gaps when you need a specialized calculation, custom text manipulation, or seamless API integration. That’s where Google Apps Script comes in—it lets you craft your own formulas (called custom functions) to extend Sheets beyond … Read more

Automate Report Generation with Google Apps Script — Add Data, Create a Report, and Email a PDF

by

📢 Introduction Are you tired of manually generating monthly reports for your team or clients? Imagine clicking one button to automatically: With Google Apps Script, you can achieve all this with a few lines of code. In this guide, we’ll walk you through how to set up this automation step-by-step. 🎉 What Will This Script … Read more

Understanding Custom Formulas in Google Apps Script — What They Are and How to Use Them

by

Have you ever wished Google Sheets could do more than just standard calculations like SUM, AVERAGE, or VLOOKUP? Do you often find yourself repeating the same complex logic in multiple places? If so, it’s time to unlock the power of Custom Formulas in Google Apps Script. Custom formulas allow you to create your own functions, … Read more

Google Apps Script for Google Sheets: Comprehensive Guide

by

Google Apps Script for Google Sheets: Comprehensive Guide Google Apps Script is a powerful tool for automating and extending the functionality of Google Sheets. This guide introduces key features, code examples, and exercises for working with Google Sheets using Apps Script. What is Google Apps Script? Google Apps Script is a cloud-based JavaScript platform for … Read more

Google Sheets Custom Formulas: Comprehensive Guide

by

Google Sheets Custom Formulas: Comprehensive Guide Custom formulas in Google Sheets are created using Google Apps Script, which allows you to build powerful, reusable functions for advanced spreadsheet operations. This guide explains how to create, use, and troubleshoot custom formulas in Google Sheets, with detailed examples, exercises, and quiz questions. What are Custom Formulas? Custom … Read more

10 More Custom Google Sheets Formulas You Need to Try

by

Quick Recap: Adding Custom Formulas To add custom formulas to your Google Sheets, follow these steps: 1. Calculate Percentage Formula: =PERCENTAGE(value, total) This formula helps you calculate the percentage of a given value compared to a total. Usage example: Enter =PERCENTAGE(50, 200) to get 25. Explanation: The function simply divides the value by the total … Read more