Daily Invoice Report to Slack

🎯 The Problem It Solves

Stop manually checking Gmail for invoice emails and filing them away. This recipe automatically finds invoice emails from a specific date, saves all attachments to organized Google Drive folders (Invoices/YYYY-MM-DD), and posts permanent access links to your Slack channel.

📥 What You Provide

Input	What to enter
search_date	Date to search for invoices in YYYY/MM/DD format (example: "2025/12/26")
slack_channel_name	Slack channel name WITHOUT # prefix (example: "finance")
search_keywords	Optional keywords to filter emails (example: "invoice OR receipt OR bill")

⚡ What Happens

Actions:

Searches Gmail for invoice emails with attachments
Creates organized Google Drive folder structure: Invoices/YYYY-MM-DD
Uploads all invoice PDFs to the Drive folder
Posts summary to Slack with permanent Drive links in thread

Returns:

Count of invoices found and uploaded
Direct link to the Slack message with all Drive file links
Permanent storage in Google Drive

How: Gmail search → Download attachments → Upload to Drive folder → Share Drive links to Slack

📤 What You Get Back

Output	Description
invoices_found	Number of invoice emails discovered on the search date
attachments_downloaded	Total count of invoice files uploaded to Google Drive
slack_message_link	Direct URL to view the Slack message with all Drive links

🔌 Connections Required

App	Why
Gmail	Search emails and download invoice attachments
Google Drive	Store invoice files permanently in organized folders
Slack	Post notifications and permanent Drive file links to team channels

📋 Good to Know

Best for:

Finance teams, accountants, and business owners tracking daily invoices
Long-term invoice archiving with permanent access

Tip:

Files are stored permanently in Google Drive
Folder structure makes it easy to find invoices by date
Share Google Drive folder with accounting team for direct access

Limit:

Searches up to 50 emails per run (sufficient for most daily invoice volumes)