Automated invoice follow-ups with smart response tones via Google Sheets & email
🔍 How It Works This AI Agent checks your invoice database (Google Sheets) daily and looks for unpaid invoices that are past their due date. It calculates how many days each invoice is overdue (Days Past Due / DPD), then automatically crafts a follow-up message with an appropriate tone: 1–7 days overdue: Friendly reminder 8–14 days overdue: Slightly firm nudge 15+ days overdue: Final warning tone After generating the message, it sends the follow-up via email to the client and logs the interaction. You can extend this to send WhatsApp messages, Slack alerts, or update a CRM. ⚙️ Set Up Steps Connect Google Sheets : Replace YOURSHEETID in the workflow with the actual Sheet ID Make sure your sheet has these columns: clientname, email, invoicenumber, due_date, status Adjust Cron Trigger By default, it runs daily — you can change the frequency in the “Daily Trigger” node. Configure Email Node Set your email sender (Gmail, SMTP, or Mailgun) in the “Send Email” node. Customize Messages (Optional) Modify tone and content in the “Generate Message” node based on your brand style. Run & Monitor Activate the workflow Monitor activity in Google Sheets or add a logging step (Notion, Slack, etc.)
By MarthAutomated daily workflow backups to Google Drive with cleanup
n8n Workflow Backup System 👥 Who's it for This workflow is perfect for n8n users who want to automatically backup all their workflows 💾 to Google Drive with zero manual effort. Perfect for teams managing multiple workflows or anyone who values data safety! 🔒 🤖 What it does It automatically creates daily backups of all your n8n workflows to Google Drive in readable JSON format, organizes them in dated folders, and cleans up old backups to save storage space. Set it and forget it! ✨ ⚙️ How it works Spanish Version (Español) 🇪🇸 ⏰ Schedule Trigger – Runs automatically every day at 4:00 AM 📁 Create New Folder – Creates a timestamped backup folder in Google Drive 🔌 n8n API Connection – Fetches all workflows from your n8n instance 🔄 Loop Over Items – Processes each workflow individually through two paths: Upper Path (Cleanup): 🗂️ Get Folders – Retrieves all existing backup folders 🔍 Filter – Excludes the current folder 🗑️ Delete Folder – Permanently removes old backups Lower Path (Backup): 📄 Convert to File – Transforms workflow to formatted JSON ☁️ Google Drive – Saves JSON file to backup folder English Version 🇬🇧 Identical functionality with English interface 📋 Requirements n8n instance with API access enabled Google Drive account with sufficient storage n8n API credentials configured Google Drive OAuth2 credentials configured 🛠️ How to set up Configure n8n API credentials: Format: https://your-instance.n8n.io/api/v1 Generate API key from your n8n instance settings Set up Google Drive credentials: Connect your Google account via OAuth2 Grant necessary permissions for folder creation and file management Configure target folder: Create a parent folder in Google Drive (e.g., "N8N Backups") Copy the folder ID from the URL Update the folderId in "create new folder" nodes Adjust schedule (optional): Default: 4:00 AM daily Modify triggerAtHour in Schedule Trigger node Test manually: Use the Manual Trigger to test before scheduling Verify folders are created and files are saved correctly Activate the workflow ✅ 🎨 How to customize Change backup frequency: Modify Schedule Trigger settings (hourly, weekly, monthly) Keep multiple backup versions: Remove or modify the cleanup path to retain more history Change folder naming: Edit the folder name format in "create new folder" node (default: Workflow Backups [day] [time] [date]) Backup to different location: Change the parent folder ID Add notifications: Include email/Slack nodes to get backup completion alerts Filter specific workflows: Add Filter node after n8n node to backup only certain workflows ⚠️ Important Notes Old backups are permanently deleted by default to save space Ensure sufficient Google Drive storage for your workflow size API credentials must have read access to all workflows The workflow processes items sequentially to avoid rate limits
By Jose Bossa