12 templates found
Category:
Author:
Sort:

Chat with GitHub API documentation: RAG-powered chatbot with Pinecone & OpenAI

This workflow demonstrates a Retrieval Augmented Generation (RAG) chatbot that lets you chat with the GitHub API Specification (documentation) using natural language. Built with n8n, OpenAI's LLMs and the Pinecone vector database, it provides accurate and context-aware responses to your questions about how to use the GitHub API. You could adapt this to any OpenAPI specification for any public or private API, thus creating a documentation chatbout that anyone in your company can use. How it works: Data Ingestion: The workflow fetches the complete GitHub API OpenAPI 3 specification directly from the GitHub repository. Chunking and Embeddings: It splits the large API spec into smaller, manageable chunks. OpenAI's embedding models then generate vector embeddings for each chunk, capturing their semantic meaning. Vector Database Storage: These embeddings, along with the corresponding text chunks, are stored in a Pinecone vector database. Chat Interface and Query Processing: The workflow provides a simple chat interface. When you ask a question, it generates an embedding for your query using the same OpenAI model. Semantic Search and Retrieval: Pinecone is queried to find the most relevant text chunks from the API spec based on the query embedding. Response Generation: The retrieved chunks and your original question are fed to OpenAI's gpt-4o-mini LLM, which generates a concise, informative, and contextually relevant answer, including code snippets when applicable. Set up steps: Create accounts: You'll need accounts with OpenAI and Pinecone. API keys: Obtain API keys for both services. Configure credentials: In your n8n environment, configure credentials for OpenAI and Pinecone using your API keys. Import the workflow: Import this workflow into your n8n instance. Pinecone Index: Ensure you have a Pinecone index named "n8n-demo" or adjust the workflow accordingly. The workflow is set up to work with this index out of the box. Setup Time: Approximately 15-20 minutes. Why use this workflow? Learn RAG in Action: This is a practical, hands-on example of how to build a RAG-powered chatbot. Adaptable Template: Easily modify this workflow to create chatbots for other APIs or knowledge bases. n8n Made Easy: See how n8n simplifies complex integrations between data sources, vector databases, and LLMs.

Mihai FarcasBy Mihai Farcas
29649

Create AI news avatar videos with Dumpling AI, GPT-4o and HeyGen

🧾 What this workflow does This workflow automatically generates avatar-style videos from the latest AI-related news using Dumpling AI and HeyGen. It runs every hour, scrapes trending articles, turns them into 30–60 second spoken scripts with GPT-4o, and produces short avatar videos with HeyGen. Finally, it logs the final video URL in a Google Sheet. --- πŸ‘€ Who is this for Newsletters and creators who want to automate AI trend updates Content marketers generating short-form video content Product teams experimenting with AI-generated summaries Automation enthusiasts combining LLMs + video + trending data --- βš™οΈ How to set up πŸ” Requirements Dumpling AI API Key stored securely as HTTP Header credential HeyGen API Key added as an HTTP Header credential OpenAI API Key for GPT-4o (can use GPT-4o-mini if preferred) Google Sheets account with one column: Video link πŸ›  Step-by-step setup Google Sheet Setup Create a Google Sheet with a single column named: Video link Update Credentials Use n8n’s credential manager to add tokens for: Dumpling AI HeyGen OpenAI Google Sheets Optional Customizations In the "Dumpling AI: Search AI News" node, you can change "query": "AI Agent" to other trending keywords (e.g., "Generative AI", "Autonomous Agents", etc.) Update the avatarid and voiceid in the HeyGen request to match your preferred look/sound --- 🧠 How it works The Schedule Trigger runs hourly. Dumpling AI searches for fresh news related to "AI Agent." The top 4 news links are scraped for full content. Articles are merged and fed into GPT-4o via a LangChain Agent to produce a casual, conversational video script. HeyGen creates a video using the script, avatar, and voice. The workflow waits until the video rendering is complete. Once done, the final video link is logged into Google Sheets. --- πŸ§ͺ Customization Ideas Change the interval (e.g., every 6 hours, daily) Swap avatar/voice in HeyGen to fit your brand Expand to post the video directly to social media Add image background or B-roll overlays using Creatomate --- This is a fast, automated pipeline to create explainer-style AI news updates using real-time data and generative video tools.

