by Don Jayamaha Jr
📰 This AI-powered agent performs real-time sentiment analysis on Tesla (TSLA) news to support trading decisions. It aggregates headlines from 5 trusted sources and uses DeepSeek Chat to classify sentiment and generate structured summaries. This tool is a critical sub-agent in the broader Tesla Quant Trading AI Agent system. ⚠️ Not standalone — this agent is designed to be executed by the Tesla Quant Trading AI Agent. ⚙️ Requires: DeepSeek Chat API Key 🔌 Workflow Role This tool processes Tesla-related news and produces output like: { "sentiment": "bullish", "summary": "Tesla stock rallied today after strong delivery numbers and Cybertruck updates. Analysts remain optimistic.", "topHeadlines": [ "Tesla beats Q2 delivery forecast – Yahoo Finance", "Cybertruck ramps up in Texas – Electrek", "Berlin Gigafactory expands battery production – CleanTechnica" ] } Its output feeds directly into the master trading agent’s final trade report. 📰 News Sources Used This agent collects real-time headlines from: Google News (filtered by “Tesla” or “TSLA”) Yahoo Finance (TSLA-specific feed) Electrek (Tesla archive) CleanTechnica (Tesla sustainability news) TeslaNorth (app/product release updates) These five tools are always queried together to ensure market-wide signal coverage. 🤖 What the Agent Does Pulls headlines from all 5 Tesla-specific RSS feeds Uses DeepSeek Chat to: Analyze narrative tone (bullish / bearish / neutral) Identify macro/financial drivers Generate a 2–3 sentence summary Return top 3–5 headlines Outputs structured JSON for downstream use 🛠️ Setup Instructions 1. Install & Name Import this file and name it: Tesla_News_and_Sentiment_Analyst_Tool 2. Add DeepSeek API Credentials Go to: Credentials → Add New → DeepSeek API Save as: DeepSeek account 3. Internet Access Required Ensure RSS feeds can fetch live headlines Works best with a cloud-hosted n8n instance or tunnel-enabled local install 4. Must Be Triggered by Parent Triggered via Execute Workflow by the Tesla Quant Trading AI Agent Requires these inputs: message: optional query context sessionId: passed to maintain short-term memory across executions 🧠 Agent Architecture | Node Name | Function | | ---------------------------------- | ------------------------------------------------ | | DeepSeek Chat Model | Performs AI-based sentiment analysis | | Tesla News and Sentiment Analyst | Combines results, formats output in strict JSON | | Simple Memory | Stores session-level context (short-term memory) | | 5x RSS nodes | Aggregate Tesla news from trusted media outlets | 📌 Sticky Notes Included 🟢 Trigger from Parent Workflow – Executed only by main TSLA agent 🟠 News Feeds Overview – Lists and explains each of the 5 feeds 🧠 DeepSeek Chat Notes – Describes LLM behavior and parsing role 🔵 Short-Term Memory – Buffers sentiment context during user session 📘 Sentiment Analyst Agent – Summarizes key responsibilities 📎 Licensing & Attribution © 2025 Treasurium Capital Limited Company This architecture, workflow structure, and prompt design are licensed for educational and operational use only. Commercial resale or rebranding prohibited without authorization. 🔗 Creator: Don Jayamaha 🔗 Templates: https://n8n.io/creators/don-the-gem-dealer/ 🚀 Power your TSLA trading with AI-driven sentiment—built with DeepSeek Chat and 5 trusted news sources. This tool is required by the Tesla Quant Trading AI Agent.
by Trey
This workflow will archive your Spotify Discover Weekly playlist to an archive playlist named "Discover Weekly Archive" which you must create yourself. If you want to change the name of the archive playlist, you can edit value2 in the "Find Archive Playlist" node. It is configured to run at 8am on Mondays, a conservative value in case you forgot to set your GENERIC_TIMEZONE environment variable (see the docs here). Special thanks to erin2722 for creating the Spotify node and harshil1712 for help with the workflow logic. To use this workflow, you'll need to: Create then select your credentials in each Spotify node Create the archive playlist yourself Optionally, you may choose to: Edit the archive playlist name in the "Find Archive Playlist" node Adjust the Cron node with an earlier time if you know GENERIC_TIMEZONE is set Setup an error workflow like this one to be notified if anything goes wrong
by Emmanuel Bernard
🎉 Do you want to master AI automation, so you can save time and build cool stuff? I’ve created a welcoming Skool community for non-technical yet resourceful learners. 👉🏻 Join the AI Atelier 👈🏻 Monitor Zalando product pricing and get notified if a Zalando product price falls under a limit you have defined. This n8n workflow lets you follow the evolution of the price of products you select. For each product, you define a minimal price. The workflow automatically scrapes the price for you on a daily basis. If the price falls under your minimal price settings, you receive a notification. This workflow is very easy to use. From a simple form, just paste the URL of the Zalando product you want to monitor and fill in the minimal price. Features Monitor Zalando Product price: follow the price evolution of your favorite Zalando products. Email notification: set a minimal price, if the product price falls below this limit, you get notified by email. Visual price evolution: get a graphical overview of the product pricing evolutions. Automated Daily check-up: this workflow automatically checks the price of your selected Zalando products on a daily basis. Set up Copy this workflow to your n8n interface. Create a new Google Spreadsheet, copy this template Setup your workflow with your Google credential, your email, and your copy of the Spreadsheet. Activate the Workflow and start pasting Zalando product URLs. I hope you will enjoy this workflow that is probably one of the simplest ways to monitor the pricing evolution of your favorite Zalando products. Feel free to contact me should you have any questions or suggestions. Created by the n8n.inja ✨ follow on X 📺 follow on YT
by Sherlockes
What does this template help with? Save the data of activities recorded and stored in Strava to a Google Sheets document. How it works: We have a Google Sheets spreadsheet where each row represents a Strava activity with the date, reference, distance, time, and elevation. Periodically, the workflow checks the latest activities in our Strava account to see if any are missing from the spreadsheet and adds them to the list. All fields must be properly formatted according to how they are stored in the Google Sheets spreadsheet. Set up instructions Complete the Set up credentials step when you first open the workflow. You'll need a Google Sheets and Strava account. In the 'activities' node, you must enter the name of the file and the sheet where you want to save the imported data. In the 'Strava' node, you must select the corresponding credential. You can adjust the format of dates, times, and distances according to your needs in the 'strava_last' node. The rest of the information is available at sherblog.es Template was created in n8n v1.72.1
by Yaron Been
✨ AI Client Onboarding Agent: Auto Welcome Email Generator Transform your client onboarding from manual follow-up into an intelligent automation system. This streamlined n8n workflow monitors Google Forms submissions, generates personalized welcome emails with onboarding checklists using AI, and delivers professional first impressions instantly to every new client. 🔄 How It Works This efficient 6-step automation ensures no new client is ever missed: Step 1: Continuous Form Monitoring The workflow monitors your Google Sheets (connected to Google Forms) every minute, instantly detecting new client submissions and triggering the onboarding process. Step 2: Intelligent Data Processing Client information is automatically extracted and formatted from form responses, including name, email, company details, service requirements, and special onboarding notes. Step 3: Dynamic Checklist Generation A comprehensive 6-step onboarding checklist is created, covering essential phases from account setup through first milestone review, ensuring consistent client experiences. Step 4: AI-Powered Email Creation Google Gemini generates personalized welcome emails featuring: Custom greetings using the client's actual name Service-specific onboarding instructions Professional checklist formatting Company-branded messaging and signatures Contextual guidance based on their specific needs Step 5: Instant Email Delivery Welcome emails are automatically sent to new clients within minutes of form submission, creating immediate engagement and professional first impressions. Step 6: Robust Error Handling Built-in error monitoring ensures workflow reliability, with automatic failure detection and recovery processes to prevent missed onboarding opportunities. ⚙️ Setup Steps Prerequisites Google Workspace account for Forms, Sheets, and Gmail Google Gemini API access for email generation n8n instance (cloud or self-hosted) Basic understanding of Google Forms and Sheets integration Required Google Forms Structure Create a client intake form with these essential fields: 📝 Required Form Fields: Client Name (Short answer text) Email Address (Email field with validation) Company Name (Short answer text) Services Needed (Paragraph text or multiple choice) Any Other Onboarding Info (Optional paragraph text) Form Settings: Enable "Collect email addresses" for verification Set responses to automatically populate Google Sheets Configure confirmation message for client experience Add form validation for required fields Configuration Steps 1. Credential Setup Google Sheets OAuth2**: Monitor form responses and access client data Google Gemini API Key**: Generate intelligent, personalized email content Gmail OAuth2**: Send automated welcome emails with professional formatting Google Forms Integration**: Ensure seamless data flow from forms to sheets 2. Google Sheets Configuration Verify your form responses sheet contains proper column headers: | Timestamp | Client name | email | Company Name | Services Needed | Any other onboarding info | 3. Onboarding Checklist Customization Default 6-step checklist includes: Account Setup**: User accounts, access credentials, initial configurations Welcome Call Scheduled**: Personal introduction and expectations setting Document Collection**: Contracts, requirements, project specifications Service Configuration**: Platform setup, integrations, custom settings Onboarding Session**: Training, walkthrough, initial guidance First Milestone Review**: Progress check, feedback collection, next steps 4. Email Template Personalization AI email generation can be customized for: Service-Specific Content**: Different messaging for different service types Company Branding**: Consistent voice, tone, and visual identity Client Segmentation**: Premium vs standard client experiences Industry Customization**: Specialized language for different business sectors 5. Workflow Activation and Testing Import workflow JSON into your n8n instance Configure all credential connections and verify permissions Test with sample form submissions to ensure accuracy Activate Google Sheets trigger for continuous monitoring 🚀 Use Cases Professional Service Providers Consultants**: Streamline client onboarding for multiple service offerings Agencies**: Maintain consistent welcome experiences across all new accounts Freelancers**: Create professional first impressions without manual effort Coaches**: Ensure every new client receives immediate, personalized guidance SaaS & Technology Companies Software Platforms**: Welcome new users with setup instructions and support App Developers**: Guide users through initial configuration and features Tech Consultants**: Provide immediate next steps for technical implementations Digital Services**: Establish clear expectations and timelines from day one Education & Training Organizations Online Course Creators**: Welcome students with course access and schedules Training Companies**: Provide immediate onboarding for corporate clients Educational Consultants**: Guide parents and students through program enrollment Certification Programs**: Establish clear pathways for certification completion Healthcare & Wellness Wellness Coaches**: Welcome new clients with program overviews and expectations Healthcare Practices**: Streamline patient onboarding with forms and procedures Therapy Practices**: Provide immediate guidance for new patient relationships Fitness Trainers**: Establish workout schedules and goal-setting sessions Financial Services Financial Advisors**: Welcome new clients with account setup and meeting scheduling Insurance Agents**: Guide clients through policy setup and documentation Accounting Firms**: Establish bookkeeping processes and document collection Investment Firms**: Provide immediate next steps for portfolio management 🔧 Advanced Customization Options Multi-Service Workflow Management Create specialized onboarding paths: Service Type Detection: Analyze form responses to determine service category Conditional Checklists: Generate different steps based on service requirements Tiered Onboarding: Premium clients receive enhanced welcome experiences Industry-Specific Templates: Customize messaging for different business sectors Enhanced Client Communication Expand beyond basic welcome emails: Multi-Step Email Sequences**: Follow-up emails for incomplete onboarding steps Calendar Integration**: Automatic welcome call scheduling with calendar links Document Sharing**: Automated access to onboarding portals and resources Progress Tracking**: Client-facing dashboards showing onboarding completion Team Collaboration Features Keep your team informed and engaged: Slack Notifications**: Alert team members about new client onboarding Task Assignment**: Automatically create tasks in project management tools CRM Integration**: Push new client data to Salesforce, HubSpot, or Pipedrive Calendar Scheduling**: Book welcome calls across team member calendars Quality Assurance & Analytics Monitor and improve onboarding effectiveness: Email Delivery Tracking**: Monitor open rates and engagement metrics Onboarding Completion Rates**: Track which clients complete all steps Response Time Analysis**: Measure speed from form submission to email delivery Client Feedback Integration**: Collect and analyze onboarding experience ratings 📊 Generated Email Examples Standard Service Welcome: Hi Sarah Johnson, Welcome to our service! We're excited to work with Digital Marketing Solutions on your upcoming project. Based on your submission, here's your personalized onboarding checklist: ✅ ONBOARDING CHECKLIST Account Setup - We'll create your project dashboard and send login credentials Welcome Call Scheduled - Let's discuss your goals and timeline in detail Document Collection - We'll gather all necessary project requirements and assets Service Configuration - Our team will customize our approach for your specific needs Onboarding Session - We'll walk you through our process and answer any questions First Milestone Review - We'll schedule a check-in to ensure everything is progressing smoothly Your project details: • Services Needed: SEO optimization and content strategy • Special Requirements: Focus on local search rankings What's next? Our team will reach out within 24 hours to schedule your welcome call and begin the account setup process. Best regards, Your Digital Marketing Solutions Team Premium Client Welcome: Hi Michael Chen, Welcome to our premium service tier! We're thrilled to partner with Tech Innovations Inc. on this exciting project. Your VIP onboarding experience includes: 🌟 PREMIUM ONBOARDING CHECKLIST Priority Account Setup - Dedicated account manager assignment within 2 hours Executive Welcome Call - Direct access to our senior team for strategic discussion Expedited Document Collection - Streamlined process with dedicated support Custom Service Configuration - Tailored solutions designed specifically for your needs Comprehensive Onboarding Session - Extended session with our technical experts Weekly Milestone Reviews - Regular check-ins to ensure optimal progress Your premium benefits: • Dedicated account manager: Will be assigned today • Priority support: 4-hour response time guarantee • Custom reporting: Weekly progress dashboards Next steps: Your dedicated account manager will contact you within 2 hours to schedule your executive welcome call. Best regards, Your Tech Innovations Inc. Premium Team 🛠️ Troubleshooting & Best Practices Common Issues & Solutions Google Forms Integration Field Mapping**: Ensure form field names exactly match workflow expectations Response Timing**: Verify Google Sheets updates immediately after form submission Permission Issues**: Confirm n8n has proper access to Google Workspace services Data Validation**: Implement form validation to prevent incomplete submissions Email Delivery Challenges Gmail Limits**: Monitor daily sending limits and implement appropriate delays Spam Prevention**: Use professional email templates and avoid promotional language Email Formatting**: Ensure AI-generated content maintains professional appearance Delivery Confirmation**: Implement tracking for email delivery and open rates AI Content Quality Prompt Refinement**: Continuously improve AI prompts based on output quality Brand Consistency**: Ensure generated emails match your company voice and tone Template Variations**: Create multiple templates for different service types Quality Review**: Implement periodic manual review of AI-generated content Optimization Strategies Response Time Enhancement Trigger Frequency**: Balance monitoring frequency with system resources Processing Efficiency**: Optimize data transformation steps for faster execution Error Recovery**: Implement retry logic for failed email deliveries Queue Management**: Handle high-volume periods with intelligent batching Client Experience Improvement Personalization Depth**: Use all available form data for maximum personalization Follow-up Automation**: Create additional workflows for onboarding step completion Feedback Collection**: Gather client feedback on onboarding experience quality Continuous Improvement**: Regular review and refinement of onboarding processes Business Process Integration CRM Synchronization**: Ensure new client data flows to all relevant systems Team Workflows**: Integrate onboarding triggers with internal task management Resource Allocation**: Automatically assign team members based on service types Progress Tracking**: Implement systems to monitor onboarding completion rates 📈 Success Metrics Efficiency Improvements Response Time**: Reduce new client response time from hours to minutes Consistency**: Achieve 100% consistent welcome experience for all new clients Team Productivity**: Eliminate manual onboarding email creation entirely Error Reduction**: Prevent missed follow-ups and incomplete onboarding processes Client Experience Measurements First Impression Quality**: Measure client satisfaction with initial welcome experience Onboarding Completion**: Track percentage of clients completing all onboarding steps Engagement Rates**: Monitor email open rates and response rates to welcome messages Time to Value**: Measure how quickly new clients achieve first project milestones 📞 Questions & Support Need assistance with your AI Client Onboarding Agent setup or optimization? 📧 Expert Implementation Support Email**: Yaron@nofluff.online Response Time**: Within 24 hours on business days Specialization**: Client onboarding automation, AI email generation, Google Workspace integration 🎥 Comprehensive Learning Resources YouTube Channel**: https://www.youtube.com/@YaronBeen/videos Complete setup and configuration tutorials for Google Forms and Sheets Advanced AI prompt engineering for personalized client communications Integration guides for popular CRM and project management platforms Best practices for professional service provider automation Troubleshooting common Google Workspace and Gmail integration issues 🤝 Professional Community & Networking LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing client onboarding automation support and consulting Share your client acquisition and onboarding success stories Access exclusive workflow templates for different service industries Join discussions about client experience automation and business growth 💬 Support Request Best Practices Include in your support message: Your service type and typical client onboarding process Current client volume and expected growth projections Specific customization requirements for your industry Integration needs with existing CRM or project management tools Any technical errors or workflow execution issues Ready to create unforgettable first impressions for every new client? Deploy this AI Client Onboarding Agent and transform your client acquisition process into a seamless, professional experience that starts strong relationships from day one!
by Corentin Ribeyre
This template can be used to scan a domain/company with Icypeas. Be sure to have an active account to use this template. How it works This workflow can be divided into three steps : The workflow initiates with a manual trigger (On clicking 'execute'). It connects to your Icypeas account. It performs an HTTP request to scan a domain/company name. Set up steps You will need a working icypeas account to run the workflow and get your API Key, API Secret and User ID. You will need a domain/company name to perform the search.
by Simon
📦 Zip Multiple Files Dynamically This template enables you to dynamically bundle multiple files into a ZIP archive. Designed to be used as a Subworkflow, it’s modular, flexible, and easy to integrate into various workflows. The output is a single ZIP file with a name that includes the current date, time, and fileName. Shoutout: Code from: Tom (mutedjam) 👤 Who is this for? This workflow is perfect for: 🚀 Businesses automating file archiving tasks. 💻 Developers managing files programmatically. 📂 Anyone needing a reusable solution for bundling files into ZIP archives. ❓ What problem is this workflow solving? Manually zipping multiple files is: 🕒 Time-consuming. 🤔 Prone to errors. This workflow automates the process and, as a Subworkflow, ensures: ⚡ Consistent file archiving across different workflows. 🛠️ Reduced manual effort. 📈 Streamlined integration into existing automation. 🔧 What this workflow does 🗂️ Dynamically collects binary files from the input. 📦 Bundles them into a single ZIP archive. 🕒 Names the ZIP file with the current date, time, and a customizable fileName. ✅ Outputs the ZIP file, ready for storage or further processing. ⚙️ Setup 🔗 Add this Subworkflow to your existing workflows. 📥 Pass the binary files as input to the Subworkflow. ▶️ Call the Subworkflow to generate a ZIP file. 🛠️ How to customize this workflow to your needs 🌐 File Sources**: Adjust the input nodes in your parent workflow to connect to your preferred file sources. 📝 File Naming**: Customize the logic for the output fileName in the Subworkflow. 🚀 Additional Use Cases**: Use this Subworkflow in various scenarios, such as: ✉️ Sending ZIP files via email. ☁️ Uploading ZIP files to cloud storage. 🔄 Triggering further automation. 🎉 Why use this as a Subworkflow? Instead of building a fixed ZIP functionality for every workflow, this template offers a reusable solution that can be integrated into many different workflows effortlessly. Save time and ensure consistency across your automation projects! 💡
by Zacharia Kimotho
Generate new keywords for SEO with the monthly Search volumes This workflow is an improvement on the workflows below. It can be used to generate new keywords that you can use for your SEO campaigns or Google ads campaigns Generate SEO Keyword Search Volume Data using Google API and Generating Keywords using Google Autosuggest Usage Send the keywords you need as an array to this workflow Pin the data and map it to the set Keywords node Map the keywords to the Google ads API with the location and Language of your choice Split the results and set them data Pass this to the next nodes as needed for storage Make a copy of this spreedsheet and update the data accordingly Having challenges with the google Ads API? Read this blog Setup Replace the trigger with your desired trigger eg a webhook or manual trigger Map the data correctly to the set Keywords node On the Generate new keywords, Update the {customer_id} on the url and login-customer-id with your actual one. Update the developer-token` also with your values. The url should be corrected as below https://googleads.googleapis.com/v18/customers/{customer-id}:generateKeywordIdeas You should send the headers as below { "name": "content-type", "value": "application/json" }, { "name": "developer-token", "value": "5j-tyzivCNmiCcoW-xkaxw" }, { "name": "login-customer-id", "value": "513554 " } and the json body should take the following format { "geoTargetConstants": ["geoTargetConstants/2840"], "includeAdultKeywords": false, "pageToken": "", "pageSize": 2, "keywordPlanNetwork": "GOOGLE_SEARCH", "language": "languageConstants/1000", "keywordSeed": { "keywords": {{ $json.Keyword }} } } Troubleshooting If you get an error with the workflow, check the credentials you are using Check the account you are using eg the right customer id and developer token Follow the guide on the blog to set up your Google ads account Made by @Imperol
by Agent Studio
Overview This n8n workflow retrieves AI agent chat memory logs stored in Postgres and pushes them to Google Sheets, creating one sheet per session. It’s useful for teams building chat-based products or agents and needing to review or analyze session logs in a collaborative format. Who is it for Anyone with an AI Agent in Production storing the conversation logs in Postgres (or Supabase) who wants to see transcript and have control Product teams building AI agents or assistants. Teams that want to centralize conversation history for analysis or support. Anyone managing AI chat memory and needing to explore it in a spreadsheet. Prerequisites A Postgres database with a n8n_chat_histories table with an AI Agent connected to it. If you need an example, you can follow this tutorial Once done, you need to run the Postgresql query to add the created_at column (see Setup > Add a datetime column) Google Sheets access and OAuth credentials connected to n8n. A Google Sheets document set up as a template (see below). Google Sheets Template This workflow expects a Google Sheets file where each session will be stored in its own tab. A basic tab layout is duplicated and renamed with the session ID. 👉 Use this template as a starting point Note: You can hide the template after the first tabs have been created How it works Trigger The workflow can be launched manually or on a schedule (e.g. daily at noon). Retrieve sessions Runs a SQL query to get distinct session_id values from the n8n_chat_histories table. Loop over sessions For each session: Clears the corresponding sheet (if it exists). Duplicates the template tab. Renames it with the current session_id. Fetch messages Selects all messages linked to the session from Postgres. Append to sheet Adds each message to the Google Sheet with columns: Who: speaker role (user, assistant, etc.) Message: text content Date: timestamp from created_at, formatted yyyy-MM-dd hh:mm:ss Notes The sheet is cleared and rebuilt each run to ensure logs are up-to-date. If a sheet for a session doesn’t exist, it will be created by duplicating the first tab (template) You can group sessions under a persistent ID (like user_id) by overriding session_id in your memory config. Works perfectly with Supabase by using PG credentials from the connection pooler. 👉 If you're looking for a solution to better visualize and analyse conversations, reach out to us!
by Jan Willem Altink
Supabase Storage File Upload Workflow works with selfhosted Supabase ℹ️ How it works • Accepts file data (MIME type, filename, base64 content) from other workflows • Automatically routes files to appropriate storage buckets based on file type (images, audio, video, documents) • Uploads files to Supabase Storage using the REST API • Generates secure signed URLs for file access with 30-day expiration • Returns structured success/error responses for downstream processing 🏗️ Set up steps • Configure Supabase API credentials in n8n • Create storage buckets in your Supabase project (image-files, audio-files, video-files, document-files) (or choose your own structuring system) • Replace url paths with your own • Test the workflow using the included form trigger • Remove test form and integrate with your main workflows 📚 Reference: Supabase Storage Documentation
by Daniel Ng
Advanced n8n Error Handling: Automated Email Alerts & Global Error Workflow Configuration In any automated environment, n8n workflows, while powerful, can sometimes encounter unexpected issues or fail during execution. Without a dedicated error handling strategy, these failures might go unnoticed, leading to incomplete processes, data inconsistencies, or critical operational disruptions. Manually monitoring every workflow execution or sifting through logs for error details is inefficient and can significantly delay crucial fixes. This is where a centralized, automated error management system becomes essential to maintain reliability and quickly address any problems. The "Advanced n8n Error Handling: Automated Email Alerts & Global Error Workflow Configuration" template provides a robust solution to proactively manage and respond to errors within your n8n instance. For more powerful n8n templates, visit our website or contact us at AI Automation Pro. We help your business build custom AI workflow automation and apps. Highlight features Automated Email Notifications:** Sends detailed HTML emails via Gmail for both execution and trigger failures, ensuring you're promptly informed. Centralized Error Management:** Acts as a single, dedicated workflow to catch and process errors from multiple other n8n workflows. Proactive Global Error Handler Configuration:** A scheduled task automatically scans and updates other active n8n workflows to use this workflow as their default error handler, ensuring consistent error management. Comprehensive Error Reporting:** Notification emails are rich with information, including error messages, stack traces, the last executed node, direct links to failed executions, and detailed trigger failure context. Dynamic Email Content:** The subject line and body of the notification email are dynamically adjusted based on whether the failure was an execution error or a trigger failure. Highly Customizable:** Offers flexibility to modify email content (HTML), change the notification channel (e.g., Slack, other email providers), and adjust the logic for updating other workflows' error handlers. Scheduled Operation:** The global configuration part runs on a user-definable schedule (e.g., daily, hourly) for proactive and automated error handling setup across your n8n instance. Who is this for? This workflow is designed for n8n users and administrators who want to: Establish a resilient and centralized error handling mechanism across their n8n instance. Receive immediate and detailed email notifications for any workflow failures. Automate the process of assigning a default error handling workflow to all their active n8n workflows. Save time on manually configuring error handlers for each individual workflow and ensure comprehensive error coverage. What problem is this workflow solving? / use case In an n8n environment with multiple workflows, errors can occur without immediate visibility. This can lead to: Unnoticed failures, potentially causing data loss or incomplete automated processes. Time-consuming diagnosis of issues due to a lack of readily available, detailed error information. Inefficiency and oversight from manually setting an error workflow for every new or existing workflow. This template tackles these issues by providing a proactive error management system. It not only alerts you to failures with comprehensive details but also ensures that your other workflows are automatically configured to use this centralized handler. What this workflow does This workflow operates in two distinct yet complementary parts: 1\. Scheduled Global Error Handler Configuration: Trigger:** Initiates based on a configurable schedule (e.g., daily, hourly). Identify Self:** Retrieves its own workflow ID to use as the designated error handler. Scan Workflows:** Fetches a list of all other workflows within your n8n instance. Conditional Update Logic:** For each active workflow found, it checks if: An error workflow (errorWorkflow setting) is not currently set, OR The currently set errorWorkflow is different from this central error handling workflow. The workflow is active. Apply Default Handler:** If the above conditions are met, it automatically updates the target workflow's settings. This sets the current workflow as its default error handler, ensuring that any future errors in those workflows are routed here. The callerPolicy setting is also removed during this update. 2\. Error Notification via Email: Trigger:** Activates whenever an error occurs in any n8n workflow that has this workflow designated as its errorWorkflow. Gather Error Context:** Collects vital information about the failure, such as: The base URL of your n8n instance. Specific details of the workflow that failed (name, ID). The nature of the error: whether it's an "execution error" (occurring mid-workflow) or a "trigger failure" (occurring at the start). Format Detailed Error Message:** Constructs a comprehensive HTML email tailored to the error type: For Execution Errors: The email includes a direct link to the failed execution's page, the timestamp of the error, the name of the last node that successfully executed, the error message, and the full error stack trace. For Trigger Failures: The email includes the timestamp, operational mode, error message, error name and description, relevant context data, details about the cause (message, name, code, status), and the stack trace. Send Email Notification:** Dispatches the formatted HTML email using Gmail to a predefined recipient. The email subject line dynamically indicates the name of the failing workflow and the type of error, providing a quick overview. Setup Import Workflow: Import the JSON file into your n8n instance. Configure Credentials: n8n API Access: Locate the nodes: "N8n Get Error Handler", "N8n Get All Workflows", and "N8n Update Workflow". For each, select or create new n8n API credentials. These credentials must have permissions to read all workflows (workflows.read) and update workflows (workflows.update). Gmail Access: Locate the "Gmail Send Notification" node. Select or create new Gmail OAuth2 credentials to authorize n8n to send emails on your behalf. Set Email Recipient and Sender Details: Navigate to the "Settings" node, which is connected directly after the "Error Trigger" node. Modify the value for the Email Receiver variable to the email address where error notifications should be sent. Optionally, update the Email Sender Name variable. Configure Schedule (Optional): Select the "Schedule Trigger" node. Adjust the "Trigger Interval" (e.g., Every Day, Every Hour) according to how frequently you want the workflow to scan and update the error handler settings for other workflows in your n8n instance. Activate Workflow: Ensure this workflow is toggled to "Active". Once active, its scheduled component will begin operating, and it will be ready to process and notify on errors from other linked workflows. Manual Configuration (Optional): While this workflow automates the assignment, you can also manually set this workflow as the errorWorkflow in the settings of any critical existing workflows for immediate protection. How to customize this workflow to your needs Email Content & Formatting:** Modify the HTML content within the "HTML For Execution Error" and "HTML For Trigger Error" nodes to alter the appearance, structure, or information included in the notification emails. Alternative Notification Channels:** Replace the "Gmail Send Notification" node with a different email service node (e.g., Microsoft Outlook, SendGrid) or integrate other notification platforms like Slack, Microsoft Teams, or Discord. Remember to adjust the input data mappings for the new node. Refine Global Update Logic:** Adjust the conditions within the "If No Default Error Handler Set" node if you need more granular control over which workflows are automatically updated (e.g., filter by workflow tags, names, or explicitly exclude certain workflows). Enrich Error Data:** Insert additional nodes after the "Error Trigger" but before the "Settings" node if you need to fetch more context about the error or the workflow that failed (e.g., look up related information from a database or API). Advanced Notification Routing:** Implement more complex logic prior to sending notifications. For example, you could use a Switch node to route error alerts to different email addresses or channels based on the name of the failing workflow or the severity of the error. Handling of callerPolicy:** The "Set Data" node is configured to remove the callerPolicy setting from workflows it updates. If your workflows rely on this setting, you may need to modify or remove this part of the "Set Data" node's code. Adjust Scheduled Task:** Change the frequency or timing of the "Schedule Trigger" to better suit your operational needs for the global error handler update.
by ist00dent
This n8n template allows you to perform real-time currency conversions by simply sending a webhook request. By integrating with the ExchangeRate.host API, you can get up-to-date exchange rates for over 170 world currencies, making it an incredibly useful tool for financial tracking, e-commerce, international business, and personal budgeting. 🔧 How it works Receive Conversion Request Webhook: This node acts as the entry point for the workflow, listening for incoming POST requests. It's configured to expect a JSON body containing: from: The 3-letter ISO 4217 currency code for the source currency (e.g., USD, PHP). to: The 3-letter ISO 4217 currency code for the target currency (e.g., EUR, JPY). amount: The numeric value you want to convert. Important: The ExchangeRate.host API access_key is handled securely by n8n's credential system and should not be included in the webhook body or headers. Convert Currency: This node makes an HTTP GET request to the ExchangeRate.host API (api.exchangerate.host). It dynamically constructs the URL using the from, to, and amount from the webhook body. Your API access key is securely retrieved from n8n's pre-configured credentials (HTTP Query Auth type) and automatically added as a query parameter (access_key). The API then performs the conversion and returns a JSON object with the conversion details. Respond with Converted Amount: This node sends the full currency conversion result received from ExchangeRate.host back to the service that initiated the webhook. 👤 Who is it for? This workflow is ideal for: E-commerce Platforms: Display prices in local currencies on the fly for international customers. Convert incoming international payments to your local currency for accounting. Calculate shipping costs in different currencies. Financial Tracking & Budgeting Apps: Update personal or business budgets with converted values. Track expenses incurred in foreign currencies. Automate portfolio value conversion for multi-currency investments. International Business & Freelancers: Generate invoices in a client's local currency based on your preferred currency. Quickly estimate project costs or earnings in different currencies. Automate reconciliation of international transactions. Travel Planning: Convert travel expenses from one currency to another while abroad. Build simple tools to estimate costs for trips in different countries. Data Analysis & Reporting: Standardize financial data from various sources into a single currency for unified reporting. Build dashboards that display converted financial metrics. Custom Integrations: Connect to CRMs, accounting software, or internal tools to automate currency-related tasks. Build chatbots that can answer currency conversion queries. 📑 Data Structure When you trigger the webhook, send a POST request with a JSON body structured as follows: { "from": "USD", "to": "PHP", "amount": 100 } The workflow will return a JSON response similar to this (results will vary based on currencies and amount): { "date": "2025-06-03", "historical": false, "info": { "rate": 58.749501, "timestamp": 1717398188 }, "query": { "amount": 100, "from": "USD", "to": "PHP" }, "result": 5874.9501, "success": true } ⚙️ Setup Instructions Get an ExchangeRate.host Access Key: Go to https://exchangerate.host/ and sign up for a free API key. Create an n8n Credential for ExchangeRate.host: In your n8n instance, go to Credentials. Click "New Credential" and search for "HTTP Query Auth". Set the Name (e.g., ExchangeRate.host API Key). Set API Key to your ExchangeRate.host access key. Set Parameter Name to access_key. Set Parameter Position to Query. Save the credential. Import Workflow: In your n8n editor, click "Import from JSON" and paste the provided workflow JSON. Configure ExchangeRate.host API Node: Double-click the Convert Currency node. Under "Authentication", select "Generic Credential Type". Choose "HTTP Query Auth" as the Generic Auth Type. Select the credential you created (e.g., "ExchangeRate.host API Key") from the dropdown. Configure Webhook Path: Double-click the Receive Conversion Request Webhook node. In the 'Path' field, set a unique and descriptive path (e.g., /convert-currency). Activate Workflow: Save and activate the workflow. 📝 Tips This workflow is a powerful starting point. Here's how you can make it even more robust and integrated: Robust Error Handling: Add an IF node after Convert Currency to check {{ $json.success }}. If false, branch to an Error Trigger node or send an alert (e.g., Slack, Email) with {{ $json.error.info }} to notify you of API issues or invalid inputs. Include a Try/Catch block to gracefully handle network issues or malformed responses. Input Validation & Defaults: Add a Function node after the webhook to validate if from, to, and amount are present and in the correct format. If not, return a clear error message to the user. Set default from or to currencies if they are not provided in the webhook, making the API more flexible. Logging & Auditing: After a successful conversion, use a Google Sheets, Airtable, or database node (e.g., PostgreSQL, MongoDB) to log every conversion request, including the input currencies, amount, converted result, date, and possibly the calling IP (from the webhook headers). This is crucial for financial auditing and analysis. Rate Limits & Caching: If you anticipate many requests, be mindful of ExchangeRate.host's API rate limits. You can introduce a Cache node to store recent conversion results for a short period, reducing redundant API calls for common conversions. Alternatively, add a Delay node to space out requests if you're hitting limits. Format & Rounding: Use a Function node or Set node to format the result to a specific number of decimal places (e.g., {{ $json.result.toFixed(2) }}). Add currency symbols or full currency names to the output for better readability. Alerting on Significant Changes: Chain this workflow with a Cron or Schedule node to periodically fetch exchange rates for a pair you care about (e.g., USD to EUR). Use an IF node to compare the current rate with a previously stored rate. If the change exceeds a certain percentage, send an alert via Slack, Email, or Telegram to notify you of significant market shifts. Integration with Payment Gateways: For e-commerce, combine this with nodes for payment gateways (e.g., Stripe, PayPal) to automatically convert customer payments received in foreign currencies to your base currency before recording. Multi-currency Pricing for Products: Use this workflow in conjunction with your product database. When a user selects a different country/currency, trigger this webhook to dynamically convert product prices and display them instantly.