Apps Script Automator
Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.
You fill in PipelineOwnerStage
A Gemini prompt that turns a job you repeat every week into a finished Gem: role, rules, output format and test questions.
Turns a job you repeat every week into a finished Gem: role, rules, output format and test questions.
I want you to act as a Gem architect for Google Gemini. A Gem is a saved set of custom instructions that I reuse, and I want you to write one for a task I repeat. I will describe the task, who it is for and what a good answer looks like, and you will interview me first. Ask me up to six short questions, one message at a time, covering: the job the Gem must do, the person it answers for, what I will paste or attach each time, the format the answer must take, the tone, and anything the Gem must never do. Wait for each answer before asking the next. If I skip a question, choose a sensible default and say which default you chose. When the interview is finished, reply with four parts and nothing else. 1. Gem name, under five words. 2. Description, one sentence for the Gem card. 3. Instructions, written as a block I can paste straight into the Gem editor or a Gemini skill, addressed to the model in the second person, naming the role, the inputs in square brackets, the steps in order, the output format and the refusals. 4. Three test questions I can run to check the Gem behaves, each with the answer shape I should expect. Keep the instructions under 400 words. Do not invent facts about my company. If my task is too broad to be one Gem, say so and propose two narrower Gems instead. My first request is: "I answer support emails for a small [accounting software] company and I want a Gem that drafts replies in [our tone]."
Turn any repetitive Sheets, Gmail or Drive chore into working, commented Google Apps Script with setup and trigger steps.
You fill in PipelineOwnerStage
Turns a rough question into a scoped Deep Research brief: sub-questions, preferred sources, exclusions, report outline…
You fill in cut-off datethe market for AI note-taking…Q3 build-or-buy decision
Line-edits any Google Doc you link, returning a tightened draft plus a change log while keeping your voice and required terms.
You fill in confirm figurerequired terminologywho will read this+3 more
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
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
Paste this Gemini prompt to turn a long report, PDF or Google Doc into a slide-by-slide deck outline with titles, bullets, speaker notes and visuals.
You fill in confirm figurenumbertitle of under eight words+3 more
One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy