Automate Repetitive Work with Apps Script

Google Apps Script is the automation engine hiding inside every Google Workspace account, and Gemini just gave it a voice you can actually speak. You no longer need to know how to code to automate repetitive work across Gmail, Sheets, Docs, Calendar, and Drive. This lesson shows you exactly what's possible, what the limits are, and how to use Gemini to write and deploy scripts that save real hours every week.

7 Things to Know Before You Start

1. Google Apps Script is a built-in tool, no downloads, no installs. It lives at script.google.com and is free with any Google account.
2. Scripts run on Google's servers, not your computer. You don't need to be online or have your machine turned on for a scheduled script to execute.
3. Gemini in Google Workspace (available with Business Standard, Business Plus, or Enterprise plans) can write Apps Script code for you when you describe what you want in plain English.
4. You never have to read or edit the code. You can copy, paste, and run scripts that Gemini writes without understanding a single line.
5. Scripts can touch Gmail, Google Sheets, Google Docs, Google Calendar, Google Drive, and Google Forms, all from one place.
6. Apps Script has a free execution quota: scripts can run up to 6 minutes per execution and 90 minutes total per day on a free account. Workspace business plans get higher limits.
7. Every script you run asks for permission first. Google shows you exactly what the script wants access to before anything happens.

What Google Apps Script Actually Does

Think of Apps Script as a personal assistant who lives inside Google Workspace and follows written instructions. Those instructions tell it to do things like: send an email when a spreadsheet row is updated, copy a file to a specific folder every Friday, or create a calendar event from a form submission. The instructions are written in a language called JavaScript, but here's the thing: you don't write them. You describe what you want, and Gemini writes the instructions for you. Your job is to tell it what outcome you need.

This matters for non-technical professionals because the barrier has always been the code itself, not the idea. Managers know exactly what they want automated, they just couldn't express it in a way a computer understood. Gemini bridges that gap. You describe the workflow in the same language you'd use to brief a colleague, and Gemini translates it into a working script. The result is automation that used to cost $500 in developer time, built in 15 minutes during your lunch break.

• Send automatic email summaries from a Google Sheet every Monday morning
• Flag overdue tasks in a project tracker by highlighting rows red when a deadline passes
• Auto-create a Google Doc from a template every time a client fills out a Google Form
• Move files in Google Drive to specific folders based on their name or date
• Add calendar events in bulk from a list in Google Sheets
• Send a Slack-style digest email to your team from a shared spreadsheet
• Archive old emails in Gmail that match specific labels or senders

Click to enlarge

How Gemini Writes Scripts for You

Gemini can generate Apps Script code in two places: directly inside Google Sheets (using the Gemini side panel), or through a conversation in Gemini Advanced at gemini.google.com. The Sheets side panel is the faster option for spreadsheet-specific tasks. Gemini Advanced gives you more back-and-forth conversation, which is useful when your automation touches multiple apps or needs several steps. Either way, the process is the same: describe what you want, review the script Gemini writes, paste it into the Apps Script editor, and run it.

The quality of what Gemini produces depends almost entirely on how specifically you describe your task. Vague requests produce vague scripts. Specific requests, ones that name the exact sheet tab, column headers, email recipient, and trigger condition, produce scripts that work on the first try. You don't need to use technical language. You need to be precise about the business outcome. Treat it like briefing a very literal assistant: tell it exactly what to look at, what to do, and when to do it.

1. Open Google Sheets and click the Gemini icon in the top-right corner to open the side panel.
2. Type a plain-English description of what you want the script to do, be specific about column names, sheet names, and conditions.
3. Gemini will write the script and display it in the panel. Read the plain-English explanation it provides above the code.
4. Click 'Insert' or 'Copy' to move the script into the Apps Script editor (Extensions → Apps Script).
5. In the Apps Script editor, click the 'Run' button (triangle icon). Google will ask for permissions, review them and click 'Allow'.
6. Check the result in your Sheet, Doc, or Gmail to confirm the script did what you expected.
7. If it didn't work correctly, go back to Gemini and describe what went wrong in plain English, it will revise the script.

Click to enlarge

Triggers: The Difference Between Manual and Automatic

A script without a trigger is just a button you have to press yourself. A trigger is what makes automation real, it's the condition that causes the script to run without you. Apps Script supports two kinds of triggers: time-based (run every hour, every day, every Monday at 9am) and event-based (run when someone submits a form, when a spreadsheet is opened, or when a new row is added). Time-based triggers are simpler and work for most professional use cases: sending reports, archiving emails, flagging overdue items.

