Skip to content AI News: Nano Banana 2.1 is out: better edits and text, half the API price per image →
PH-0689 · Code prompt

Apps Script Automator

Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.

What you get

Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.

What you need
  • 3 blanks to fill in: Pipeline Owner Stage
Best inGeminiAlso works in ChatGPT, Claude
293 words
Prompt · September 19, 2026
I want you to act as a Google Apps Script developer who automates Workspace chores for people who cannot code. Before you begin, I will describe the repetitive task and, where it helps, reference the file with @Google Drive or @Google Sheets, or paste a few sample rows, a sample email subject line and the exact sheet and tab names below so you use my real column headers rather than invented ones.

First, restate the task in two lines as you understand it, and list any assumption you had to make. If a detail is missing, such as which column holds the email address or how often the job should run, ask at most three short questions before writing code, then proceed with sensible defaults if I do not answer.

Then reply in this order, with no preamble:
1. What this script does, in plain language, under 60 words.
2. The full Apps Script code in one block, with a comment above every function and every line an ops person might want to edit, all editable values gathered in a CONFIG object at the top.
3. Setup steps, numbered, written for someone who has never opened the script editor: where to click, which permissions the consent screen will ask for, and how to test on a copy first.
4. Trigger instructions: exact trigger type, event and timing, plus how to turn it off.
5. What can go wrong: three likely failures, such as quota limits, empty rows or renamed tabs, and the one-line fix for each.

Never invent API methods. Use only stable Apps Script services.

My first request is: "Every Monday, email each sales rep the rows from my [Pipeline] sheet where column [Owner] matches their name and [Stage] is not Closed."
Coding Gemini

How to use it

  1. Fill the blanks under «Make it yours» — the prompt updates as you type.
  2. Copy the prompt and paste it into Gemini.
  3. Not quite right? Reply with what to change — the model keeps the rest.

More Gemini prompts

PH-0795Productivity

Gmail Thread Summarizer

Turns a long Gmail thread into decisions, open questions, owner-and-deadline actions and one suggested next step you can send.

You fill in subjectnumberdate of first+4 more

Gemini
PH-0772Writing

Email Reply Drafter

Reference a Gmail message and get three ready-to-paste reply drafts in your own voice, short, standard and detailed.

You fill in confirm datenameDaniel Okafor+1 more

Gemini
Weekly

New prompts in your inbox

One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy