Build practical Google Sheets automations using Gemini
Use Gemini to turn repetitive Google Sheets work into simple automations that clean data, format reports, create formulas, and save time without starting from scratch.
TL;DR
You'll turn repetitive Google Sheets work into reusable automations by using Gemini to write Apps Script code for data cleanup, PDF export, and auto-email updates. Instead of repeating the same manual steps, you'll trigger each script from a button in your sheet, saving time without needing to code.
Who this is for
- Busy professionals who spend hours cleaning and formatting spreadsheet data
- Managers who need to generate and email regular reports from Google Sheets
- Non-technical users who want to automate repetitive tasks without learning programming
What you'll build
You'll build an Apps Script for data cleanup, a PDF export and auto-email script, and a clickable button in your sheet to trigger these automations.
Steps in this tutorial
- Step 1: Generate a Google Apps Script for a data cleanup routine
- Step 2: Generate a PDF export and an auto-email script
The step-by-step instructions, prompts and screenshots are for AI Academy subscribers.
Unlock the full AI Academy
This tutorial and every other one, on ChatGPT, Claude, Midjourney & the other AI tools we cover
Start risk-free · Cancel anytime
Already a member? Sign inUnlock the full AI Academy
This tutorial and every other one, on ChatGPT, Claude, Midjourney & the other AI tools we cover
Start risk-free · Cancel anytime
Already a member? Sign in

