Google Apps Script

Google Apps Script

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

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

by

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

by

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

by

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

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

​​10 hands-on Google Apps Script exercises focused on Google Sheets

by

At the end, there’s one single .gs file you can paste into your Apps Script project. It creates the sheets, seeds data, and lets you run each exercise from a custom menu. How to get set up (once) Exercise 1 — Create & Seed a “Sales” sheet Objective: Learn to create a sheet, write headers/rows, … 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

Automating the Testing of 100 Google Apps Script Examples in Google Sheets

by

Download files When I released my 100 Google Apps Script examples for Google Sheets, one of the most common follow-up requests was: “Can I run all the examples automatically, without launching them one by one?” The answer is yes—and the solution is a master runner function that launches and tests all the functions in the … Read more