Apps Script Code Examples

Build a Google Drive RAG System in Apps Script

by

🚀 Apps Script + Gemini Mastery — Issue #4 https://github.com/lsvekis/rag-script-Gemini-Rag Bring context-aware AI answers to your own documents — summaries, explanations, knowledge extraction, and more. ⭐ What You Will Build in Issue #4 A fully functioning RAG pipeline, completely in Apps Script: This is the same technique used in advanced AI apps — now fully … Read more

Test Your Apps Script Knowledge 100 Quiz Questions

by

1. What is Google Apps Script primarily used for? A. Building Android appsB. Automating and extending Google Workspace appsC. Managing Google Cloud infrastructureD. Designing static HTML websites Correct answer: BExplanation: Google Apps Script is a JavaScript-based platform used to automate, integrate, and extend Google Workspace apps like Sheets, Docs, Gmail, Forms, and Drive. It’s not … Read more

AI Data Analyst for Google Sheets

by

🚀 Apps Script + Gemini Mastery — Issue #3 AI Data Analyst for Google Sheets Ask AI questions about your data. Get summaries, trends, anomalies, and insights — automatically analyzed inside Sheets. ⭐ What You Will Build in Issue #3 A full AI Data Analyst sidebar for Google Sheets that can: 🔍 Analyze selected ranges📊 … Read more

AI Content Generator for Google Docs

by

Issue #2 https://github.com/lsvekis/apps-Script-Gemini-Repo AI Content Generator for Google Docs Write blog posts, lesson plans, summaries, outlines & formatted documents using Gemini — all from a custom Apps Script menu. ⭐ What You Will Build in Issue #2 A full AI Content Generator inside Google Docs with menu items like: AI Tools    → Generate Blog Post … Read more

How to Chunk Data in Google Apps Script

by

https://github.com/lsvekis/Chunk-your-data-Google-Apps-Script How to Chunk Data in Google Apps Script (So You Don’t Hit “Exceeded Maximum Execution Time”) If you work with large spreadsheets or big Drive folders in Google Apps Script, you’ve probably seen this error: Exception: Exceeded maximum execution time Most Apps Script executions have a hard time limit (often around 6 minutes per … Read more

Your First API Call with Google Apps Script UrlFetchApp Guide

by

📘 Lesson 1 — Your First API Call with Google Apps Script (UrlFetchApp Guide) Blog Post #1 in the Apps Script + APIs + Gemini Series Working with APIs is one of the most important skills you can learn as a Google Apps Script developer. Whether you’re building dashboards, automating workflows, or integrating AI tools … 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

Lesson 4 – Leveling Up Your Gemini RAG Assistant

by

Github https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini 4A: RAG + API Data · 4B: Sheet Vector Index · 4C: Chat History By now, you’ve already built a powerful foundation: In Lesson 4, we’re going to level this up in three big steps: By the end, you’ll have an assistant that: 📘 Lesson 4A — Combine RAG + API Data in a … Read more

Lesson 3 Adding Embeddings Retrieval RAG to Your Gemini API Project

by

Github https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini In Lessons 1 and 2, you learned how to: – Call public APIs using Apps Script – Read text from a Google Drive folder – Combine both sources into a Gemini prompt – Build a full UI web app Now it’s time to level up. In Lesson 3, we introduce: – Chunking (splitting documents … Read more

Fixing Google Docs Formatting: How to Convert Bullet Points Into Dashes Using Apps Script

by

Anyone who works regularly in Google Docs knows the pain:You paste content from the web, a PDF, an email, or another document—and suddenly your bullets have weird spacing, broken formatting, or mystery blank lines that refuse to go away. You try deleting them manually.You try changing line spacing.You even try Apps Script code others recommend… … Read more