Workflow Templates

This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.

Description: Transform your Jira project management workflow with this intelligent n8n automation template that continuously tracks, scores, and reports the health of Jira Epics. The automation runs every 6 hours, fetches all active Epics, analyzes linked issues for performance, quality, and stability metrics, and automatically flags at-risk Epics. It updates Jira fields, sends alerts to Slack, logs trends in Google Sheets, and syncs visibility with Monday.com—ensuring teams stay proactive, not reactive. Ideal for agile teams, project managers, and product owners looking to monitor delivery health, detect risks early, and maintain transparent reporting across tools. ✅ What This Template Does (Step-by-Step) ⏱ Trigger Every 6 Hours: Automatically executes every six hours to keep health data updated in near real-time. 📥 Fetch All Epics from Jira: Retrieves all Epics, their keys, and fields via the Jira API to establish a full analysis scope. 🔀 Split Epics for Processing: Converts the batch of Epics into individual items, enabling sequential metric analysis. 🔗 Fetch Linked Issues: Collects all issues linked to each Epic, capturing their types, statuses, cycle times, and labels for deeper health analysis. 📈 Calculate Health Score: Computes a weighted score (0–1 scale) based on: • 40% Average Cycle Time • 30% Bug Ratio • 20% Churn (Reopened issues) • 10% Blocker Ratio Scores above 0.6 indicate at-risk Epics. ⚖️ Decision Gate: At-Risk or Healthy: If the health score exceeds 0.6, the workflow automatically initiates corrective actions. 🔧 Update Jira Epic: Updates Jira with the computed health score and adds an “At Risk” label for visibility in dashboards and filters. 🚨 Send Slack Alerts: Notifies the #project-alerts channel with Epic details, health score, and direct Jira links for immediate attention. 📋 Update Monday.com Pulse: Syncs health metrics and risk status back to your Monday board, maintaining cross-platform transparency. 📊 Log to Google Sheets: Appends health score logs with timestamps and Epic keys for trend analysis, audits, and dashboard creation. 🧠 Key Features ✔️ Automated Jira Epic health scoring (cycle time, churn, bugs, blockers) ✔️ Real-time risk flagging with Slack alerts ✔️ Integrated cross-tool visibility (Jira + Monday + Sheets) ✔️ Continuous trend tracking for performance improvement ✔️ Secure API-based automation 💼 Use Cases 💡 Track project delivery health and spot risks early 📈 Build executive dashboards showing team velocity and quality 🤝 Align product and engineering with shared visibility 🧾 Maintain a compliance audit trail of Epic health trends 📦 Required Integrations • Jira Software Cloud API – for Epic and issue data • Slack API – for real-time team alerts • Monday.com API – for visual board updates • Google Sheets API – for historical tracking and analytics 🎯 Why Use This Template? ✅ Prevents project delays by flagging risks early ✅ Provides automated, data-driven Epic health insights ✅ Connects your reporting ecosystem across platforms ✅ Perfect for Agile and DevOps teams driving continuous improvement

