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

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

10 More JavaScript DOM Games — Learn by Building (Vanilla JS)games 21 -30

by

🎮 10 Even More JavaScript DOM Games — Learn by Building (Vanilla JS) Get code https://github.com/lsvekis/10-JavaScript-DOM-Coding-Games-Learn-by-Building-Fun-Mini-Projects/ Miss the joy of learning JavaScript by making tiny interactive things? This sequel brings 10 new DOM mini-games (Exercises 21–30) you can run by simply opening an index.html. They’re built with vanilla JavaScript, HTML, and a dash of CSS—no … Read more

10 JavaScript DOM Coding Games — Learn by Building Fun Mini Projects

by

Github https://github.com/lsvekis/10-JavaScript-DOM-Coding-Games-Learn-by-Building-Fun-Mini-Projects/ https://discoveryvip.com/games.html see them live JavaScript and the Document Object Model (DOM) form the foundation of every interactive web page. The best way to truly master them is to build something — and that’s exactly what these ten small games are designed to help you do. Each exercise is fully self-contained, runs right in … 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

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

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

JavaScript DOM Coding Exercises

by

41) Canvas Signature Pad + Save PNG — exercise41_signature_pad.html <!doctype html> <html lang=”en”> <head> <meta charset=”utf-8″> <title>Signature Pad — Canvas + Pointer Events</title> <!– Build: Simple signature/drawing pad using <canvas> + Pointer Events with Save PNG. Objectives: – Use pointerdown/move/up/cancel to draw smooth lines on a canvas. – Handle DPR (devicePixelRatio) for crisp rendering. – … Read more