YangBy Yang
4163

Upload bulk records from CSV - Airtable Interfaces

This workflow is a supporting automation to a common Airtable situation, that as of this writing, has no direct solution but has great demand. Interfaces are your secret weapon for managing a variety of tasks – from sales funnels and task tracking to creating dynamic dashboards. But here's a common situation: how do you efficiently bulk upload records (like contacts, leads, or clients) from an interface with just a click? Once set up, you'll be able to upload CSV files directly to your tables from the Interfaces with ease. Workflow Key Points: Bulk Upload Functionality: Say goodbye to the limitations of standard Airtable interfaces. Now, you can upload multiple leads or contacts simultaneously, making your work swift and efficient. Customizable Fields: Tailor the base to meet your specific data needs. This ensures seamless integration with your existing systems and simplifies data management. ​ Perfect for teams in e-commerce, CRM, or any sector where managing a high volume of leads or contacts is key. Our Airtable Base is designed to eliminate the tediousness of importing contacts. It makes large-scale data management straightforward, saving you precious time and hassle. ​ Get ready to streamline your operations and boost your productivity! πŸš€πŸ’‘

SidetoolBy Sidetool
2075

Multi-platform video publishing from Google Sheets to 9 social networks via Blotato API

This workflow automates the process of publishing content from a Google Sheet to multiple social media platforms using the Blotato API. It retrieves content details (caption and Google Drive video URL) from a Google Sheet, uploads the media to Blotato, and then distributes it to Instagram, Facebook, LinkedIn, TikTok, YouTube, Threads, Twitter, Bluesky, and Pinterest. It also includes a separate branch for generating and publishing an AI-created image to Pinterest. Tools & Services Used Content Source: Google Sheets (for captions, status, and Google Drive video URLs) Media Hosting: Google Drive (for source videos) Social Media Publishing API: Blotato API (for media upload and posting to all platforms) AI Image Generation: OpenAI (DALL-E for generating an image for Pinterest) Target Social Platforms: Instagram Facebook (Pages) LinkedIn TikTok YouTube Threads Twitter (X) Bluesky Pinterest Workflow Overview This automation performs the following steps: Trigger & Content Retrieval: The Schedule Trigger node initiates the workflow on a defined schedule (e.g., every interval). The Google Sheets node reads data from a specified sheet (Sheet1 of "Publish to 9 Social Platforms"). It filters for rows where the "Status" column is "Ready to Post" and returns the first match. This provides the caption and the Google Drive URL for the video content. The Get Google Drive ID node (a Set node) extracts the unique Google Drive file ID from the video URL obtained from the sheet. Configuration & Media Preparation for Blotato: The Setup Social Accounts node (a Set node) defines placeholders for the Blotato API key and various social media account IDs required by the Blotato API. These need to be manually filled with your actual credentials and IDs. The Upload to Blotato node (HTTP Request) uploads the video content to Blotato's media endpoint. It constructs the downloadable Google Drive URL using the extracted file ID and sends it to Blotato along with the API key. Blotato then fetches and stores the media, returning a Blotato media URL. Content Distribution to Social Platforms via Blotato (Parallel Branches from "Upload to Blotato"): The Blotato media URL (from the previous step) and the caption (from Google Sheets) are used to make individual POST requests to the Blotato API (/v2/posts) for each target platform. Each request is an HTTP Request node configured for a specific platform: [Instagram] Publish via Blotato (Disabled by default): Posts to the configured Instagram account. Publish to Facebook: Posts to the configured Facebook Page. Publish to LinkedIn: Posts to the configured LinkedIn account. Publish to Tiktok: Posts to the configured TikTok account, with specific privacy and feature settings. Publish to Youtube: Uploads the video as a public YouTube short/video with a title and notifying subscribers. Publish to Threads: Posts to the configured Threads account (caption sliced to 500 chars). Publish to Twitter: Posts to the configured Twitter (X) account (caption sliced to 280 chars). Publish to Bluesky: Posts text-only (no media URL used in the example body) to the configured Bluesky account (caption sliced to 280 chars). AI Image Generation & Pinterest Publishing (Separate Branch from "Upload to Blotato"): This branch demonstrates an alternative content type. The OpenAI node generates an image based on a prompt ("Image of a manatee staring in the mirror at its AI avatar") and returns image URLs. The Upload to Blotato - Image node (HTTP Request) takes one of these generated image URLs and uploads it to Blotato's media endpoint. The [Pinterest] Publish via Blotato node then posts this AI-generated image to the configured Pinterest account and board, along with the caption from the Google Sheet and a link.