CDO Agent with Data Analytics Team Description Complete AI-powered data analytics department with a Chief Data Officer (CDO) agent orchestrating specialized data team members for comprehensive data science, business intelligence, and analytics operations. Overview This n8n workflow creates a comprehensive data analytics department using AI agents. The CDO agent analyzes data requests and delegates tasks to specialized agents for data science, business intelligence, data engineering, machine learning, data visualization, and data governance. Features Strategic CDO agent using OpenAI O3 for complex data strategy and decision-making Six specialized data analytics agents powered by GPT-4.1-mini for efficient execution Complete data analytics lifecycle coverage from collection to insights Automated data pipeline management and ETL processes Advanced machine learning model development and deployment Interactive data visualization and business intelligence reporting Comprehensive data governance and compliance frameworks Team Structure CDO Agent**: Data strategy leadership and team delegation (O3 model) Data Scientist Agent**: Statistical analysis, predictive modeling, machine learning algorithms Business Intelligence Analyst Agent**: Business metrics, KPI tracking, performance dashboards Data Engineer Agent**: Data pipelines, ETL processes, data warehousing, infrastructure Machine Learning Engineer Agent**: ML model deployment, MLOps, model monitoring Data Visualization Specialist Agent**: Interactive dashboards, data storytelling, visual analytics Data Governance Specialist Agent**: Data quality, compliance, privacy, governance policies How to Use Import the workflow into your n8n instance Configure OpenAI API credentials for all chat models Deploy the webhook for chat interactions Send data analytics requests via chat (e.g., "Analyze customer churn patterns and create predictive models") The CDO will analyze and delegate to appropriate specialists Receive comprehensive data insights and deliverables Use Cases Predictive Analytics**: Customer behavior analysis, sales forecasting, risk assessment Business Intelligence**: KPI tracking, performance analysis, strategic business insights Data Engineering**: Pipeline automation, data warehousing, real-time data processing Machine Learning**: Model development, deployment, monitoring, and optimization Data Visualization**: Interactive dashboards, executive reporting, data storytelling Data Governance**: Quality assurance, compliance frameworks, data privacy protection Requirements n8n instance with LangChain nodes OpenAI API access (O3 for CDO, GPT-4.1-mini for specialists) Webhook capability for chat interactions Optional: Integration with data platforms and analytics tools Cost Optimization O3 model used only for strategic CDO decisions and complex data strategy GPT-4.1-mini provides 90% cost reduction for specialist data tasks Parallel processing enables simultaneous agent execution Template libraries reduce redundant analytics development work Integration Options Connect to data platforms (Snowflake, BigQuery, Redshift, Databricks) Integrate with BI tools (Tableau, Power BI, Looker, Grafana) Link to ML platforms (AWS SageMaker, Azure ML, Google AI Platform) Export to business applications and reporting systems Disclaimer: This workflow is provided as a building block for your automation needs. Please review and customize the agents, prompts, and connections according to your specific data analytics requirements and organizational structure. Contact & Resources Website**: nofluff.online YouTube**: @YaronBeen LinkedIn**: Yaron Been Tags #DataAnalytics #DataScience #BusinessIntelligence #MachineLearning #DataEngineering #DataVisualization #DataGovernance #PredictiveAnalytics #BigData #DataDriven #DataStrategy #AnalyticsAutomation #DataPipelines #MLOps #DataQuality #BusinessMetrics #KPITracking #DataInsights #AdvancedAnalytics #n8n #OpenAI #MultiAgentSystem #DataTeam #AnalyticsWorkflow #DataOperations

Who's it for This template is for teams that want to stay updated on industry trends, tech news, or competitor mentions without manually browsing news sites. It's ideal for marketing, development, and research teams who use Slack as their central hub for automated, timely information. What it does / How it works This workflow runs on a daily schedule (default 9 AM), fetches the top articles from Hacker News for a specific keyword you define (e.g., 'AI'), and uses an AI agent with OpenRouter to generate a concise, 3-bullet point summary in Japanese for each article. The final formatted summary, including the article title, is then posted to a designated Slack channel. The entire process is guided by descriptive sticky notes on the canvas, explaining each configuration step. How to set up In the Configure Your Settings node, change the default keyword AI to your topic of interest and update the slack_channel to your target channel name. Click the OpenRouter Chat Model node and select your OpenRouter API key from the Credentials dropdown. If you haven't connected it yet, you will need to create a new credential. Click the Send Summary to Slack node and connect your Slack account using OAuth2 credentials. (Optional) Adjust the schedule in the Trigger Daily at 9 AM node to change how often the workflow runs. Activate the workflow. Requirements An n8n instance (Cloud or self-hosted). A Slack account and workspace. An OpenRouter API key stored in your n8n credentials. If self-hosting, ensure the LangChain nodes are enabled. How to customize the workflow Change the News Source:* Replace the *Hacker News* node with an *RSS Feed Read** node or another news integration to pull articles from different sources. Modify the AI Prompt:* In the *Summarize Article with AI** node, you can edit the system message to change the summary language, length, or tone. Use a Different AI Model:* Swap the *OpenRouter* node for an *OpenAI, **Anthropic, or any other supported chat model. Track Multiple Keywords:* Modify the workflow to loop through a list of keywords in the *Configure Your Settings** node to monitor several topics at once.

