Coding Help Tips Resources Tutorials
Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
🌍 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
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
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
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
Discover how Google Apps Script and Gemini AI can revolutionize your workflows with innovative automation and AI-powered tools. This combination simplifies tasks, enhances productivity, and unlocks new possibilities in your day-to-day operations. Key Features of Google Apps Script: Enhancing Automation with Gemini AI: How It Works: Real-World Applications: Empower your projects with the combined capabilities … Read more
Unleashing the Power of Google Apps Script and Gemini AI: Laurence Svekis at Miami DevFest 2024 Get ready for an electrifying experience at Miami DevFest 2024! On December 14th, from 9:00 AM to 5:00 PM (EST), acclaimed Google Developer Expert (GDE) and industry thought leader Laurence Svekis will be presenting “Power Up with Google Apps … Read more
📘 Introduction Have you ever needed to list image files from a Google Drive folder and generate descriptions for each image automatically? This process can be time-consuming if done manually, but with Google Apps Script and Gemini AI, you can automate the entire workflow. In this blog post, you’ll learn how to: This process is … Read more
📘 Introduction Have you ever wished you could summarize the contents of multiple Google Docs with the help of AI and email the results to your inbox? This tutorial will show you how to do just that using Google Apps Script and Gemini AI. With this system, you can: This is perfect for creating executive … Read more
Buig thank you for the organizers and attendees of Google IO Extended + Build with AI in Waterloo this past weekend. Reflecting on an Inspiring Day at Google IO Extended + Build with AI https://gdg.community.dev/events/details/google-gdg-waterloo-presents-google-io-extended-build-with-ai I had the incredible honor of presenting at the Google IO Extended + Build with AI event, hosted by GDG … Read more
We will explore how to create a Google Apps Script that lists all the image files in a specific Google Drive folder, converts them to Base64, and writes their details (name, URL, MIME type, and a generated description) into a Google Sheets spreadsheet. We will use the Google Gemini Pro Vision API to generate detailed … Read more