Sam YassineBy Sam Yassine
839

Sync Shopify customers to Google Sheets + Squarespace compatible csv

This workflow retrieves all Shopify Customers and saves them into a Google Sheets spreadsheet using the Shopify Admin REST API. It uses pagination to ensure all customers are collected efficiently. N8n does not have built-in actions for Customers, so I built the workflow using an HTTP Request node. How It Works This workflow uses the HTTP Request node to fetch paginated chunks manually. Shopify uses cursor-based pagination (page_info) instead of traditional page numbers. Pagination data is stored in the response headers, so we need to enable Include Response Headers and Status in the HTTP Request node. The workflow processes customer data, saves it to Google Sheets, and formats a compatible CSV for Squarespace Contacts import. This workflow can be run on demand or scheduled to keep your data up to date. Parameters You can adjust these parameters in the HTTP Request node: limit – The number of customers per request (default: 50, max: 250). fields – Comma-separated list of fields to retrieve. page_info – Used for pagination; only limit and fields are allowed when paginating. πŸ“Œ Note: When you query paginated chunks with page_info, only the limit and fields parameters are allowed. Credentials Shopify API Key – Required for authentication. Google Sheets API credentials – Needed to insert data into the spreadsheet. Google Sheets Template Clone this spreadsheet: πŸ“Ž Google Sheets Template According to Squarespace documentation, your spreadsheet can have up to three columns and must be arranged in this order (no header): Email Address First Name (optional) Last Name (optional) Shopify Customer ID (this field will be ignored) Exporting a Compatible CSV for Squarespace Contacts This workflow also generates a CSV file that can be imported into Squarespace Contacts. How to Import the CSV to Squarespace: Open the Lists & Segments panel and click on your mailing list. Click Add Subscribers, then select Upload a list. Click Add a CSV file and select the file to import. Toggle These subscribers accept marketing to confirm permission. Preview your list, then click Import. Who Is This For? Shopify store owners who need to export all customers to Google Sheets. Anyone looking for a flexible and scalable Shopify customers extraction solution. Squarespace website owners who want to bulk-create their Contacts using CSV. --- Explore More Templates πŸ‘‰ Check out my other n8n templates

bangank36By bangank36
622

Build an AI chatbot with InfraNodus knowledge graph for enhanced responses

Build an embeddable AI chatbot with an access to a knowledge base This is an example of a simple AI chatbot that has access to external knowledge to augment its responses. The knowledge can be added manually or imported from multiple sources (text and PDF files, websites, CSVs, Google search results, AI generated, YouTube search results, RSS feeds, etc) using InfraNodus. β€’ no OpenAI account needed β€’Β no vector store needed β€’Β easy data import: PDF, text, CSV, Google / YouTube results, RSS feeds, websites, or AI-generated How it works First, you add your data into your InfraNodus graph β€” this will be your knowledge base. You can import this data from multiple sources or add it manually. You will have a visual interface available that will show the main concepts and topics in your knowledge base, so you can have an overview of its structure and know how to improve it, if necessary. Your data is represented as a knowledge graph which contains information about relations and topical clusters in your data, making the LLM responses much more precise. How to use Copy the template Add your InfraNodus API key to the HTTP AI response node Create a new graph in InfraNodus with your data (or import from an external source) Add the name of this graph into the name field of the AI response HTTP node. That's it! You can query it using the embeddable web form available via a URL Requirements You only need an InfraNodus account to set this workflow up. Free 14-day trials are available.

InfraNodusBy InfraNodus
589

Automated press pass verification & badge creation with QR codes & multi-channel distribution

🎫 Verified Press Pass Generator for Media Events Automate press credential verification and badge generation for journalists covering your events --- πŸ“ Description Streamline your event media management with this comprehensive press pass automation. When journalists apply for credentials, this workflow instantly validates their identity, verifies their media affiliation, generates professional digital badges with QR codes, and delivers everything via emailβ€”all within seconds. Perfect for conferences, product launches, trade shows, corporate events, and any occasion requiring verified media access. --- ✨ Key Features πŸ” Advanced Email Verification Real-time email validation using VerifiEmail API Checks RFC compliance, MX records, and domain reputation Detects disposable email addresses and spoofed domains Confirms journalist works for legitimate media organization 🎨 Professional Badge Design Auto-generates branded digital press passes Includes journalist photo, name, media outlet, and credentials Embedded QR code for contactless event entry Customizable colors, fonts, and event branding 400Γ—600px portrait format optimized for mobile display πŸ“§ Automated Communication Beautiful HTML email with embedded badge preview Download links for PNG and PDF versions Clear instructions for event check-in Professional event branding throughout πŸ“Š Multi-Platform Logging Google Sheets backup with timestamp logs Slack notifications for organizer oversight Complete audit trail for compliance ⚑ Lightning Fast Processing Average execution time: 5-10 seconds Real-time webhook response with confirmation Scalable to hundreds of applications per hour Error handling with graceful fallbacks --- 🎯 Use Cases Event Types: Tech conferences and summits Product launch events Trade shows and exhibitions Political rallies and press conferences Sports events and tournaments Film festivals and premieres Corporate announcements Award ceremonies --- πŸ”§ What You Need Required Services: n8n (Cloud or Self-hosted) VerifiEmail API (Get API Key) - Email verification HTMLCSSToImage API (Get API Key) - Badge generation Gmail Account (OAuth) - Email delivery Slack Workspace - Team notifications Google Sheets - Backup logging --- πŸ“‹ How It Works Step-by-Step Process: Application Submission Journalist fills out form on your event website (name, email, media outlet, photo, phone) Data Validation Webhook receives application and checks for required fields (name, email, photo) Email Verification VerifiEmail API validates email domain, checks MX records, and confirms media affiliation Credential Generation Generates unique press ID (PRESS-XXX-timestamp) Creates QR code linking to verification portal Sets 30-day validity period Badge Creation HTMLCSSToImage API renders professional badge with: Circular profile photo Name and media outlet Press ID in styled container Scannable QR code Event name and validity dates "VERIFIED" indicator Distribution Sends HTML email with badge preview and download link Posts notification to Slack channel Backs up to Google Sheets Returns success response to webhook Event Check-In Security scans QR code at event entrance, verifies credentials instantly --- πŸš€ Setup Instructions Quick Start (15 minutes): Import Workflow Download the JSON file In n8n: Click Workflows β†’ Import from File Upload the JSON and open the workflow Configure Webhook Activate the workflow Copy the webhook URL from the Webhook Trigger node Add this URL to your website form's action attribute Add API Credentials VerifiEmail: Create credential with API key from verifi.email dashboard HTMLCSSToImage: Add User ID and API Key from htmlcsstoimg.com Gmail: Connect via OAuth (click "Sign in with Google") Slack: Connect via OAuth and select notification channel Google Sheets: Connect via OAuth Setup Google Sheets Create a new sheet named "Press Pass Logs" with these column headers: Timestamp | Press ID | Name | Email | Phone | Media Outlet | Email Domain | Verification Status | Event Name | Issued Date | Valid Until | Badge Image URL | QR Code URL | Verification URL | Photo URL | Execution Mode Customize Badge Design Open the "HTML/CSS to Image" node Edit the HTML in html_content field Change gradient colors: Replace 667eea and 764ba2 with your brand colors Update event name default value Modify font sizes, spacing, or layout as needed Update Email Content Open "Send Press Pass Email" node Customize email text, support contact info Update company/event branding Modify footer with your details Configure Slack Channel Open "Notify Organizers (Slack)" node Select your preferred notification channel Customize notification message format Test the Workflow Send a test POST request using Postman or cURL: bash curl -X POST https://your-n8n-url/webhook/press-application \ -H "Content-Type: application/json" \ -d '{ "name": "Jane Smith", "email": "jane@bbc.com", "media_outlet": "BBC News", "photo_url": "https://randomuser.me/api/portraits/women/50.jpg", "phone": "+44-1234567890", "event_name": "Tech Summit 2025" }' Go Live Verify test execution completed successfully Check email received with badge Activate workflow for production use --- 🎨 Customization Options Badge Design: Colors: Change gradient from purple (667eea, 764ba2) to your brand colors Fonts: Swap Google Font from Poppins to any available font Logo: Add event logo in header section Size: Adjust viewportwidth and viewportheight for different dimensions Layout: Modify HTML structure for custom badge designs Email Templates: Branding: Update colors, fonts, and styling in HTML email Content: Customize greeting, instructions, and footer Attachments: Add PDF version or additional documents Language: Translate all text to your language --- πŸ”’ Security & Privacy Data Protection: βœ… Email verification prevents fake submissions βœ… QR codes use unique, non-guessable IDs βœ… HTTPS webhook for encrypted transmission βœ… No sensitive data stored in workflow variables βœ… Audit trail for compliance requirements Best Practices: Use environment variables for API keys Enable webhook authentication (Basic Auth or API key) Implement rate limiting on webhook endpoint Regularly rotate API credentials Set up backup systems for critical data --- πŸ› οΈ Troubleshooting Common Issues: Issue: "Webhook not receiving data" Solution: Ensure workflow is activated and webhook URL is correct in form action Issue: "Email verification fails for valid domains" Solution: Check VerifiEmail API credit balance and credential configuration Issue: "Badge image not generating" Solution: Verify HTMLCSSToImage API key is correct and has sufficient credits Issue: "Gmail not sending" Solution: Reconnect Gmail OAuth credential and check sending limits Issue: "QR code not loading in badge" Solution: Ensure QR code URL is properly encoded and publicly accessible --- πŸ“ˆ Performance Metrics Average execution time: 5-10 seconds Success rate: 98%+ (with valid inputs) Concurrent capacity: 50+ requests/minute API reliability: 99.9% uptime (dependent on services) Badge generation: <2 seconds Email delivery: <3 seconds --- 🏷️ Tags event-management press-pass credential-verification badge-generation email-automation qr-code media-relations event-technology htmlcsstoimage verifi-email gmail slack google-sheets webhook automation workflow conference journalism press-credentials --- πŸ“„ License This workflow template is provided as-is for use with n8n. Customize freely for your organization's needs. ---

