Google Apps Script

Google Apps Script

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

AI Knowledge Base Builder for Google Drive Apps Script Gemini Issue 10

by

🚀 Apps Script + Gemini Mastery — Issue #10 https://github.com/lsvekis/Apps-Script-Code-Snippets AI Knowledge Base Builder for Google Drive Turn a Drive folder of Docs into a searchable “AI knowledge base” using Apps Script + Gemini. ⭐ What You Will Build You’ll build a Google Workspace tool that: 📁 Scans a Drive folder of Google Docs🧠 Uses … 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

Google Apps Script 50 Exercises Explained Vol 1

by

https://github.com/lsvekis/Apps-Script-Code-Examples 1) Add a Custom Menu on Open (Sheets) Does: Adds a menu to your spreadsheet UI.Use when: You want easy buttons for scripts. function onOpen() {   SpreadsheetApp.getUi()     .createMenu(‘Tools’)     .addItem(‘Say Hello’, ‘sayHello’)     .addSeparator()     .addItem(‘Run Cleanup’, ‘cleanup’)     .addToUi(); } function sayHello() {   SpreadsheetApp.getUi().alert(‘Hello from Apps Script!’); } function cleanup() {   SpreadsheetApp.getUi().alert(‘Cleanup placeholder.’); } 2) Show a … Read more