email-receipt-scanning

Email Receipt Scanning

Purpose

Provides Gmail search queries, Danish sender patterns, email content type detection, and deduplication rules for scanning a user's inbox for receipts and invoices. Used by the /smartspender:receipt email command.

Prerequisites

This skill requires the Gmail MCP server to be configured in the user's environment. The following MCP tools are needed:

• gmail_search or equivalent — search emails by query
• gmail_get_message or equivalent — read email content and metadata
• gmail_get_attachment or equivalent — download PDF attachments

If Gmail MCP is not available, commands using this skill should fail gracefully with a clear message.

Gmail Search Queries

Primary Search Query

Search for receipt and invoice emails using this combined query:

subject:(faktura OR kvittering OR receipt OR invoice OR ordre OR order OR betaling) has:attachment after:{YYYY/MM/DD}

Where {YYYY/MM/DD} is either:

• The last_email_scan timestamp from settings.csv (incremental scan)
• A calculated date based on the days argument (e.g., 30 days back)
• Default: 90 days back if no previous scan and no argument

Supplementary Queries

If the primary query returns few results, also try:

from:(*faktura* OR *invoice* OR *noreply* OR *no-reply*) has:attachment after:{YYYY/MM/DD}

subject:(ordrebekraeftelse OR orderbekraeftelse OR betalingsbekraeftelse) after:{YYYY/MM/DD}

Query Notes

• has:attachment ensures only emails with files are returned (most invoices are PDF attachments)
• Danish keywords (faktura, kvittering, betaling) catch Danish vendor emails
• English keywords (receipt, invoice, order) catch international vendors
• Date filter prevents re-scanning old emails

Danish Sender Patterns

Map known email sender domains to vendor IDs for faster vendor detection:

Sender Pattern	Vendor ID	Vendor Name	Type
*@tdc.dk	tdc	TDC	Telecom
*@tdcnet.dk	tdc	TDC	Telecom
*@telenor.dk	telenor	Telenor	Telecom
*@telia.dk	telia	Telia	Telecom
*@orsted.dk	orsted	Oersted	Electricity
*@hofor.dk	hofor	HOFOR	Water
*@norlys.dk	norlys	Norlys	Electricity
*@ewii.dk	ewii	EWII	Utility
*@dinenergi.dk	dinenergi	Din Energi	Electricity
*@netflix.com	netflix	Netflix	Streaming
*@spotify.com	spotify	Spotify	Streaming
*@amazon.com	amazon	Amazon	Online order
*@amazon.de	amazon	Amazon	Online order
*@zalando.dk	zalando	Zalando	Online order
*@ikea.com	ikea	IKEA	Online order
*@wolt.com	wolt	Wolt	Delivery
*@nemlig.com	nemlig	Nemlig	Delivery