Automate FAQ responses with WhatsApp keyword detection bot
How it works: This bot operates in a continuous WhatsApp monitoring loop. It analyzes messages to detect keywords in common questions (like hours, prices, and location) and sends automatic replies with predefined information. For unrecognized questions, it directs the user to manual assistance. Set up steps: The initial setup involves integrating with the WhatsApp API, registering keywords and their respective responses, and defining the fallback flow. It takes only a few minutes to have the bot running with essential information.
By Solido AIAutomated weekly project cost reports with MySQL and Outlook HTML emails
Automated Weekly Project Cost Reports with MySQL and Outlook HTML Emails ๐ง Use Case Need to keep your finance or operations team updated on missing project costs? This practical automated report workflow does the job without AI โ and saves hours weekly. Runs on a weekly schedule Queries your MySQL database for projects missing cost data Filters by budgetedprojectcost IS NULL Generates a clean HTML email report Sends it through Microsoft Outlook to relevant teams ๐ How It Works Schedule Trigger โ Runs every Monday at 8 AM MySQL Node โ Connects and runs SQL to fetch project data missing budgetedprojectcost Switch Node โ Routes logic based on cost_center (e.g., Retail, Service, Projects) Outlook Nodes โ Sends formatted HTML emails; each node handles a specific group Dynamic Content โ Inject values using mustache tags like {{ $json.project_name }} ๐ง Setup Instructions MySQL Setup: Ensure the MySQL node is connected using a valid credential set: Hostname/IP Port (default: 3306) Database name Username with SELECT permissions Password Query Example: sql SELECT projectname, costcenter FROM tabProject WHERE status = 'Open' AND projecttype = 'External' AND budgetedproject_cost IS NULL; Outlook Configuration: Connect your Microsoft Outlook node using OAuth2 credentials. Rename each Outlook node clearly (e.g., Send Email - Retail, Send Email - Service). Switch Node: Modify cost center values as needed to match your organization (e.g., 'Retail', 'Service', 'Projects'). HTML Email Formatting: Customize the HTML message body using inline styles and mustache syntax. Sample: html <h3>Missing Budgeted Cost Report</h3> <ul> <li>Project: {{ $json.project_name }}</li> <li>Cost Center: {{ $json.cost_center }}</li> </ul> Recipients: Replace amjid@amjidali.com with the actual email addresses of the concerned teams. ๐ Read More ๐ Why Simple Workflows Work ๐บ Demo & Tutorial ๐ฅ Watch the video walkthrough: https://youtube.com/@syncbricks --- ๐ค About the Creator Amjid Ali ๐ amjidali.com ๐ n8n Book ๐ Learn n8n > โStart simple, scale smart. Even basic workflows like this can save your team hours!โ โ Amjid Ali
By Amjid AliComplete backup solution for n8n workflows & credentials (local/FTP)
Automated n8n Workflows & Credentials Backup to Local/Server Disk & FTP Complete backup solution that saves both workflows and credentials to local/server disk with optional FTP upload for off-site redundancy. What makes this workflow different: Backs up workflows AND credentials together Saves to local/server disk (not Git, GitHub, or any cloud services) Optional FTP upload for redundancy (disabled by default) Comprehensive error handling and email notifications Timezone-aware scheduling Ready to use with minimal configuration How it works Backup Process (Automated Daily at 4 AM): Initialisation - Sets up timezone-aware timestamps and configurable backup paths for both local/server disk and FTP destinations Folder Creation - Creates date-stamped backup directories (YYYY-MM-DD format) on local/server disk Dual Backup Operations - Processes credentials and workflows in two separate branches: Credentials Branch: Exports n8n credentials using the built-in CLI command with backup flag Lists exported credential files in the credentials folder Reads each credential file from disk Optional: Uploads to FTP server (disabled by default) Optional: Logs FTP upload results for credentials Workflows Branch: Retrieves all workflows via n8n API Cleans workflow names for cross-platform compatibility Converts workflows to formatted JSON files Writes files to local/server disk Optional: Uploads to FTP server (disabled by default) Optional: Logs FTP upload results for workflows Data Aggregation - Combines all workflow data with binary attachments for comprehensive reporting Results Merging - Consolidates credentials FTP logs, workflows FTP logs, and aggregated workflow data Summary Generation - Creates detailed backup logs including: Statistics (file counts, sizes, durations) Success/failure tracking for local and FTP operations Error tracking with detailed messages Timezone-aware timestamps Notifications - Sends comprehensive email reports with log files attached and saves execution logs to disk How to use Initial Setup: Configure the Init Node - Open the "Init" node and customize these key parameters in the "Workflow Standard Configuration" section: javascript // Admin email for notifications const N8NADMINEMAIL = $env.N8NADMINEMAIL || 'youremail@world.com'; // Workflow name (auto-detected) const WORKFLOW_NAME = $workflow.name; // Projects root directory on your server const N8NPROJECTSDIR = $env.N8NPROJECTSDIR || '/files/n8n-projects-data'; // projects-root-folder/ // โโโ Your-project-folder-name/ // โโโ logs/ // โโโ reports/ // โโโ ... // โโโ [other project files] // Project folder name for this backup workflow const PROJECTFOLDERNAME = "Workflow-backups"; Then customize these parameters in the "Workflow Custom Configuration" section: javascript // Local backup folder (must exist on your server) const BACKUPFOLDER = $env.N8NBACKUP_FOLDER || '/files/n8n-backups'; // FTP backup folder (root path on your FTP server) const FTPBACKUPFOLDER = $env.N8NFTPBACKUP_FOLDER || '/n8n-backups'; // FTP server name for logging (display purposes only) const FTPName = 'Synology NAS 2To'; These variables can also be set as environment variables in your n8n configuration. Set Up Credentials: Configure n8n API credentials for the "Fetch Workflows" node Configure SMTP credentials for email notifications Optional: Configure FTP credentials if you want to enable off-site backups Configure Backup Folder: Ensure the backup folder path exists on your server Verify proper write permissions for the n8n process If running in Docker, ensure volume mapping is correctly configured Customize Email Settings: Update the "Send email" node with your recipient email address or your "N8NADMINEMAIL" environment value Adjust email subject and body text as needed Enabling FTP Upload (Optional): By default, FTP upload nodes are disabled for easier setup. To enable off-site FTP backups: Simply activate these 4 nodes (no other changes needed): "Upload Credentials To FTP" "FTP Logger (credentials)" "Upload Workflows To FTP" "FTP Logger (workflows)" Configure FTP credentials in the two upload nodes The workflow will automatically handle FTP operations and include upload status in reports Requirements n8n API credentials (for workflow fetching) SMTP server configuration (for email notifications) Adequate disk space for local backup storage Proper file system permissions for backup folder access Docker environment with volume mapping (if running n8n in Docker) Optional: FTP server access and credentials (for off-site backups) Good to know Security: Credentials are exported using n8n's secure backup format - actual credential values are not exposed in plain text Timezone Handling: All timestamps respect configured timezone settings (defaults to Europe/Paris, configurable in Init node) File Naming: Automatic sanitization ensures backup files work across different operating systems (removes forbidden characters, limits length to 180 characters) FTP Upload: Disabled by default for easier setup - simply activate 4 nodes to enable off-site backups without any code changes Connection Resilience: FTP operations include error handling for timeout and connection issues without failing the entire backup Graceful Degradation: If FTP nodes are disabled, the workflow completes successfully with local backups only and indicates FTP status in logs Error Handling: Comprehensive error catching with detailed logging and email notifications Dual Logging: Creates both JSON logs (for programmatic parsing) and plain text logs (for human readability) Storage: Individual workflow JSON files allow for selective restore and easier version control integration Scalability: Handles any number of workflows efficiently with detailed progress tracking --- This automated backup workflow saves your n8n data to both local disk and FTP server. To restore your backups, use: "n8n Restore from Disk - Self-Hosted Solution" for local/server disk restores "n8n Restore from FTP - Remote Backup Solution" for FTP remote restores
By FlorentSync customer email subscriptions between Shopify and Mautic
Having a seamless flow of customer data between your online store and your marketing platform is essential. By keeping your systems synchronized, you can ensure that your marketing campaigns are accurately targeted and effective. The integration between Shopify, a leading e-commerce platform, and Mautic, an open-source marketing automation system, is not available out-of-the-box. However, with a n8n workflow you can bridge this gap with. This template will help you: enhance accuracy in marketing lists by ensuring that subscription changes in Shopify are instantly updated in Mautic. improve compliance with data protection laws by respecting users' subscription preferences across platforms achieve integration without the need for additional plugins or software, minimizing complexity and potential points of failure. This template will demonstrate the follwing concepts in n8n: working with Shopify in n8n control flow with the IF node use Webhooks validate Webhooks with the Crypto node use the GraphQL node to call the Shopify Admin API The template consists of two parts: Sync Email Subscriptions from Shopify to Mautic Sync Email Subscriptions from Mautic to Shopify How to get started? Create a custom app in Shopify get the credentials needed to connect n8n to Shopify This is needed for the Shopify Trigger Create Shopify Acces Token API credentials n n8n for the Shopify trigger node Create Header Auth credentials: Use X-Shopify-Access-Token as the name and the Acces-Token from the Shopify App you created as the value. The Header Auth is neccessary for the GraphQL nodes. Enable the Mautic API under Configuration/API Settings, After the settings are saved you will have an additional entry in your settings menu to create API credentials for n8n Create Mautic credentials in n8n Please make sure to read the notes in the template. For a detailed explanation please check the corresponding video: https://youtu.be/x63rrh_yJzI
By SaschaMonitor USDT ERC-20 wallet balance with Etherscan and Telegram notifications
Overview This n8n workflow is specifically designed to monitor the USDT ERC-20 balance within a specific wallet. It uses Etherscan's public blockchain database, which does not require API authentication, to periodically check and process transaction data. This workflow is ideal for users who need an automated solution to track ERC-20 wallet transactions. Features Automatic Monitoring: Executes every 5 minutes to capture new transactions. Customizable Filters: Customize tracking based on parameters like transaction duration and wallet addresses. Data Aggregation: Compiles transaction data into a single, structured list. Formatted Outputs: Presents processed data in an organized format. Telegram Tracking: Tracks wallet balances via Telegram notifications using the bot. Requirements n8n Setup: Requires a self-hosted or cloud-based n8n instance. Basic Understanding: Basic knowledge of n8n workflows and nodes. Installation and Configuration Import Workflow: Load the provided JSON workflow into your n8n instance. Configure the User Data Node: Enter your ERC-20 Wallet Address in the 'Your Wallet Address' field. Enter your Etherscan API Key in the โYour Etherscan API Keyโ field. Enter your USDT ERC-20 Contract Address in the "Your ERC-20 USDT Contract Address" field (0xdAC17F958D2ee523a2206206994597C13D831ec7). You can also monitor another token by entering a different contract address. Configure the Telegram Node: Go to Telegram and search for "BotFather". Select /newbot from the BotFather menu to create your bot. Get the API key BotFather provides. Go to Telegram and search for "Get My ChatID". Start the conversation and get your ChatID. Use this information to configure the Telegram Node. Schedule Trigger Node: By default, the workflow is triggered every 5 minutes. Adjust this according to your needs. Test the Workflow: Execute the workflow manually to ensure everything is working as expected. How It Works Schedule Trigger: Starts the workflow at predetermined intervals. Edit Fields: Sets the wallet address, Etherscan API key, and USDT ERC-20 token address. Edit Telegram Settings: Create a bot via BotFather. Configure the API key and Telegram Chat ID. Etherscan Data Import: Collects transaction data from the ERC-20 wallet using Etherscan's public database. Final Results: Organizes and formats the transaction data for review. Telegram Bot Message Sending: If there is a balance change, it sends a formatted message about the balance change. If there is no balance change, it sends a message that your balance has not changed. You can configure it to avoid sending a message when there is no change.
By FORK SOFTWARE TECHNOLOGIES INC.Get daily poems in Telegram
This workflow posts a poem translated into English every day in a Telegram chat. Cron node: triggers the workflow every day at 10:00. You can change the time and interval based on your use case. HTTP Request node: makes an HTTP request to the Poemist API that returns a random poem. LingvaNex node: translates the returned poems into English. Telegram node: takes in the translated poem and posts it in the chat.
By LorenaAutomate weekly marketing reports with GoMarble MCP, Claude AI & Gmail
Automated Marketing Analytics Report with AI Agent How it works Transform your marketing data into actionable insights with this intelligent automation workflow. The system combines scheduled triggers with AI-powered analysis to deliver comprehensive marketing reports directly to your inbox. Key Features: Scheduled automated reporting (daily, weekly, or monthly) AI-powered data analysis using advanced language models Multi-platform marketing data integration via GoMarble MCP Intelligent report generation with actionable recommendations Direct email delivery of formatted reports Set up steps Prerequisites: GoMarble MCP account and API access Gmail account for report delivery n8n instance (cloud or self-hosted) Configuration Time: ~15-20 minutes Step-by-step setup: Connect GoMarble MCP to n8n Follow the integration guide: GoMarble n8n Setup Configure your marketing platform credentials (Google Ads, Facebook Ads, Analytics) Configure the Schedule Trigger Set your preferred reporting frequency Choose optimal timing for data availability Customize the Report Prompt Define specific metrics and KPIs to track Set analysis parameters and report format preferences Set up AI Agent Configuration Choose between Anthropic Claude or OpenAI models Configure the GoMarble MCP tools for your marketing platforms Configure Gmail Integration Set recipient email addresses Customize email template and subject line Advanced Configuration: Add conditional logic for performance thresholds Include custom data visualization requests Set up alert triggers for significant metric changes What you'll get Automated Intelligence: Regular marketing performance analysis without manual effort Cross-Platform Insights: Unified view of Google Ads, Facebook Ads, and Analytics data AI-Powered Recommendations: Strategic insights and optimization suggestions Professional Reports: Well-formatted, executive-ready marketing summaries Scalable Solution: Easy to extend with additional marketing platforms or custom metrics Perfect for marketing teams, agencies, and business owners who want to stay on top of their marketing performance with minimal manual work.
By Sankalp DevAutomated animal advocacy news research & weekly digest using Claude AI & Serper
Whoโs it for ๐ฏ This workflow is designed for animal advocacy organizations, activists, and campaigners who want to automatically receive a weekly email update summarizing the latest news and developments related to animal rights, welfare, vegetarianism, and veganism. It can also be easily altered to allow daily updates. How it works / What it does โ๏ธ Runs on a weekly schedule and uses a multi-tool research agent subworkflow to gather verified news strictly from the past week. It compiles the information and URLs into a clean, well-structured HTML email, then sends it to the specified recipient. URLs are never altered or omitted. How to set up ๐ ๏ธ Import this workflow into your n8n instance. Add and install the required research subworkflow: Multi-tool Research Agent for Animal Advocacy Configure API keys in n8n credentials. Set your topics, instructions, and recipient email in the โSet Preferencesโ node. Adjust the schedule node to control when emails are sent. Test the full workflow to ensure proper operation. Requirements ๐ n8n instance with internet access Valid API keys The Multi-tool Research Agent subworkflow installed SMTP or email sending configured How to customize ๐ง Update Topics: Change topics in the โSet Preferencesโ node to focus the research. Update Instructions: Tailor summary style and focus in the preferences node. Email Recipient: Set who receives the update email. Scheduling: Change frequency or time in the Schedule node. Duplicate for daily versions with adjusted research parameters. HTML Styling: Modify the โWrite HTMLโ nodeโs template for custom branding or layout. Error Handling: Add workflows to capture and alert on errors for robustness. --- Adapt and extend as needed for your advocacy goals!
By Open PawsTrack student arrival with iOS automation, Google Sheets & email alerts
This workflow automates real-time student tracking using iOS Shortcuts and geolocation data, notifying both teachers and parents based on geofenced logic. ๐ฏ What This Workflow Does Receives student location updates via webhook (iOS Shortcuts) Detects if the student has arrived at school Logs arrival data to Google Sheets Sends email alerts to teacher and/or parent based on location ๐ Workflow Steps | Step | Description | | --------------------------- | -------------------------------------------------------- | | Location Update Webhook | Triggered via iOS Shortcut when student location updates | | Process Location Data | Extracts coordinates and metadata | | Student Arrived? | Checks if student entered school zone | | Log School Arrival | Adds arrival data to Google Sheet | | At School? | Double-checks geofence condition before notifying | | Notify Teacher | Sends email if student is confirmed at school | | Notify Parent | Sends email to parent (can vary based on geofence logic) | | Success Response | Returns a 200 response to the triggering device | ๐ง How the Logic Works The studentโs phone runs a shortcut when near school. Sends coordinates to webhook. Workflow compares coordinates with predefined geofence (e.g., radius around school). If inside school zone: Log arrival Notify teacher and/or parent Else: Optionally notify parent only ๐ฑ iOS Shortcut Sample (Trigger Setup) Automation Trigger: Arrive at Location (e.g., School) Action: Run Shortcut โ Make Web Request (POST) POST URL: https://your-n8n-instance.com/webhook/location-update Body Example: json { "student_id": "STU042", "student_name": "Anaya Joshi", "lat": 19.0760, "lng": 72.8777, "timestamp": "2025-08-06T08:05:00" } ๐ Google Sheets Logging | Student ID | Name | Date | Time | Status | | ---------- | ----------- | ---------- | ----- | ------- | | STU042 | Anaya Joshi | 2025-08-06 | 08:05 | Arrived | โ๏ธ Setup Requirements n8n Instance with webhook support Google Sheet with appropriate columns iOS Shortcut setup on student device Teacher and Parent Email Addresses configured in workflow
By Oneclick AI Squad