Apps Script Code Examples

Action Plan for Google Docs Issue 12 Apps Script and Gemini

by

Apps Script + Gemini Mastery — Issue #12 AI Meeting Notes → Action Plan for Google Docs Turn raw meeting notes into structured decisions, action items, and follow-up emails using Apps Script + Gemini. https://github.com/lsvekis/Apps-Script-Code-Snippets ⭐ What You Will Build You’ll build an AI-powered tool that: 📝 Takes messy meeting notes (copied or written in … Read more

Automatically Resize Images in Google Docs with Apps Script

by

Images can quickly break the layout of a Google Doc.If you’ve ever pasted screenshots, charts, or photos into a document, you’ve probably had to manually resize each one so it fits nicely on the page. Good news: Google Apps Script can automate this completely. In this post, you’ll learn how to use a simple Apps … Read more

Apps Script 11 AI Email Draft Assistant for Gmail

by

https://github.com/lsvekis/Apps-Script-Code-Snippets 🚀 Apps Script + Gemini Mastery — Issue #11 AI Email Draft Assistant for Gmail Generate reply drafts from a Gmail thread using Apps Script + Gemini (tone + action items + subject options). ⭐ What You Will Build You’ll build an AI assistant that: 📥 Pulls the most recent email thread from Gmail … Read more

How to Resize All Images in Google Docs to 50% Page Width (Using Apps Script)

by

https://github.com/lsvekis/Apps-Script-Code-Snippets If you’ve ever worked on a long Google Doc with lots of images, you know the pain:some images are too large, some too small, and manually resizing each one is tedious and inconsistent. The good news? Google Apps Script can handle this automatically. In this post, you’ll learn how to use a simple Apps … Read more

AI Report Generator for Google Docs Apps Script and Gemini 9

by

https://github.com/lsvekis/Apps-Script-Code-Snippets/tree/main/apps_script_gemini_ai_report_generator_docs 🚀 Apps Script + Gemini Mastery — Issue #9 AI Report Generator for Google Docs Turn Google Sheets data into polished executive reports automatically using Apps Script + Gemini. ⭐ What You Will Build in This Issue In this lesson, readers will build an AI Report Generator that: 📊 Reads structured data from Google … Read more

Google Apps Script – 100 Question Quiz

by

✅ Google Apps Script – 100 Question Quiz With Detailed Answers & Explanations 🟢 SECTION 1: Google Apps Script Fundamentals (1–20) 1. What is Google Apps Script? Answer:Google Apps Script is a cloud-based JavaScript platform used to automate, extend, and integrate Google Workspace apps. Explanation:It runs on Google’s servers and allows you to write JavaScript … Read more

AI Data Cleaner for Google Sheets Google Apps Script and Gemini

by

🚀 Apps Script + Gemini Mastery — Issue #8 https://github.com/lsvekis/Apps-Script-Code-Snippets/tree/main/apps_script_gemini_ai_data_cleaner_sheets AI Data Cleaner for Google Sheets Automatically clean, normalize, and prepare messy spreadsheet data using Gemini + Apps Script. ⭐ What You Will Build in This Issue In this lesson, you’ll build an AI-powered data cleaning assistant for Google Sheets that can: 🧹 Detect messy … Read more

Instantly Create a Clickable Table of Contents in Google Docs with Apps Script

by

If you work with long Google Docs—guides, reports, lesson plans, ebooks, or AI-generated drafts—navigation quickly becomes painful. Headings exist… but readers still scroll endlessly. In this post, we’ll build a smart Apps Script that: ✅ Scans all headings in a document✅ Automatically generates a clickable Table of Contents✅ Inserts it at the top of the … Read more

100 Advanced Google Apps Script Examples

by

https://github.com/lsvekis/100-Advanced-Google-Apps-Script-Examples A) Sheets: Performance, Data Ops, Automation (1–25) 1) Batch update with RangeList (fast formatting) Does: Applies formatting to many ranges in one go. 2) Write values + formulas in one pass Does: Sets values and formulas efficiently. 3) Build an index of unique keys → row numbers Does: Creates a lookup map for fast … Read more

Google Apps Script 50 Exercises Explained Vol 2

by

1) Custom menu in Google Sheets Does: Adds a menu item so users can click to run functions.How it works: onOpen() runs automatically when the file opens (for editors), and SpreadsheetApp.getUi() adds UI. function onOpen() {   SpreadsheetApp.getUi()     .createMenu(‘Tools’)     .addItem(‘Say Hello’, ‘sayHello’)     .addToUi(); } function sayHello() {   SpreadsheetApp.getUi().alert(‘Hello from Apps Script!’); } 2) Show a toast … Read more