All AI use cases AI agent use cases

Get 3 new AI use cases every weekday

One full use case with its copy-paste prompt, plus 2 quick picks. Free, and one click to unsubscribe.

You're in. Watch your inbox on weekday mornings.

Put your business on autopilot

Get every emailed receipt filed in Drive and logged in a sheet

It runs on every new email from then on, so tax time starts with a full folder and a finished sheet.

About 30 minutes to set up, then 10 minutes a month to review Advanced

A sketch of what you'll get back.

Your prompt

Fill in your details. Skip any you like.

This AI can't be filled in from a link, so the button copies your prompt: paste it into the new chat.

The prompt that gets copied

Build me an automation for my receipts and bills.

Starter: whenever I get a new email that looks like a receipt, invoice or bill, with or without an attachment.

Step 1: Decide if it's really a receipt, invoice or bill. Skip marketing emails, shipping updates and order confirmations with no amount.

Step 2: If so, save the attachment (or a PDF of the email) to my Google Drive folder [FOLDER NAME, e.g. Receipts 2026].

Step 3: Pull out the date, vendor, amount, currency, what it was for, and the due date if it's a bill. Add one row to my Google Sheet [SHEET NAME, e.g. Expense Log] with those details and a link to the saved file.

Step 4: Pick a category from this list only: [YOUR CATEGORIES, e.g. software, travel, supplies, meals]. If you're unsure of any value, write 'check' instead of guessing.

Never pay, reply to, forward or delete anything.

Build one flow in Google Workspace Studio. Each time a receipt or bill lands in Gmail, Gemini saves the file to Drive and adds the date, vendor and amount to a sheet. Your monthly expense roundup builds itself.

Step by step

  1. Create a Drive folder called Receipts and a Google Sheet with date, vendor, amount and category columns.
  2. Go to studio.workspace.google.com and describe your flow to Gemini with the prompt below.
  3. Check each step Gemini builds: the new email starter, the save to Drive step and the add a row step.
  4. Test it on one real receipt (tests take real actions), then click Turn on.
  5. Scan the sheet once a month for wrong amounts before you pay a bill or send it to your bookkeeper.

What you'll get

A live expense sheet that fills itself as receipts and bills arrive, every file saved in one Drive folder, and unsure values marked 'check' for you.

Needs a Google Workspace business plan with Gemini on. Use a Drive folder and sheet only you own, or the flow fails.

Made for
Small business owners, Consultants, Coaches, Creators
Works in
Gemini, Gmail

Frequently Asked Questions.

Which AI tools does this work in?

It works in Gemini and Gmail. On this page, one tap copies the prompt and opens the app, so you just paste. Needs a Google Workspace business plan with Gemini on. Use a Drive folder and sheet only you own, or the flow fails.

How long does it take?

About 30 minutes to set up, then 10 minutes a month to review. It's rated "Advanced". There are 5 steps, listed above.

What do I need before I start?

Just your details for 3 blanks: folder name, sheet name and your categories. You can skip any, and your AI will ask for them.

What will I get back?

A live expense sheet that fills itself as receipts and bills arrive, every file saved in one Drive folder, and unsure values marked 'check' for you.

Find more like this in AI agent use cases, For content creators, For small business and For coaches.

More ways to put your business on autopilot.

See all 48 ways to put your business on autopilot