Apps Script Code Examples

How to Use Libraries in Google Apps Script Bound to Google Docs

by

Goal: Reuse code across multiple Docs projects by adding a library to a bound script (a script attached to a Google Doc), then calling library functions from the Doc. What is a Google Apps Script Library? A library is a reusable Apps Script project you publish so other scripts can include it. Instead of copy/pasting … 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

Calling Gemini from Google Apps Script

by

📘 Lesson 5 — Calling Gemini from Google Apps Script (Text Prompts → AI Responses) Blog Post #5 in the Apps Script + APIs + Gemini Series Up to this point, you’ve learned how to: Now it’s time to bring AI into your Apps Script projects. In this lesson, you’ll learn how to call Google’s … Read more

Apps Script Examples Gemini Embedding

by

Below are ready-to-paste Google Apps Script examples you can add to your blog post, covering the two most useful embedding workflows: Replace YOUR_API_KEY_HERE with your key.These examples use the Generative Language API style endpoint. A) Minimal: Create an embedding for a text string B) Store document chunks + embeddings in Google Sheets This creates a … Read more

Google Docs Cleanup Toolkit

by

https://github.com/lsvekis/Doc-Cleanup-Toolkit User & Developer Guide This guide explains what the Google Docs Cleanup Toolkit does, how to use it safely, and how each part of the system fits together. 1. What This Toolkit Is The Google Docs Cleanup Toolkit is a Google Apps Script project that helps you: It is designed to be: 2. Who … Read more

Build Your First Google Apps Script Web App

by

📘 Lesson 3 — Build Your First Google Apps Script Web App (HTML + APIs) Blog Post #3 in the Apps Script + APIs + Gemini Series Up until now, you’ve been running Apps Script functions from the editor or triggering them from Sheets and Docs. In this lesson, everything changes. You’ll build a real … 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

Create Quiz in form with Sheets Data using Apps Script

by

Convert your sheet data into a form quiz https://github.com/lsvekis/JavaScript-Quiz-Form-Builder 1. Set up your Google Sheet Use (or create) a spreadsheet and add a sheet (tab) named Questions. In row 1, put these headers: A B C D E F G Question Option A Option B Option C Option D CorrectOption Explanation Then from row 2 … Read more

Build an AI Email Assistant for Gmail

by

🚀 Apps Script + Gemini Mastery — Issue #5 https://github.com/lsvekis/Build-an-AI-Email-Assistant-for-Gmail Build an AI Email Assistant for Gmail Draft replies, summarize long threads, extract tasks, detect tone, and create a Gmail sidebar — all powered by Gemini. ⭐ What You Will Build in Issue #5 A complete AI Email Assistant for Gmail that can: 📩 Summarize … Read more