Automated Invoice Management for Orlen

• Finance Teams: To automate the process of managing invoices received from Orlen.
• Small Business Owners: To streamline invoice handling without manual intervention.
• Office Managers: To ensure timely organization of financial documents in Google Drive.
• Tech-Savvy Individuals: To leverage automation tools for efficient workflow management.

This workflow addresses the challenge of manually tracking and organizing invoices from Orlen. By automating the process, it ensures that invoices are received, stored, and acknowledged without human error, thereby saving valuable time and reducing the risk of missing important financial documents.

• Trigger: The workflow can be initiated either manually by clicking 'execute' or automatically every day at 23:45.
• Fetch Current Date: It retrieves the current year, month, and day to facilitate folder organization.
• Get Year Folder: Searches Google Drive for a folder named after the current year to store invoices.
• Get Month Folder: Within the year folder, it looks for a subfolder named after the current month.
• Retrieve Invoices: It fetches all unread emails from Orlen containing attachments, ensuring that only relevant invoices are processed.
• Upload Invoices: Each invoice is uploaded to the appropriate month folder in Google Drive, with a naming convention that includes the invoice directory and file extension.
• Mark as Read: After uploading, the corresponding email is marked as read to prevent duplicate processing.
• Notify via Slack: Sends a notification to a specified Slack channel, informing users that a new invoice has been added, including details like the directory path, year, and month.