This n8n template gives you a chat-style assistant that can search your HubSpot CRM on demand. Ask natural-language questions like “show me leads in Germany” or “what deals close next month,” and the agent translates your request into precise HubSpot searches—then answers in plain English. Great for founders, AEs, and ops folks who want quick answers without clicking through the CRM. How it works Chat trigger** starts a session from your n8n chat UI or embed. AI Agent (Gemini 2.5 Pro)** interprets the message and: Chooses the right HubSpot search (contacts or deals). Fills filter property, operator (EQ, NEQ, GT, GTE, LT, LTE, BETWEEN, IN, NOT\_IN), and value(s). Requests specific properties (email, name, lifecycle stage, owner, activity timestamps, etc.). HubSpot tools** execute live queries: Contacts: flexible property filter + free-text query. Deals: filters by owner and core deal fields (stage, amount, pipeline, close date). Memory buffer** keeps the last turns so you can say “now only show closed won over 10k” and the agent understands context. How to use Connect credentials HubSpot OAuth on both HubSpot Tool nodes. Google Gemini API key on the Gemini Chat Model. Open the chat (the “When chat message received” node). Ask questions like: “Find contacts named Hans created after Sept 1.” “Deals owned by me in Proposal with amount > 10,000.” “Contacts with lead status = New and no email reply in the last 14 days.” Refine with follow-ups: “Sort by most recently contacted.” “Only Germany.” “Show top 5 with emails.” Requirements HubSpot** (OAuth2) Google Gemini** (API key) Notes & customization Property/operator control:** The contact search node lets the agent set both the property (e.g., email, lifecyclestage, hs_lead_status) and the operator (EQ, IN, BETWEEN in epoch ms for dates, etc.). Owner filtering for deals:** Uses hs_all_owner_ids; swap or extend to filter by pipeline/stage ranges. Guardrails:** Add allowlists for searchable properties or cap result counts to avoid noisy answers. Display format:** Have the agent return concise tables (name, email, stage, last activity, CTA). Handoffs:** Add Slack/Email actions—e.g., “post this list to #sales” or “export to CSV.” Telemetry:** Log queries for later dashboards (common searches, coverage gaps). Troubleshooting No results?** Loosen operators (use IN lists, broaden dates) or include a free-text query. Date filters:** Provide epoch ms for GT/GTE/LT/LTE/BETWEEN on time fields (the agent handles this; keep system time in UTC). Too chatty?** Reduce memory window or ask the agent to summarize to bullet points.

This automated n8n workflow streamlines invoice creation and payment reminders. It generates invoices on a monthly schedule and sends reminders for overdue payments, updating records in Google Sheets. Good to Know Supports monthly invoice generation and daily overdue checks Integrates with Google Sheets for data management Uses email notifications for invoice delivery and reminders Includes logging for tracking and auditing Features multiple reminder types based on overdue duration How It Works Invoice Creation Flow: Monthly Invoice Trigger** - Initiates workflow on a set monthly schedule Get Clients for Invoicing** - Reads client data from Google Sheet Filter Active Clients** - Filters out inactive clients Generate Invoice Data** - Creates invoice details in required format Save Invoice to Google Sheets** - Appends or updates invoice record in the sheet Send Invoice Email** - Sends the invoice to the client via email Log Invoice Creation** - Logs invoice creation for records/auditing Reminder Flow: Daily Payment Reminder Check** - Triggers workflow daily to check overdue invoices Get Overdue Invoices** - Reads overdue invoices from Google Sheet Filter Overdue Invoices** - Filters invoices still unpaid Calculate Reminder Type** - Calculates how many days overdue Switch Reminder Type** - Decides which type of reminder to send Send Gentle / Follow-up / Urgent / Final Notice** - Sends respective reminder email Update Reminder Log** - Updates reminder status in the sheet How to Use Import workflow into n8n Configure Google Sheets API for data access Set up email service for notifications Define monthly schedule for invoice trigger Test with sample client data and monitor reminders Adjust reminder thresholds as needed Requirements Access to Google Sheets API Email service configuration Scheduled trigger setup in n8n Sheet Columns: Client Name** Invoice ID** Amount** Due Date** Status** Reminder Type** Last Updated** Customizing This Workflow Modify invoice generation schedule Adjust reminder email templates Configure custom Google Sheet columns Set custom overdue thresholds Integrate additional notification methods

