Google Sheets

Auto-Timestamp Rows in Google Sheets with Apps Script (When Status Changes)

by

https://github.com/lsvekis/Apps-Script-Code-Snippets If you use Google Sheets for workflows—submissions, approvals, task tracking, content pipelines—one thing always comes up: “When did this actually happen?” You can add timestamps manually, but: In this tutorial, you’ll create an Apps Script that automatically: ✅ Adds a timestamp when a row becomes Submitted / Complete / Approved✅ Only sets the timestamp … Read more

Automatically Protect Finalized Rows in Google Sheets with Apps Script

by

https://github.com/lsvekis/Apps-Script-Code-Snippets Accidentally overwriting data is one of the most common problems in shared Google Sheets. Someone edits a completed row.A formula gets replaced.A “final” value quietly changes. Google Sheets has Protected Ranges, but managing them manually doesn’t scale. In this tutorial, you’ll build a Google Apps Script that: ✅ Watches for edits✅ Detects when a … Read more

Apps Script and Gemini Powered Google Sheets Tools

by

📘 Lesson 6 — Gemini-Powered Google Sheets Tools (Menus, Selections & AI Output) Blog Post #6 in the Apps Script + APIs + Gemini Series Calling Gemini is powerful.But calling Gemini inside Google Sheets is transformative. In this lesson, you’ll learn how to turn Gemini into a native Sheets assistant—able to explain data, summarize selections, … Read more

Working With JSON & Writing API Data Into Google Sheets

by

📘 Lesson 2 Blog Post #2 in the Apps Script + APIs + Gemini Series One of the biggest milestones in learning Google Apps Script is moving from simply calling an API… to actually using its data inside Google Workspace. In this lesson, you’ll learn: By the end, you’ll know how to turn any JSON … Read more

Gemini and Google Workspace Toolkit

by

Github https://github.com/lsvekis/20-Gemini-Exercises Google Docs & Google Sheets AI Helpers with Custom Menus This toolkit lets you add Gemini-powered AI features directly into: All with: 🧱 1. Project Structure You’ll create two separate container-bound projects: A) Google Docs toolkit (Doc-bound) Files: B) Google Sheets toolkit (Sheet-bound) Files: The same SharedHelpers.gs code can be reused in both … Read more

Build AI-Powered Google Sheets with Gemini: A Complete Beginner’s Guide

by

https://github.com/lsvekis/20-Gemini-Exercises Learn how to use Google Apps Script + Gemini to automate ideas, translations, emails, summaries, and more AI is no longer something we only use in chat apps—it can now work directly inside your Google Sheets. With just a few lines of Apps Script, you can get Google’s Gemini model to: ✨ Generate creative … Read more

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