Setting up a trigger is a point-and-click process inside the Apps Script editor, no code involved. You click the clock icon in the left sidebar, click 'Add Trigger,' and choose your function, your timing, and your frequency from dropdown menus. The trigger runs on Google's servers, which means it fires even if your computer is off, your browser is closed, or you're on vacation. This is the part most professionals find surprising: once a trigger is set, the automation is genuinely hands-off. It will run until you turn it off.

Click to enlarge

Part 1 Cheat Sheet

• Apps Script lives at script.google.com, free with any Google account, no install needed
• Gemini writes the code for you, describe the task in plain English, copy the result, run it
• Best Gemini access for Sheets automation: the Gemini side panel (requires Business Standard or higher)
• Best Gemini access for complex multi-app workflows: Gemini Advanced at gemini.google.com
• Scripts can automate Gmail, Sheets, Docs, Drive, Calendar, and Forms
• Triggers make automation hands-off, time-based (daily, weekly) or event-based (form submit, sheet open)
• Scripts run on Google's servers, they fire even when your computer is off
• Free quota: 6 minutes per execution, 90 minutes per day (Workspace plans get more)
• Always review the permissions screen before clicking Allow, match what the script needs to what it requests
• Revoke script permissions anytime at myaccount.google.com/permissions
• Be specific in your Gemini prompt: name the exact sheet tab, column headers, recipient email, and trigger condition
• If the first script doesn't work perfectly, describe what went wrong to Gemini and ask for a revision

Key Takeaways From Part 1

• Google Apps Script is the automation layer built into every Google Workspace account. Gemini makes it accessible to anyone who can describe a task in plain English.
• You don't need to read, write, or understand code. Your job is to describe the business outcome precisely.
• Triggers are what separate 'a script you run manually' from 'automation that works while you sleep.'
• The more specific your Gemini prompt, exact tab names, column headers, conditions, recipients, the better the script it produces.
• Permissions matter. Know what access you're granting before you click Allow, and revoke anything you no longer need.

Once you understand what Apps Script can do, the next challenge is knowing how to talk to Gemini about it, and how to take the scripts you get and actually put them to work. This section covers the practical middle layer: triggering automations, connecting Google apps together, and using Gemini as your on-call script editor when something breaks or needs adjusting.

7 Things to Know Before You Automate Anything

1. Apps Script runs inside your Google account, you don't install software, you paste code into a browser-based editor at script.google.com.
2. Every script needs permission to access your Google data (Sheets, Gmail, Calendar). You grant this once, the first time you run it.
3. Triggers are what make scripts run automatically, on a schedule, when a form is submitted, or when a file changes.
4. Gemini can write, fix, and explain scripts in plain English. You don't need to understand the code to use it.
5. Scripts that touch Gmail or Drive will show a Google security warning on first run, this is normal for custom scripts, not a sign something is wrong.
6. You can run a script manually (click a button) or automatically (set a trigger). Both are useful depending on the task.
7. One script can connect multiple Google apps, a single automation can read a Sheet, send a Gmail, and create a Calendar event in sequence.

How Triggers Work, and Why They Matter

A trigger is the instruction that tells a script when to run. Without a trigger, a script just sits there waiting for you to click it manually. With a trigger, it fires on its own, at 9am every Monday, the moment someone submits a Google Form, or whenever a specific spreadsheet is opened. For non-technical professionals, triggers are the difference between a useful tool and a real automation. Think of a trigger like an alarm clock: the script is the action, the trigger is what wakes it up.

Gemini can help you set up triggers using plain language. You describe when you want something to happen, and Gemini writes the trigger code alongside the script. You don't configure triggers through a visual settings menu, they're set in the script itself, or through the Apps Script dashboard under 'Triggers' in the left sidebar. Either way, Gemini can tell you exactly what to click and where to paste. The most powerful triggers for business users are time-based (daily/weekly) and form-submission triggers, which fire the instant someone completes a Google Form.

• Time-driven trigger: Runs on a schedule, hourly, daily, weekly, or on a specific date/time.
• Form submit trigger: Fires the moment a Google Form response is recorded.
• On open trigger: Activates when a Google Sheet or Doc is opened.
• On edit trigger: Fires whenever a cell in a Sheet is changed.
• On change trigger: Similar to on edit, but fires for structural changes like adding a new sheet tab.
• Manual trigger: You run the script yourself by clicking a button or menu item you've added to a Sheet.

Connecting Multiple Google Apps in One Script

Apps Script's real power shows up when it connects several Google tools in a single workflow. A standalone script that sends one email is useful. A script that reads a Google Sheet, checks whether a deadline has passed, finds the relevant contact's email in column C, sends a personalized Gmail, and logs the send time back into the Sheet, that's an automation that saves hours every week. Gemini can build this kind of multi-step script from a single, well-written prompt. The key is describing the full workflow, not just the end result.