Jitesh DugarBy Jitesh Dugar
362

Query business data from Uniconta ERP with OpenAI chatbot via Peliqan

How it works This template is an end-to-end demo of an in-house AI agent that can answer a wide range of questions by retrieving information from the Uniconta ERP system. For example users can ask questions related to products, stock, accounting or any other type of information contained in Uniconta. Peliqan.io is used as a "cache" of all Uniconta data. Peliqan uses one-click ELT to sync all data from Uniconta to the built-in data warehouse, allowing for fast & accurate queries. The AI agent uses Text-to-SQL to answer questions. Text-to-SQL is performed via the Peliqan node, added as a tool to the AI Agent. The question of the user - in natural language - is converted to an SQL query by the AI Agent. The query is executed by Peliqan.io on the source Uniconta data and the result is interpreted by the AI Agent. Preconditions You signed up for a Peliqan.io free trial account You have a Uniconta ERP system Set up steps Sign up for a free trial on peliqan.io Add Uniconta as a connection in Peliqan (using an API key from Uniconta) Copy your Peliqan API key (in Peliqan go to Settings > API key) and use it in n8n to add a Peliqan connection Select your data warehouse in the Peliqan node "Execute an SQL query via Peliqan" in the drop-down field "Data warehouse name or id" Optional: run the template script in Peliqan that outputs your specific Uniconta datamodel (tables & columns). Copy your datamodel and paste it in the System Message of the AI Agent (replace the standard Uniconta model already present in this workflow) Visit peliqan.io/n8n for more information. Need help ? Contact Peliqan at support@peliqan.io Disclaimer: This template contains a community node and therefore only works for n8n self-hosted users.

