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
Gemini sits inside Google, so the best Gemini prompts hand it something: a Doc, a Sheet, an email thread, a YouTube link, a live search. Each block names what to attach first, then what to ask.
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
Compares several PDFs or Google Docs side by side and shows where they agree, differ and say nothing at all.
You fill in three supplier proposalstotal cost over two yearssupport response time+1 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 job you repeat every week into a finished Gem: role, rules, output format and test questions.
You fill in accounting softwareour tone
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
Checks each claim in a text against live Google Search results and labels it supported, disputed or unverified.
You fill in paste the text here
Reads photos of receipts and returns a clean expense table you can paste straight into Google Sheets.
You fill in attach the files
Writes, explains and debugs Google Sheets formulas from a plain description of your tabs and columns.
You fill in Sheet1AB+1 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
Turns a Google Sheet or CSV sales export into five clear findings, data quality warnings and next steps for small business owners.
You fill in 2024 sales exportonline homeware shopwhich products and months…
Plans a day-by-day trip itinerary using live search: opening hours, travel times, costs and a backup for rain.
You fill in LisbonNovember
Turn any YouTube tutorial or lecture into structured notes, a glossary, ten self-test questions with answers and a practice exercise using Gemini.
You fill in 12:34my level: beginner…paste YouTube link
Turns any YouTube link into a one-paragraph gist, timestamped key points, quotable lines and the parts you can safely skip.
You fill in paste YouTube linkthe practical steps…
What sets Gemini apart is what it can reach: your Gmail, Docs and Drive, public YouTube videos, Google Search, and whatever you upload. A prompt that points at none of that gets the answer any chatbot would give. That's why every prompt on this page opens by naming the material, and then spends the rest of its length on what to do with it. Five things carry most of the weight.
Here's the pattern short enough to type from memory:
@[Gmail / Drive / Docs] Find [the file, in words it contains]. I need it to decide [what you're deciding]. Answer as [a table / a numbered list] with [the parts]. If the file doesn't say, write "not mentioned". Put the date or section next to every point.
The prompts below are that pattern worked out for one job each. The Gmail Thread Summarizer treats the newest message as the current state, so a reversed decision doesn't come back to life. The Document Comparison Table lists the files it opened before comparing anything, which tells you straight away if it grabbed the wrong one.
The third column matters more here than on most hubs. Have that material ready before you paste.
| You want to | Use | Attach or link first |
|---|---|---|
| Catch up on a long email thread | Gmail Thread Summarizer | The thread, through @Gmail |
| Answer an email in your own voice | Email Reply Drafter | The message, through @Gmail |
| Tighten a Doc before it goes out | Docs Draft Polisher | The Doc, through @ or pasted |
| Turn a long report into a deck | Slides Deck Outliner | The report, uploaded or from Drive |
| See where several proposals differ | Document Comparison Table | Two or more files |
| Find out what a sales export says | Spreadsheet Data Analyst | The Sheet, or a CSV or XLSX |
| Get a formula you can't work out | Sheets Formula Builder | Tab names, column letters, a few rows |
| Automate a weekly Sheets or Gmail chore | Apps Script Automator | The sheet and its exact tab names |
| Log a stack of receipts | Receipt Expense Logger | Receipt photos or PDFs, uploaded |
| Get the point of a video you won't watch | YouTube Video Summarizer | The YouTube link |
| Study from a lecture or tutorial | YouTube Course Notes | The YouTube link |
| Check a claim someone sent you | Live Fact Checker | The text or post |
| Scope a big research question | Deep Research Brief | Deep Research switched on, plus files you hold |
| Plan a trip around real opening hours | Trip Itinerary Builder | Nothing; it searches |
| Save a weekly job so it starts the same way | Gem Builder | A description of the job |
Editing your own photos in Gemini is a different kind of prompt, and it has its own collection: Gemini photo prompts. For prompts that don't need your Google account at all, the ChatGPT and Claude pages run fine in Gemini, and our Gemini prompt examples sort eighteen more blocks by what you hand over.
We wrote this pair to show what naming the source does. The first is how a busy Monday request tends to look:
Summarize the budget emails.
Gemini has to guess which emails, from whom, and over what period. You'll get a summary of something, and you won't know what. The second version names all of it:
@Gmail Find the emails from Dana Ortiz about the Q4 event budget, sent in September and October. I need to know what's approved before Thursday's planning call. Give me the approved total, the lines still open, and anything Dana is waiting on from me. Where a figure was revised, use only the latest one and show the email date.
Now the search has a sender, a topic and a window. The latest-figure rule deals with the budget that changed twice, and the date beside each number lets you open the right email in one click if something looks off. For a single thread, the Gmail Thread Summarizer asks for all of this already.
Stay in the same chat. Gemini keeps track of the source you named, so the repair is one line.
| The answer | Reply with |
|---|---|
| Used an old email or an old version | Use only messages from [date] onward, and list the date of every email you used. |
| Drifted into general advice | Answer only from [file name]. Quote the line each point comes from. |
| Missed something deep in a long file | List the section headings you read. Then go back through [section] and redo point [number]. |
| Gave you an Excel formula | This is Google Sheets. Rewrite it using Sheets functions only. |
| Summarized a video you can't check | Add a timestamp to every point so I can jump to it. |
| Proposed a research plan that's too wide | Drop sub-questions [numbers] and limit sources to [region] and [years]. |
| Is too long to forward | Cut this to the five lines I'd send my manager. |
These come from what Google's help pages say Gemini can't do, and they explain most odd results with your own files.
These are as of October 2026, from Google's Gemini help center. Google changes them often.
Our Gemini review keeps the plans and prices, and Gemini vs ChatGPT covers which one to open for what.
For the prompts that reach into your account, yes. Gmail Thread Summarizer expects you to open the thread and reference it with @Gmail, and Sheets Formula Builder expects the file through @Google Drive, so the Workspace connection must be switched on and the signed-in account must be the one holding the files. Without it, paste the thread text or a sample of rows.
It processes the video itself rather than the title and description, which is why YouTube Video Summarizer can return timestamps and quotes in the speaker's own words. The prompt tells it to stop and say so if the video is not available to it, so a private or region-blocked link produces a refusal instead of an invented summary.
A Gem is a saved set of instructions you pick from the side panel, so a repeated job starts the same way every time without pasting anything. Save one when you run the task weekly and always bring the same kind of file. Gem Builder interviews you first, then writes the name, the card description, the instruction text and test questions. As of October 2026, Google says Gems on personal accounts turn into skills from November 2026, called with a slash; the name, description and instructions carry over as they are.
Tell it to search and to cite. Live Fact Checker asks for a source link next to each claim, so anything unsupported stands out immediately. For a larger question, Deep Research Brief scopes the run before a single source is read, naming the sub-questions, the sources you trust and the exclusions, and it stops for your approval first.
Gemini Photo Prompts ChatGPT Prompts Claude Prompts Grok Prompts
One email a week: the best new prompts and one short guide. Unsubscribe any time. Privacy policy