Apps Script Code Examples

Getting Data from APIs with Google Apps Script

by

Github Repo https://github.com/lsvekis/Google-Apps-Script-APIs-and-Gemini In this project, your Hybrid AI Orchestrator pulls in real data from the web using APIs and then lets AI (local model + Gemini) interpret that data. To do that, we need to understand one key tool: UrlFetchApp — the Apps Script class that lets you call APIs. In this lesson you’ll … Read more

Demote All Headings in a Google Doc Using Apps Script

by

(H1 → H2, H2 → H3, etc.) When working with long Google Docs—course outlines, documentation, manuscripts, or AI-generated content—you often need to shift all heading levels down by one. For example: Doing this manually in a long document is tedious. Fortunately, Google Apps Script makes it possible to automate this task in seconds. This post … Read more

100 Useful Google Docs Apps Script Functions (That Every Docs Power-User Should Know)

by

Google Docs + Apps Script is a magic combo for automating writing workflows, templates, formatting, and reporting. https://github.com/lsvekis/100-Useful-Google-Docs-Apps-Script-Functions In this post, you’ll get 100 tiny utility functions you can drop into your own projects. Each one is: Tip: Create a single .gs file called docsHelpers.gs and paste all the functions there. Then call them from … Read more

100 Custom Google Sheets Functions Built with Apps Script — Your Ultimate Power Toolkit

by

Get the code on Github https://github.com/lsvekis/100-custom-Google-Sheets-functions Google Sheets is already one of the most versatile tools in the Google Workspace ecosystem, but when you combine it with Apps Script, it becomes a full-fledged programmable powerhouse. Today, I’m sharing something special:👉 100 custom Google Sheets functions written entirely in Apps Script — clean, flexible, fast, and … Read more

Build a Gmail Smart Reply Assistant Using Apps Script Gemini

by

Github https://github.com/lsvekis/Build-a-Gmail-Smart-Reply-Assistant-Using-Apps-Script How to automate email drafting, summarization, and tone adjustments directly inside Gmail. Managing email is one of the biggest daily time drains for modern professionals. Whether you’re responding to customers, coordinating projects, supporting students, or managing internal communication—email takes time, focus, and energy. But what if Gmail could help you write replies automatically? … Read more

Build a Drive Folder RAG Chatbot Using Google Apps Script + Gemini

by

Get Github Files https://github.com/lsvekis/Drive-Folder-RAG-Chatbot (Step-By-Step Guide) Turn any folder of Google Docs into an AI-powered knowledge assistant AI assistants are becoming a core part of modern workflows—and thanks to Google Apps Script + Gemini, you can now build your own internal chatbot that answers questions using only the content stored inside a Google Drive folder. … Read more

Powering Up Google Apps Script with Gemini AI — My DevFest USF 2025 Talk Recap

by

This weekend, I had the privilege of presenting at DevFest USF (University of South Florida) — part of the world’s largest community-driven tech conference hosted by Google Developer Groups. Held on November 15, 2025, at the USF Engineering Building II in Tampa, the event brought together an incredible community of developers, students, innovators, and tech … Read more

Building a Web Article Summarizer and Citation Extractor with Google Sheets Gemini AI

by

GitHub https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/summarizer 🌐 Building a Web Article Summarizer & Citation Extractor with Google Sheets + Gemini AI Have you ever wished you could drop a list of article URLs into Google Sheets and instantly get structured summaries — complete with titles, key quotes, named entities, and estimated reading time?In this exercise, we’ll create exactly that … Read more

AI Translator and Tone Converter in Google Sheets

by

🌍 Build an AI Translator & Tone Converter in Google Sheets (with Gemini & Apps Script) Github https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects 🚀 Overview In this exercise, you’ll learn how to connect Google Sheets to Gemini’s REST API using Apps Script, enabling you to automatically translate text and rewrite it in different tones — all directly from your spreadsheet. … Read more

Build an AI Text Rewriter in Google Sheets Using Gemini and Apps Script

by

Artificial intelligence is no longer limited to chat interfaces — you can now embed powerful AI tools directly into your favorite Google Workspace apps. In this tutorial, we’ll walk through how to build an AI Text Rewriter inside Google Sheets using Google Apps Script and the Gemini REST API. GitHub https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/AI%20Text%20Rewriter%20in%20Google%20Sheets By the end, you’ll … Read more