🔗 Automated Semrush Backlink Checker with n8n and Google Sheets 📘 Description This n8n workflow automates backlink data extraction using the Semrush Backlink Checker API available on RapidAPI. By submitting a website via a simple form, the workflow fetches both backlink overview metrics and detailed backlink entries, saving the results directly into a connected Google Sheet. This is an ideal solution for SEO professionals who want fast, automated insights without logging into multiple tools. 🧩 Node-by-Node Explanation On form submission** – Starts the workflow when a user submits a website URL through a web form. HTTP Request* – Sends the URL to the *Semrush Backlink Checker API** using a POST request with headers and form data. Reformat 1** – Extracts high-level backlink overview data like total backlinks and referring domains. Reformat 2** – Extracts individual backlink records such as source URLs, anchors, and metrics. Backlink overview** – Appends overview metrics into the "backlink overflow" tab of a Google Sheet. Backlinks** – Appends detailed backlink data into the main "backlinks" tab of the same Google Sheet. ✅ Benefits of This Workflow No-code integration**: Built entirely within n8n—no scripting required. Time-saving automation**: Eliminates the need to manually log in or export reports from Semrush. Centralized results**: All backlink data is organized in Google Sheets for easy access and sharing. Powered by RapidAPI: Uses the **Semrush Backlink Checker API hosted on RapidAPI for fast, reliable access. Easily extendable**: Can be enhanced with notifications, dashboards, or additional data enrichment. 🛠️ Use Cases 📊 SEO Audit Automation – Auto-generate backlink insights for multiple websites via form submissions. 🧾 Client Reporting – Streamline backlink reporting for SEO agencies or consultants. 📥 Lead Capture Tool – Offer a free backlink analysis tool on your site to capture leads while showcasing value. 🔁 Scheduled Backlink Monitoring – Modify the trigger to run on a schedule for recurring reports. 📈 Campaign Tracking – Monitor backlinks earned during content marketing or digital PR campaigns. 🔐 How to Get Your API Key for the Competitor Keyword Analysis API Go to 👉 Semrush Backlink Checker API - RapidAPI Click "Subscribe to Test" (you may need to sign up or log in). Choose a pricing plan (there’s a free tier for testing). After subscribing, click on the "Endpoints" tab. Your API Key will be visible in the "x-rapidapi-key" header. 🔑 Copy and paste this key into the httpRequest node in your workflow. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!

The Telegram API has a limitation to send only 30 messages per second. Use this workflow to send messages to more than 30 chats in Telegram.

With workflow, you analyze Email with TheHive/Cortex https://github.com/V1D1AN/S1EM/wiki/Soar-guide