When you ask Gemini to connect multiple apps, be specific about the data flow. Where does the information start? Where does it end up? What conditions should trigger an action? Phrases like 'if column D says Pending,' 'for each row where the date is today,' or 'only if the cell is not blank' give Gemini the logic it needs to write accurate code. Vague prompts produce vague scripts. Treat Gemini like a very capable assistant who needs the same level of detail you'd give a new team member handling a process for the first time.

1. Start with the data source, tell Gemini which Sheet, Form, or Doc holds the information.
2. Describe any conditions, 'only rows where column E says Approved', 'if the date in column B is today'.
3. Name the action, send an email, create a calendar event, move a file, update a cell.
4. Specify the destination, which Gmail address, which calendar, which folder in Drive.
5. Mention what to do after, 'mark column F as Sent', 'add today's date to column G'.
6. State the trigger, when should this run: on a schedule, on form submit, or manually.
7. Ask for comments in the code, tell Gemini 'add plain-English comments explaining each section' so you can read what the script does.

Click to enlarge

Using Gemini to Fix and Modify Scripts

Scripts don't always work perfectly on the first try. A column reference might be off by one, the date format in your Sheet might not match what the script expects, or an email might send but the status column doesn't update. These are fixable problems, and Gemini is exactly the right tool to fix them. You don't need to debug code yourself. You paste the script back into Gemini, describe what happened versus what you expected, and ask for a corrected version. This loop, generate, test, describe the problem, fix, is how professionals actually use AI for automation.

Modifying an existing script is often faster than writing a new one. If you have a working invoice reminder script and want to add a CC to your manager, you don't start from scratch, you paste the script into Gemini and say 'modify this to also CC manager@company.com on every reminder email.' Gemini makes the targeted change and hands back the updated script. The same applies to adding new columns, changing email wording, adjusting the trigger time, or adding a condition. Treat your working scripts as living documents that Gemini can edit on request.

Quick Reference Cheat Sheet

• Apps Script editor: Extensions → Apps Script in any Google Sheet, Doc, or Form.
• Run a script manually: Click the ▶ Play button in the Apps Script editor.
• Set a trigger: Click the clock icon in the Apps Script left sidebar → Add Trigger.
• Fix a broken script: Paste the script + the error message into Gemini, describe what went wrong.
• Modify a script: Paste the working script into Gemini, say 'modify this to also...' and describe the change.
• Connect multiple apps: Describe the full data flow in your prompt, source, condition, action, destination, result.
• Test safely: Always duplicate your Sheet before running a new script on real data.
• Read what the script does: Look for lines starting with //, those are plain-English comments.
• Best trigger for form workflows: Form submit trigger, fires the instant a response is recorded.
• Best trigger for reports and reminders: Time-driven trigger, set to daily or weekly at a specific hour.

Key Takeaways from This Section

• Triggers are what transform a script from a manual tool into a real automation, always specify when you want a script to run in your Gemini prompt.
• Multi-app workflows are Apps Script's strongest use case, one script can read a Sheet, send a Gmail, and update a Calendar event in sequence.
• Gemini is not just a script writer, it's your script editor. Use it to fix errors, adjust logic, and add new functionality to working automations.
• You never need to understand the code syntax. Focus on the plain-English comments and the workflow logic.
• Testing on a copy before running on live data is the single most important safety habit for non-technical users.

Gemini inside Google Workspace isn't just a chatbot bolted onto your apps, it's a workflow layer that connects Docs, Sheets, Gmail, Meet, and Drive into something that actually saves hours. This section covers the practical patterns, limits, and shortcuts that turn Gemini from a novelty into a daily tool.

7 Things Every Professional Should Know About Gemini in Google Workspace

1. Gemini is available inside Gmail, Docs, Sheets, Slides, and Meet, you access it through the sparkle (✦) icon or the side panel, not a separate app.
2. You need a Google Workspace account with Gemini add-on (Business or Enterprise tier) or a personal Google One AI Premium subscription ($19.99/month) to unlock the full feature set.
3. Gemini can read files already in your Drive, you don't retype content; you point Gemini at existing documents.
4. In Sheets, Gemini writes formulas for you in plain English. You describe what you want; it generates the formula and explains it.
5. In Meet, Gemini generates real-time captions and post-meeting summaries automatically, no manual note-taking required.
6. Gemini does NOT have access to your emails or documents by default unless you explicitly open the side panel in that app and interact with it there.
7. Apps Script automation triggered by Gemini suggestions still runs inside Google's infrastructure, no third-party servers receive your data.

Writing and Summarizing with Gemini in Docs and Gmail

In Google Docs, the Gemini side panel reads your open document and responds to questions about it, or drafts new sections based on your instructions. Open a 40-page report and ask "summarize the key risks in bullet points" and Gemini returns a usable summary in seconds. In Gmail, the "Help me write" button generates full draft replies based on a short instruction you type. Both features work inside the existing interface, no copy-pasting into a separate tool.

