Apps Script Code Examples

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

Google Apps Script Dynamic Sheets Data Survey

by

Code at GitHub https://github.com/lsvekis/Apps-Script-Survey/tree/main Build a Data-Driven Survey Web App with Google Sheets + Apps Script If you’ve ever wished Google Forms gave you more control over styling, page flow, and your data model, this pattern is for you. Below is a practical, beginner-friendly recipe for building a custom, multi-page survey that reads questions from … Read more

Vibe Coding for Beginners: Learn to Code with AI

by

Getting Started with Vibe Coding 1.1 What is Vibe Coding? Vibe Coding is a way of learning programming that removes fear and friction. Instead of sitting in front of a blank screen, unsure of where to begin, you describe what you want in plain English and use AI to help you turn it into working … Read more

Get Ready to Automate: An Introduction to Your Google Apps Script Exercises

by

How to Use These Exercises Exercise 1: Hello, World! 👋 Objective: Learn the most basic function of Apps Script: creating a function and logging a message to the execution log. Instructions: Write a script that logs the message “Hello, World!” to the console. Solution: Explanation: Exercise 2: Send a Simple Email 📧 Objective: Use the … Read more

Ultimate Guide to Google Apps Script 100 Common Apps Script Questions

by

Welcome to Your Ultimate Guide to Google Apps Script Ever find yourself lost in a sea of repetitive tasks within Google Sheets, Docs, or Gmail? Have you ever thought, “There has to be a better way to do this”? There is, and you’ve found it. Enter Google Apps Script, the powerful, cloud-based scripting platform built … Read more