Search LinkedIn Companies, Score Them with AI, and Add to Google Sheets CRM Who is this for? This template is designed for sales teams, business development reps, and marketers who need a reliable, automated way to build targeted prospect lists. It’s especially useful for agencies, consultants, and B2B companies that want to identify, qualify, and prioritize high-value leads. What problem does this workflow solve? Researching companies on LinkedIn, evaluating whether they fit your ideal customer profile, and manually updating your CRM can be slow, inconsistent, and labor-intensive. This workflow replaces that entire process with a fully automated system that finds, qualifies, and organizes leads for you. What this workflow does The workflow searches LinkedIn for companies based on your chosen filters, gathers in-depth company details, applies qualification rules, uses AI to score how well each company matches your ICP, and then adds them to your Google Sheets CRM while automatically preventing duplicates. Setup Create a Ghost Genius API account and generate your API key Add your API credentials to the HTTP Request nodes Make a copy of the included Google Sheets template Set up Google Sheets and OpenAI credentials as described in the n8n documentation Customize the Set Variables node to define your audience and AI scoring parameters How to customize this workflow Update your search filters to target specific industries, regions, or company sizes Change the follower count threshold to match your qualification rules Modify the AI scoring prompt to better reflect your product or service Add notifications (email, Slack, etc.) to alert you when high-scoring leads are found

Description This workflow automates the process of retrieving Stripe invoices, validating API responses, generating payment receipts, sending them via email, storing PDFs in Google Drive, and appending details to a Google Sheet ledger. It also includes an error logging system to capture and record workflow issues, ensuring financial operations are both automated and reliable. What This Template Does (Step-by-Step) 📋 Manual Trigger – Start the workflow manually by clicking Execute workflow. 🔗 Fetch Invoices – Authenticates with Stripe and retrieves the 5 most recent invoices (includes customer info, amounts, statuses, and invoice URLs). ✅ Check API Response – Ensures the Stripe API response contains a valid data[] array. If not, errors are logged. 📂 Expand List – Splits Stripe’s bundled invoice list into individual invoice records for independent processing. 💳 IF (Paid?) – Routes invoices based on payment status; only paid invoices move forward. 📧 IF (Already Receipted?) – Skips invoices where a receipt has already been generated (receipt_sent = true). 📑 Download File – Downloads the hosted invoice PDF from Stripe for use in emails and archiving. ✉️ Send Receipt Email – Emails the customer a payment receipt with the PDF attached, using invoice details (number, amount, customer name). ☁️ Upload Invoice PDF – Uploads the invoice PDF to a specific Google Drive folder, named by invoice number. 📊 Append to Ledger – Updates a Google Sheet with invoice metadata (date, invoice number, Drive file ID, link, size). ⚠️ Error Logging – Logs workflow issues (failed API calls, missing data, etc.) into a dedicated error tracking sheet. Prerequisites Stripe API key (with invoice read permissions) Google Drive (destination folder for invoices) Google Sheets with: Receipts Ledger Sheet Error Logging Sheet Gmail OAuth2 account for sending receipts Key Benefits ✅ Automates customer receipt delivery with attached PDFs ✅ Builds a permanent ledger in Google Sheets for finance ✅ Archives invoices in Google Drive for easy retrieval ✅ Prevents duplicates by checking receipt_sent metadata ✅ Includes error logging for smooth monitoring and debugging Perfect For Finance/accounting teams needing automated receipt handling SaaS businesses managing recurring Stripe invoices Operations teams requiring error-proof automation Any business needing audit-ready receipts + logs

