Google Apps Script

Google Apps Script

Working With JSON & Writing API Data Into Google Sheets

by

📘 Lesson 2 Blog Post #2 in the Apps Script + APIs + Gemini Series One of the biggest milestones in learning Google Apps Script is moving from simply calling an API… to actually using its data inside Google Workspace. In this lesson, you’ll learn: By the end, you’ll know how to turn any JSON … Read more

Automatically Convert PDFs to Text Files Using Google Apps Script

by

🚀 Automatically Convert PDFs to Text Files Using Google Apps Script (With OCR Support!) Working with PDFs is painful. They’re great for sharing, but not so great when you actually need the text inside them. Manually copying and pasting from dozens—or hundreds—of PDFs is slow, error-prone, and exhausting. So today, I’m sharing a practical automation … Read more

AI Form Builder for Google Forms

by

https://github.com/lsvekis/AI-Form-Builder-for-Google-Forms 🚀 Apps Script + Gemini Mastery — Issue #7 AI Form Builder for Google Forms Generate complete Google Forms — questions, sections, validation, and descriptions — automatically using Gemini. ⭐ What You Will Build in This Issue In this lesson, you’ll create an AI-powered form builder that: 📋 Generates an entire Google Form from … Read more

Create Quiz in form with Sheets Data using Apps Script

by

Convert your sheet data into a form quiz https://github.com/lsvekis/JavaScript-Quiz-Form-Builder 1. Set up your Google Sheet Use (or create) a spreadsheet and add a sheet (tab) named Questions. In row 1, put these headers: A B C D E F G Question Option A Option B Option C Option D CorrectOption Explanation Then from row 2 … Read more

Build an AI Email Assistant for Gmail

by

🚀 Apps Script + Gemini Mastery — Issue #5 https://github.com/lsvekis/Build-an-AI-Email-Assistant-for-Gmail Build an AI Email Assistant for Gmail Draft replies, summarize long threads, extract tasks, detect tone, and create a Gmail sidebar — all powered by Gemini. ⭐ What You Will Build in Issue #5 A complete AI Email Assistant for Gmail that can: 📩 Summarize … Read more

Build a Google Drive RAG System in Apps Script

by

🚀 Apps Script + Gemini Mastery — Issue #4 https://github.com/lsvekis/rag-script-Gemini-Rag Bring context-aware AI answers to your own documents — summaries, explanations, knowledge extraction, and more. ⭐ What You Will Build in Issue #4 A fully functioning RAG pipeline, completely in Apps Script: This is the same technique used in advanced AI apps — now fully … Read more

Test Your Apps Script Knowledge 100 Quiz Questions

by

1. What is Google Apps Script primarily used for? A. Building Android appsB. Automating and extending Google Workspace appsC. Managing Google Cloud infrastructureD. Designing static HTML websites Correct answer: BExplanation: Google Apps Script is a JavaScript-based platform used to automate, integrate, and extend Google Workspace apps like Sheets, Docs, Gmail, Forms, and Drive. It’s not … Read more

AI Data Analyst for Google Sheets

by

🚀 Apps Script + Gemini Mastery — Issue #3 AI Data Analyst for Google Sheets Ask AI questions about your data. Get summaries, trends, anomalies, and insights — automatically analyzed inside Sheets. ⭐ What You Will Build in Issue #3 A full AI Data Analyst sidebar for Google Sheets that can: 🔍 Analyze selected ranges📊 … Read more

AI Content Generator for Google Docs

by

Issue #2 https://github.com/lsvekis/apps-Script-Gemini-Repo AI Content Generator for Google Docs Write blog posts, lesson plans, summaries, outlines & formatted documents using Gemini — all from a custom Apps Script menu. ⭐ What You Will Build in Issue #2 A full AI Content Generator inside Google Docs with menu items like: AI Tools    → Generate Blog Post … Read more