Google Apps Script

Google Apps Script

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

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

Clean Up a Google Doc with Apps Script

by

Clean Up a Google Doc with Apps Script: Bullets → Dashes, Headings Down a Level, and No More Blank-Line Spam If you’ve ever copied content into Google Docs from a website, PDF, or another editor, you’ve probably seen the usual mess: This post walks through three simple Google Apps Script functions that clean up an … 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

Automatically Convert PDFs to Text Files Using Google Apps Script

by

🚀 Automatically Convert PDFs to Text Files Using Google Apps Script (With OCR Support!) Working with PDFs is painful. They’re great for sharing, but not so great when you actually need the text inside them. Manually copying and pasting from dozens—or hundreds—of PDFs is slow, error-prone, and exhausting. So today, I’m sharing a practical automation … Read more

AI Form Builder for Google Forms

by

https://github.com/lsvekis/AI-Form-Builder-for-Google-Forms 🚀 Apps Script + Gemini Mastery — Issue #7 AI Form Builder for Google Forms Generate complete Google Forms — questions, sections, validation, and descriptions — automatically using Gemini. ⭐ What You Will Build in This Issue In this lesson, you’ll create an AI-powered form builder that: 📋 Generates an entire Google Form from … 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