Stop sending sensitive agency drafts as permanent email attachments. This workflow creates a "self-destructing" delivery system that hosts files via UploadToURL, sends branded previews via SendGrid, and automatically expires access after a set duration while logging the entire lifecycle in Google Sheets. 🎯 What This Workflow Does Turns any sensitive file into a professional, time-limited client preview: 📝 Captures Delivery Request - Receives the file (binary or URL), recipient info, and desired expiry duration (e.g., 24 hours) via Webhook. ☁️ Instant CDN Hosting - UploadToURL hosts the asset and returns a high-speed public link. 🔑 Secure Token Generation - Generates a unique hex token and calculates the exact UTC expiry timestamp. 📊 Real-time Logging - Records the link in Google Sheets as active with all metadata before the email is sent. 📧 Branded Delivery - Sends a professional HTML email via SendGrid featuring your branding, a secure "View File" button, and a clear expiry notice. ⏳ Automated Expiration - Pauses execution for the specified duration using the Wait node, then updates the sheet to expired and notifies both the client and the agency. ✨ Key Features UploadToURL Integration**: Native community node hosting ensures your files are web-ready instantly without manual cloud storage setup. Dynamic "Burner" Logic**: The link stays active only as long as you specify (from 1 to 168 hours). Dual-Phase Notifications**: Clients get a polite notice when the link is active and a second one when it has officially expired. Lifecycle Tracking**: A centralized Google Sheet acts as your "Delivery Command Center," tracking tokens, sent times, and expiry statuses. Agency Audit Trail**: The agency receives a final summary email once a link's lifecycle is complete, providing a full record for project management. 💼 Perfect For Creative Agencies**: Sharing draft designs, videos, or proposals that shouldn't live in a client's inbox forever. Legal & Finance**: Providing temporary access to sensitive documents or statements. Freelancers**: Delivering final assets that require a "preview-only" window before final payment. HR Teams**: Sending temporary access to employee handbooks or internal policy drafts. 🔧 What You'll Need Required Integrations UploadToURL** - To host assets and provide secure CDN links. n8n Community Node** - n8n-nodes-uploadtourl must be installed. SendGrid** - To send the branded preview and expiry emails. Google Sheets** - To act as the database for link tracking. Configuration Variables GSHEET_SPREADSHEET_ID: The ID of your tracking sheet. DEFAULT_EXPIRY_HOURS: Default time (e.g., 24) if not specified in the webhook. AGENCY_NAME & AGENCY_EMAIL: For branding the automated emails. 🚀 Quick Start Import Template - Copy the JSON and import it into your n8n canvas. Install Node - Ensure the UploadToURL community node is installed. Set Credentials - Link your UploadToURL, SendGrid, and Google Sheets accounts. Prepare Sheet - Create a sheet named BurnerLinks with columns: Token, Recipient Email, Status, Sent At, Expires At, and CDN URL. Define Variables - Update the n8n variables with your Sheet ID and Agency details. Deploy - Activate the workflow and start sending secure, timed previews. 🎨 Customization Options Branding**: Edit the Generate Link Record code node to update the HTML/CSS for the email templates to match your brand colors. Extended Wait**: For links lasting weeks, ensure your n8n instance is configured to persist executions across restarts. Slack Alerts**: Add a Slack node to notify your team the moment a client clicks the link (requires a redirect/tracking layer). Password Protection**: Integrate an additional layer that requires a password (sent via a separate channel) to view the UploadToURL link. 📈 Expected Results Enhanced Security**: Sensitive files no longer float around indefinitely in client inboxes. Professional Impression**: Clients receive branded, structured previews that emphasize security and professionalism. Zero Manual Cleanup**: No need to manually delete files or remember to "turn off" links. Complete Transparency**: Always know exactly which links are active and when they were accessed. 🏆 Use Cases Pitch Deck Delivery Send your high-stakes pitch deck with a 48-hour window. The urgency encourages the client to review it promptly while protecting your IP. Contract Previews Share a draft agreement for a quick 24-hour review. Once the window closes, the client is prompted to contact you for the final version. Limited-Time Portfolio Share a custom portfolio or "lookbook" with a lead, giving them 7 days of access to create a "limited time" feel to your availability. 💡 Pro Tips Wait Node Execution**: Each link runs as a separate execution. If you send 100 links, you will see 100 "Waiting" executions in your history. File Types**: The workflow includes validation for PDF, JPG, PNG, DOCX, and MP4. You can expand this in the Validate Payload code node. BCC Records**: The workflow automatically BCCs the agency on the first email so you have a copy in your own sent folder. Ready to secure your deliveries? Import this template and connect UploadToURL to start sending professional "burner" links today. Questions about the Google Sheet setup? The workflow includes a detailed sticky note explaining the exact column headers needed for the database sync.