Ventsislav Minev
IT professional and n8n enthusiast
Templates by Ventsislav Minev
Organize email attachments into Google Drive folders by company with Gmail & Sheets
Automated Email Attachment Organizer Automatically process labeled emails with attachments into organized Google Drive folders --- Who Is This For? Teams or Individuals needing to: Automatically sort invoices, receipts, and files. Organize client documents by date. Verify sender emails against a whitelist. Timestamp files to avoid duplicate names. --- What Does This Workflow Solve? π Manual Email Sorting: Saves time by automating the organization of email attachments. π Disorganized Cloud Storage: Ensures attachments are neatly stored in Google Drive folders. π§ Unverified Sender Issues: Filters and validates emails using a whitelist. π Duplicate Filenames: Uses timestamps to ensure every file name is unique. --- Setup Guide Pre-Requisites Whitelist Sheet: Make a copy of the Example Whitelist Sheet Gmail Filter: Create a filter in Gmail to label emails with attachments. To Create a Gmail Filter: Open your Gmail Inbox. Click the search bar and select "Show search options". Enter your criteria (e.g., type has:attachment). Click "Create filter". Choose "Apply the label: Custom_Label" and save. --- Credentials Setup Make sure your n8n instance is connected with: Gmail Account: (via OAuth2) Google Drive Account: (via OAuth2) Google Sheets (via OAuth2) --- Configure Your n8n Workflow Nodes Trigger and Email Retrieval Gmail Trigger: Setup check interval and filters for emails (i.e. emails labeled with Custom_Label) Whitelist settings Lookup in Sheets: Searches for a row with the sender email. Configure this node to point to your whitelist spreadsheet containing two columnds: |email|company| File storage location Confirue parent folder to create sub-folders and store files into in the Create Company Folder node Parent Folder dropdown --- Final Steps Test Your Workflow: Run the workflow to verify emails are processed and files are uploaded correctly. --- Happy Automating!
Google Drive duplicate file manager
Google Drive Duplicate File Manager π§Ήπ Purpose: Automate the process of finding and managing duplicate files in your Google Drive. Who's it for? Individuals and teams aiming to streamline their Google Drive. Anyone tired of manual duplicate file cleanup. What it Solves: Saves storage space πΎ. Reduces file confusion πβ‘οΈπ. Automates tedious cleanup tasks π€. How it works: Trigger: Monitors a Google Drive folder for new files. Configuration: Sets rules for keeping and handling duplicates. Find Duplicates: Identifies duplicate files based on their content (MD5Checksum). Action: Either moves duplicates to trash or renames them. Setup Guide: Google Drive Trigger β°: Set up the trigger to watch a specific folder or your entire drive (use caution with the root folder! β οΈ). Configure the polling interval (default: every 15 minutes). Config Node βοΈ: keep: Choose whether to keep the "first" or "last" uploaded file (default: "last"). action: Select "trash" to delete duplicates or "flag" to rename them with "DUPLICATE-" (default: "flag"). owner & folder: Taken from the trigger. Only change if needed. Key Considerations: Google Drive API limits: Be mindful of API usage. Folder Scope: The workflow handles one folder depth by default. (WARNING: If configured to work with the Root folder / all files in all sub-directories are processed so USE THIS OPTION WITH CAUTION since the workflow might trash/rename important files) Google Apps: Google docs are ignored since they are not actual binary-files and their content can't be compared. Enjoy your clean Google Drive! β¨
UptimeRobot alerts to Telegram with visual verification
UptimeRobot Alerts to Telegram with Visual Verification Automatically sends Telegram notifications with optional screenshots when monitors change status (β UP/π΄ DOWN/βΈοΈ PAUSED) Example Message in Telegram: Who Is This For? Teams or individuals needing to: Get alerts when websites/services go down Verify outages with visual screenshots Monitor infrastructure from Telegram What Does This Workflow Solve? π¨ Missed Alerts: Get immediate notifications in Telegram πΌοΈ Visual Verification: Optional screenshot confirmation of outages π Status Tracking: Clear records of when issues began/resolved π One-Click Access: Direct links to affected monitors β±οΈ Time Savings: No need to check dashboards manually Setup Guide Pre-Requisites UptimeRobot Account: With at least one monitor configured Gmail Account: To receive alert notifications Telegram Account: To receive alerts (mobile/desktop app recommended) (Optional) ScreenshotMachine free/paid account Credentials Setup Make sure your n8n instance is connected with: Gmail Account (via OAuth2) UptimeRobot API (via API key) Telegram Bot (via bot token) (Optional) ScreenshotMachine (via customer key) Configure Your n8n Workflow Nodes Alert Trigger Gmail Trigger: Configure to watch for emails from alert@uptimerobot.com Set appropriate polling interval (e.g., every 5 minutes) Monitor Configuration Conf Node: Set your preferences: json { "take_screenshot": true, "screenshotmachine_secret": "your-secret-here", "screenshotmachine_device": "desktop", "screenshotmachine_dimension": "1366xfull", "screenshotmachine_format": "png" } Notification Settings Telegram Nodes: Set your Chat ID (find with @getidsbot) Customize message formatting if needed Service-Specific Setup UptimeRobot: Go to Dashboard β My Settings β API Settings Create API key with "Monitor Read" permissions Enable email alerts in monitor settings Telegram Bot: Message @BotFather to create new bot Get your Chat ID using @getidsbot Add bot token to n8n credentials ScreenshotMachine (Optional): Sign up at screenshotmachine.com Get Customer Key from account dashboard Set your secret phrase if using hash verification Final Steps Test your workflow by manually triggering a monitor status change Verify Telegram notifications arrive as expected Check screenshot quality if enabled Monitor for a few days to fine-tune alert preferences Happy Monitoring!