Google Apps Script

Google Apps Script

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

Build a Google Drive “Knowledge Base” Chatbot with Apps Script + Gemini

by

drive-rag-chatbot/├── Code.gs // Apps Script backend├── Index.html // Web app UI└── README.md // Basic project documentation Github https://github.com/lsvekis/Build-a-Google-Drive-Knowledge-Base-Chatbot In this lesson, you’ll learn how to turn a Google Drive folder into a simple “knowledge base” chatbot, powered by: You’ll be able to ask questions about the documents in a Drive folder (Docs, text files, and … 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

Google Sheets AI Data Analyst (Apps Script + Gemini)

by

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

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

Build a Google Docs AI Chatbot with Apps Script and Gemini

by

​​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

by

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

by

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

by

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