Google Apps Script

Google Apps Script

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

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

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

API Keys Secrets and Secure Configuration in Google Apps Script

by

📘 Lesson 4 — API Keys, Secrets & Secure Configuration in Google Apps Script Blog Post #4 in the Apps Script + APIs + Gemini Series If you’ve ever seen code like this: …you’ve already seen a problem. In this lesson, you’ll learn how to properly store and manage secrets (API keys, tokens, configuration values) … Read more