Google Sheets AI Data Analyst (Apps Script + Gemini)

https://github.com/lsvekis/Google-Sheets-AI-Data-Analyst Turn your spreadsheets into intelligent data assistants that explain, analyze, and visualize your data automatically. Managing data inside Google Sheets is something almost everyone does—students, analysts, project managers, educators, accountants, startup founders, and even executives. But interpreting that data often requires real time, skill, and patience. What if Google Sheets could explain your data … Read more

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

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

Build a Google Docs AI Chatbot with Apps Script and Gemini

​​GitHub https://github.com/lsvekis/Google-Docs-AI-Chatbot-using-Apps-Script-Gemini PDF Have you ever wished you could drop a Google Doc into a chatbot and ask questions about it—and have the bot answer only from that document? In this post, you’ll build exactly that: An Apps Script-powered web app that lets the user select a Google Doc, then chat with an AI agent … Read more

Build AI-Powered Workflows with Google Apps Script + Gemini

Project source code https://github.com/lsvekis/Gemini-with-Apps-Script 🚀 6 Mini Projects You Can Copy, Learn From, and Use Today AI is transforming the way we work inside Google Workspace. Whether you’re building custom tools for Sheets, automating Gmail, or creating smarter Docs workflows, Gemini makes it possible to add real intelligence to your Apps Script projects with just … Read more

Apps Script with Gemini Quick Start Guide

Apps Script with Gemini Quick Start Guide Github https://github.com/lsvekis/Apps-Script-with-Gemini-Quick-Start-Guide 1. What you’re building By the end of this guide you’ll know how to: All examples use the Gemini REST API (generativelanguage.googleapis.com) with an API key from Google AI Studio. 2. One-time setup 2.1 Get a Gemini API key You’ll use this key in Apps Script … Read more

Exercise 12 — AI Translator with Terminology Glossary

https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/Exercise%2012 Bring the power of Gemini into Google Sheets to translate text — and keep your organization’s terminology consistent. Most translation tools ignore your company’s unique language: acronyms, product names, or preferred wordings. In this project, you’ll build an AI Translator directly inside Google Sheets that not only translates text but also follows a custom … Read more

Exercise 8 AI Data Cleaner and Categorizer with Google Sheets + Gemini

Source code https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/AI%20Data%20Cleaner Managing messy product data is a constant headache — especially when you’re working with spreadsheets full of inconsistent titles, missing brands, and vague descriptions.In this exercise, we’ll build an AI-powered Google Sheets add-on that automatically cleans, classifies, and enriches product information using the Gemini API and Google Apps Script. By the end, … Read more

AI Grammar and Clarity Enhancer in Google Sheets

Github https://github.com/lsvekis/Google-Apps-Script-Gemini-Projects/tree/main/AI%20Grammar%20and%20Clarity%20Enhancer%20in%20Google%20Sheets 🎯 Learning Objectives By completing this exercise, learners will: 🧠 What You’ll Build You’ll create an AI-powered Grammar and Clarity Enhancer directly in Google Sheets.This app will: 🧾 Step 1: Create the Files In Apps Script, create: 📂 gemini-sheets-grammar/ ├── Code.gs ├── Sidebar.html ├── appsscript.json 💻 Step 2: Code.gs Paste the following code: … Read more

Build an AI-Powered Text Summarizer in Google Sheets Using Gemini

Github Repo https://github.com/lsvekis/Build-an-AI-Powered-Text-Summarizer-in-Google-Sheets-Using-Gemini Get your Gemini API Key https://aistudio.google.com/app/api-keys 🗓️ Overview You’ll learn how to connect Google Sheets with Gemini AI, create custom menu options, build a sidebar UI, and summarize text automatically — all powered by Google Apps Script and the Gemini REST API. At the end, you’ll have a working app that looks … Read more

Google Apps Script Dynamic Sheets Data Survey

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