Automated Invoice Upload from Gmail to Google Drive with Slack Notifications

Overview

This workflow automates the process of extracting invoice emails from Gmail, uploading the attachments to organized folders in Google Drive, and sending notifications via Slack. It can be triggered manually or scheduled to run daily at 23:45.

Key Features

• Automated Email Retrieval: Fetches invoice emails (e.g., from Orlen) in Gmail.
• Dynamic Folder Management: Creates or locates year and month folders in Google Drive for organized storage.
• Attachment Upload: Uploads invoice attachments directly to the appropriate Google Drive folder.
• Email Management: Marks processed emails as read to prevent duplication.
• Real-Time Notifications: Sends Slack messages to inform users of successful uploads.

Benefits

• Time Savings: Eliminates manual downloading and organizing of invoices.
• Error Reduction: Ensures consistent, accurate filing and reduces risk of missed invoices.
• Improved Collaboration: Slack notifications keep teams informed instantly.

Use Cases

• Finance Teams: Automate invoice archiving and streamline expense tracking.
• Small Businesses: Maintain organized digital records for accounting and audits.
• Remote Teams: Ensure all stakeholders are promptly notified of new invoices.

Integrations

• Gmail: For email retrieval and management.
• Google Drive: For secure, structured document storage.
• Slack: For instant team notifications.