# 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.

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.

- Page: https://thesolocreators.com/prompts/emailed-receipts-filed-and-logged-automatically/
- Category: Put your business on autopilot
- Made for: Small business owners, Consultants, Coaches, Creators
- Works in: Gemini, Gmail
- Time: About 30 minutes to set up, then 10 minutes a month to review
- Effort: Advanced
- Note: Needs a Google Workspace business plan with Gemini on. Use a Drive folder and sheet only you own, or the flow fails.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
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.
```

## 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.

## Good to know

**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.

Idea spotted on the web, shared by Howard Wen (Computerworld): https://www.computerworld.com/article/4147208/how-to-build-your-own-ai-agents-with-google-workspace-studio.html. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Second Brain (Give your AI a memory it reads across every project, so it finally knows your business); Watch It For Me (Drop any video link and get the step-by-step playbook, the full timestamped transcript, and the best quotes. Without watching it).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.