Using Zapier, find emails in my Outlook inbox from the last 7 days that mention an invoice or a receipt. Show me the sender, date and amount for each one, and wait for my OK before adding them as rows in my Google Sheet called Invoices.
This prompt finds invoice and receipt emails in your Outlook inbox from the last week, shows you the sender, date and amount for each one and, once you approve, adds them as rows in a Google Sheet.
Apps you need: Outlook and Google Sheets, both connected to Zapier MCP
Good for: freelancers, small teams and finance admins who log invoices by hand
Make it yours
- Point it at any sheet you manually update by changing
Invoices. - Use Gmail instead of Outlook by naming it.
- Run it every Friday so the log builds up week by week.
Tips
- No rows are added until you say yes, so check the amounts against the emails before you approve.
Tried it on your own inbox? Let us know if the amounts matched up, or what else you logged from email.
