Apps Script Code Examples

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

Highlight Duplicates Above in Google Sheets with Apps Script

by

https://github.com/lsvekis/Apps-Script-Code-Snippets Duplicates in a spreadsheet aren’t always “bad”—but sometimes they’re a sign of a problem. A common pattern is: you want values to be unique as you enter them, and if someone repeats a value that already appeared earlier in the same column, you want an instant visual warning. In this tutorial, you’ll build an … Read more

Built a Google Docs AddOn from Scratch

by

How to Build a Google Docs Add-On with Apps Script (Step-by-Step) https://github.com/lsvekis/Google-Docs-Addon Google Docs is incredibly powerful—but when documents are copied from Word, PDFs, LMS systems, or email, formatting quickly turns into chaos. Instead of fixing formatting manually every time, you can build a Google Docs Add-on using Google Apps Script that runs directly inside … Read more

Google Docs Smart Clean Up app One Click fix with Apps Script

by

Google Docs “Smart Cleanup” — One Click to Fix Spacing, Quotes, Dashes, and Hidden Characters https://github.com/lsvekis/Google-Docs-Smart-Clean-Up-app-One-Click-fix-with-Apps-Script If you work in Google Docs all day (course outlines, policies, SOPs, lesson plans, client docs), you’ve seen it: This post gives you a commonly needed Docs solution: a one-click “Smart Cleanup” menu built with Google Apps Script that … Read more

Build a Gemini Powered AI Dashboard Web App Google Apps Script

by

📘 Lesson 8 — Build a Gemini-Powered AI Dashboard Web App (Capstone Project) Blog Post #8 in the Apps Script + APIs + Gemini Series https://github.com/lsvekis/Google-Apps-Script-APIs-Gemini-8-Lessons- You’ve learned how to: Now it’s time to put everything together. In this final lesson, you’ll build a Gemini-powered AI dashboard — a real web app where users can: … Read more

Google Docs Style Resizer AddOn Menu with Apps Script

by

https://github.com/lsvekis/Google-Docs-Style-Resizer-AddOn-Menu-with-Apps-Script When a Doc has been edited by many people (or copy/pasted from other sources), font sizes can drift all over the place. This quick Google Apps Script adds a custom UI menu to your Google Doc that opens a sidebar where you can set font sizes for: …and then apply those sizes across the … Read more

Create Amazon US and Canada Links Automatically in Google Sheets

by

If you work with Amazon KDP, you’ve probably copied URLs like this more times than you’d like to admit: What you really want isn’t that long internal KDP URL — you want clean public Amazon links, like: Instead of doing this manually every time, we can automate it directly inside Google Sheets using a custom … Read more

Gemini-Powered Google Docs Summaries Rewrites and AI Writing Tools

by

📘 Lesson 7 — Gemini-Powered Google Docs (Summaries, Rewrites & AI Writing Tools) Blog Post #7 in the Apps Script + APIs + Gemini Series Google Sheets is about data.Google Docs is about thinking, writing, and meaning. In this lesson, you’ll bring Gemini directly into Google Docs, allowing users to summarize documents, rewrite sections, and … Read more

Building Custom Menus and Sidebars in Google Docs with Google Apps Script

by

Create Real Tools Inside Docs (Not Just Scripts) Most Google Apps Script tutorials stop at automation.But the real power starts when you turn scripts into tools users can interact with—directly inside Google Docs. In this article, you’ll learn how to create custom menus and sidebars that transform a Google Doc into a mini application. Why … Read more