PeliqanBy Peliqan
320

Build & deploy MVPs from text prompts with AI, GitHub & Vercel

⚑ Instant MVP Builder Idea, Build, and Deploy β€” in Minutes, with AI by Varritech Technologies --- πŸ—οΈ What Is It? Instant MVP Builder is a plug-and-play n8n workflow that takes a plain-English app idea and turns it into a fully deployed web application β€” without writing a single line of code. Designed for founders, solopreneurs, and agencies, this system uses AI agents, GitHub, and Vercel to automatically: Analyze and structure the app idea Generate source code with GPT Deploy a live frontend to the web --- 🧠 How It Works Webhook Trigger Accepts a chat message or form input with a basic app idea. AI Prompt Agent (Langchain) Turns the message into structured specs (name, features, stack, etc). Code Generator Agent (OpenAI) Writes frontend code (React) tailored to the app spec. GitHub Integration Creates a new repo from a starter template and pushes the code. Vercel Deployment Deploys the app and returns a public URL β€” all automatically. --- πŸ”§ Built With n8n – Automation engine for flow orchestration Langchain + OpenAI – For AI-powered prompt and code creation GitHub API – To manage repositories Vercel API – For instant frontend deployment JavaScript – For logic and parsing --- 🎯 Use Cases πŸš€ Startup MVP generation πŸ§ͺ Hackathon-ready app builds 🎨 Client landing page creation πŸ“¦ Internal tool prototypes πŸ’‘ β€œIdea-to-product” workflows --- 🟨 What Makes It Special? 🧠 AI-generated code, not templates βš™οΈ Fully automated from input to deploy 🌍 Public app URL in minutes 🧩 Easily customizable: edit prompts, swap repo, or deploy elsewhere 🧱 Includes built-in sticky notes + Notion setup guide --- πŸ› οΈ What’s Included βœ… Cleaned, import-ready .json file for n8n βœ… Notion setup guide βœ… In-flow sticky notes describing every node βœ… No hardcoded secrets β€” ready for your credentials βœ… Lifetime access & updates for personal use --- πŸ“„ License This workflow is licensed for single-business or internal use. Need something more? We offer: 🀝 Resell licenses for agencies 🌟 White-label customization πŸ”§ Prompt tuning or backend extensions --- πŸ‘‹ About Varritech Varritech Technologies is an AI-first development agency helping businesses go from idea to production 5Γ— faster. We specialize in building autonomous engineering workflows, onboarding systems, sales funnels, and internal tools β€” all powered by modern AI. πŸ“¬ christian@varritech.com 🌐 varritech.com --- βœ… Build smarter. Launch faster. Automate everything. With Instant MVP Builder, your next app idea doesn’t need a dev β€” just a trigger.

VarritechBy Varritech
155

Convert Telegram channel posts to WooCommerce products automatically

Auto-publish Telegram channel posts to WooCommerce store This n8n template automatically converts Telegram channel posts into WooCommerce products, perfect for businesses that share products on Telegram and want to sync them with their online shop. Who's it for E-commerce businesses, dropshippers, and retailers who: Use Telegram channels to showcase products Want to automatically sync products to their WooCommerce store Need to reduce manual data entry between platforms Handle multiple product images and want them properly organized How it works The workflow monitors your Telegram channel for new posts and automatically creates corresponding WooCommerce products: Telegram Trigger detects new channel posts with photos and captions Text Processing extracts product details from the post: First line becomes the product title First hashtag determines the product category Price is extracted using regex patterns Channel signature is removed from description Image Handling downloads and uploads images to WordPress media library Category Matching fetches WooCommerce categories and matches them with hashtags Product Creation creates the WooCommerce product with all extracted data Multi-Image Support handles posts with multiple images by updating the product How to set up Telegram Setup: Create a Telegram bot and get the API token Add the bot to your channel as an administrator Configure the Telegram Trigger with your bot credentials WooCommerce Setup: Enable WooCommerce REST API in your WordPress admin Create API keys with read/write permissions Configure the WooCommerce nodes with your API credentials WordPress Setup: Configure HTTP Basic Auth for WordPress REST API Update the woocommerce_url in the SetFields node with your domain Channel Post Format: First line: Product title Include at least one photo Add price in format: 9,500,000 or 9.500.000 Use hashtags that match your WooCommerce category names End posts with your signature after the divider character Requirements Active Telegram bot with channel admin access WooCommerce store with REST API enabled WordPress with media upload permissions How to customize the workflow Price Format: Modify the regex patterns in the Code node to match your currency format Category Mapping: Ensure your Telegram hashtags exactly match your WooCommerce category names Signature Divider: Change the signature divider character in SetFields node (default: "_") Image Quality: Adjust the Telegram file download to get different image resolutions Product Status: Modify the product creation node to set products as draft instead of published