The quality of output depends heavily on how specific your instruction is. Vague prompts produce vague drafts. Telling Gemini "write a follow-up email" gets you a generic paragraph. Telling it "write a follow-up email to a client who missed our Tuesday call, keep it friendly, suggest two new time slots this week" gets you something you can actually send. Think of your instruction like a brief to a junior colleague, the more context you give, the less editing you do afterward.

• Docs: Use the side panel to ask questions about your document, request rewrites, or generate new sections.
• Gmail: Use 'Help me write' for new drafts; use 'Refine' to adjust tone, length, or formality after the first draft appears.
• Slides: Use 'Help me visualize' to generate image suggestions or restructure slide content from an outline.
• Drive: Ask Gemini to summarize or compare multiple files without opening each one individually.
• Meet: Enable 'Take notes for me' before a meeting starts, the summary lands in a Doc linked to the calendar invite.

Using Gemini with Google Sheets Formulas

Sheets formulas intimidate most non-technical professionals, and for good reason. VLOOKUP, ARRAYFORMULA, and nested IF statements are genuinely complex. Gemini removes that barrier entirely. Open the Gemini side panel in Sheets, describe what you want in plain English, and it writes the formula. It also explains what the formula does in plain language, so you understand what you're inserting before you click accept. This is one of the most immediately useful features for managers and analyzts who live in spreadsheets but didn't study computer science.

You can also ask Gemini to analyze existing data. Paste a range reference and ask "which sales rep had the highest average deal size last quarter". Gemini reads the data and answers directly. For more complex analyzis, it can suggest pivot table structures or chart types suited to your data. The side panel keeps context across your questions in a session, so you can build on previous answers without re-explaining your spreadsheet every time.

1. Open your Google Sheet and click the Gemini icon (✦) to open the side panel.
2. Type your formula request in plain English: 'Calculate the average of column C only where column B says Confirmed.'
3. Gemini generates the formula and explains each part, read the explanation before inserting.
4. Click 'Insert' to place the formula directly in the selected cell.
5. Ask follow-up questions in the same panel: 'Now do the same for Pending instead of Confirmed.'
6. Use 'Help me organize' to get suggestions for structuring raw data before you start analyzing it.

What Gemini Cannot Do. And Where It Makes Mistakes

Gemini is not a fact-checker. If you ask it to summarize a document, it summarizes what's there, but if the document contains errors, Gemini repeats them confidently. It also has a known tendency to generate plausible-sounding but incorrect formulas for highly specific or unusual Sheets operations. Always verify formula outputs against a small test dataset before applying them to real data. Treat Gemini like a fast, capable colleague who occasionally gets things wrong and always needs a quick review.

Gemini also doesn't retain memory between separate sessions. Close the side panel and reopen it tomorrow, it has no recollection of what you discussed. For recurring workflows, keep a short prompt template saved in a Doc so you can paste it in each time rather than rebuilding context from scratch. Additionally, Gemini's access to your files is scoped to what's open or explicitly shared in the session, it cannot browse your entire Drive autonomously.

Click to enlarge

Quick Reference Cheat Sheet

• Access Gemini in any Workspace app via the ✦ sparkle icon or side panel, not a separate tab.
• Gmail: 'Help me write' for new drafts; 'Refine' to adjust tone, length, or formality.
• Docs: Side panel reads your open document, ask it to summarize, rewrite, or extend any section.
• Sheets: Describe the formula you need in plain English. Gemini writes it and explains it.
• Meet: Enable 'Take notes for me' before the call starts, summary Doc auto-generates afterward.
• Slides: Use 'Help me visualize' to generate visuals or restructure content from a text outline.
• Gemini does NOT retain memory between sessions, save prompt templates in a Doc for reuse.
• Always review AI-generated formulas on test data before applying to real datasets.
• Vague prompts get vague results, include role, context, tone, and output format in every prompt.
• Gemini cannot verify facts, cross-check any figures, dates, or claims it surfaces from documents.

Key Takeaways

• Gemini works inside Gmail, Docs, Sheets, Slides, Meet, and Drive, each app has distinct, practical features worth knowing separately.
• The Gemini side panel is your primary interface, it reads open documents and responds to plain-English instructions.
• Formula generation in Sheets removes one of the biggest spreadsheet barriers for non-technical professionals.
• Meet summaries and auto-generated action items eliminate manual note-taking from most internal meetings.
• Gemini drafts faster than you type, but it requires your judgment, review everything before it goes out or gets used.
• Specific, context-rich prompts consistently outperform vague ones, treat your prompt like a brief to a capable colleague.
• Memory does not persist between sessions, build reusable prompt templates for recurring tasks.