ShohaniBy Shohani
86

Aggregate endpoint security risk scores with EDR, vulnerability data & Google Sheets

πŸ‘€ Who it’s for Security teams, SOC analysts, and small-to-mid IT teams looking to automatically assess endpoint risk by combining known vulnerabilities with internal asset value and dynamic threat indicators. Perfect for teams using Google Sheets or CSV asset inventories who want to prioritize incidents based on true business risk β€” not just raw CVE scores. βš™οΈ How it works / What it does Fetches endpoint-specific CVE data from prior modules or external feeds Loads enriched internal asset inventory (IP, department, criticality, etc.) Calculates risk score using a weighted formula: (CVE severity Γ— Asset risk rating Γ— Exposure coefficient) Applies custom playbook rules to determine action level (Notify / Investigate / Isolate) Outputs filtered, triaged list of high-risk endpoints Logs results to active and historical threat sheets Sends summary email alerts based on final triaged list πŸ› οΈ How to set up Google Sheets: Connect your enriched asset inventory and endpoint vulnerability input sheets using your OAuth2 credentials Edit Thresholds: Adjust scoring logic or thresholds in the β€œπŸ”Ž Risk Score Calculator” node Email Alerts: Add your sender credentials and customize recipient address list Automation Trigger: Optional: Add a Cron node or Webhook to run this aggregator hourly/daily Review sticky notes: All logic is labeled clearly with setup instructions πŸ“‹ Requirements Google account + access to n8n Google Sheets integration Vulnerability scan output (from CyberScan or external CVE feed) Enriched asset inventory with basic scoring fields (asset value, criticality) SMTP or email alert service (optional) 🧩 How to customize the workflow Replace Google Sheets with Supabase, Airtable, or internal DB Add columns for department ownership, system type, or live agent signals Integrate with EDR/XDR system or incident tracking tool Expand the playbook to include automatic isolation triggers πŸ“¦ This is a clean, production-ready version with no sensitive data. Placeholders are clearly marked. πŸ” This module is part of the CYBERPULSEBlueOps Pro Pack. Get access to advanced automation, isolation triggers, full asset triage logic, and instant download at πŸ‘‰ cyberpulsesolutions.com/blueops

Adnan TariqBy Adnan Tariq
64

Generate custom branded PDF invoices from QuickBooks and email to clients

Automated QuickBooks Invoice to Custom PDF & Email This n8n workflow automates the entire QuickBooks invoicing process β€” from creation to delivery. When a new invoice is generated in QuickBooks Online, it automatically fetches the data, applies your company branding, converts it into a professional multi-page PDF via Gotenberg, and emails it directly to your client. Key Features: ⚑ Fully Automated: Triggers instantly on new QuickBooks invoices. 🧾 Custom Branding: Adds your logo and signature from public URLs. 🎨 Modern PDF Design: Clean, professional multi-page layout with smart totals and β€œPage X of Y” footers. πŸ“§ Automatic Emailing: Sends the final PDF in a formatted email to your customer. Requirements: QuickBooks Online, n8n instance, Gotenberg (HTMLβ†’PDF converter), and public URLs for logo/signature.

Chintan PrajapatiBy Chintan Prajapati
33
All templates loaded