by Sankalp Dev
Automated Marketing Analytics Report with AI Agent How it works Transform your marketing data into actionable insights with this intelligent automation workflow. The system combines scheduled triggers with AI-powered analysis to deliver comprehensive marketing reports directly to your inbox. Key Features: Scheduled automated reporting (daily, weekly, or monthly) AI-powered data analysis using advanced language models Multi-platform marketing data integration via GoMarble MCP Intelligent report generation with actionable recommendations Direct email delivery of formatted reports Set up steps Prerequisites: GoMarble MCP account and API access Gmail account for report delivery n8n instance (cloud or self-hosted) Configuration Time: ~15-20 minutes Step-by-step setup: Connect GoMarble MCP to n8n Follow the integration guide: GoMarble n8n Setup Configure your marketing platform credentials (Google Ads, Facebook Ads, Analytics) Configure the Schedule Trigger Set your preferred reporting frequency Choose optimal timing for data availability Customize the Report Prompt Define specific metrics and KPIs to track Set analysis parameters and report format preferences Set up AI Agent Configuration Choose between Anthropic Claude or OpenAI models Configure the GoMarble MCP tools for your marketing platforms Configure Gmail Integration Set recipient email addresses Customize email template and subject line Advanced Configuration: Add conditional logic for performance thresholds Include custom data visualization requests Set up alert triggers for significant metric changes What you'll get Automated Intelligence:** Regular marketing performance analysis without manual effort Cross-Platform Insights:** Unified view of Google Ads, Facebook Ads, and Analytics data AI-Powered Recommendations:** Strategic insights and optimization suggestions Professional Reports:** Well-formatted, executive-ready marketing summaries Scalable Solution:** Easy to extend with additional marketing platforms or custom metrics Perfect for marketing teams, agencies, and business owners who want to stay on top of their marketing performance with minimal manual work.
by Avkash Kakdiya
How it works This workflow captures webinar feedback through a webhook and normalizes the submitted data for processing. It stores raw feedback in Google Sheets, uses an AI model to understand sentiment and intent, and generates a personalized response. A professional HTML thank-you email is sent automatically to each attendee. All replies and delivery details are logged back into the spreadsheet for tracking. Step-by-step Receive webinar feedback** Feedback Webhook – Accepts feedback submissions from a webinar form in real time. ID Generation – Creates a human-readable, unique feedback ID for tracking. Normalize Feedback – Cleans and standardizes incoming fields like name, email, rating, and comments. Store and enrich feedback** Store Partial – Saves the raw feedback data into Google Sheets. Common Resources – Attaches shared webinar resources such as recordings and slides. Analyze feedback with AI** Message a model – Evaluates sentiment, engagement level, and intent using an AI model. Parse AI Response – Extracts structured insights like segment, reply text, and next steps. Generate and send follow-up** Merge – Combines feedback data, AI response, and resources. Build Email HTML – Creates a clean, professional HTML email tailored to each attendee. Send AI Thank You Email – Sends the personalized follow-up via Gmail. Log final outcome** Store Feedback – Updates Google Sheets with the sent email content, timestamp, and status. Why use this? Save time by automating webinar feedback follow-ups end to end. Ensure every attendee receives a thoughtful, personalized response. Maintain a complete feedback and communication log in one place. Improve engagement without sounding promotional or generic. Scale post-webinar communication without manual effort.
by WeblineIndia
Bitcoin Price Spike Detector with Gemini AI, NewsAPI & Gmail Alerts This workflow monitors Bitcoin price changes every 30 minutes. If the price increases or decreases by 3% or more, it fetches recent Bitcoin-related news, summarizes it using AI (Google Gemini) and sends an email alert explaining the likely reason behind the price movement. Quick Implementation Steps Set up a Schedule Trigger (default: every 30 minutes) in your n8n account. Configure CoinGecko API (already public, no key required). Ensure your Data Table (crypto_price_db) exists. Add your NewsAPI API key in HTTP Request node. Configure Google Gemini API credentials. Connect your Gmail account. Replace the email recipient with your own. Activate the workflow. What It Does This workflow continuously monitors Bitcoin price fluctuations by fetching the latest price from CoinGecko at regular intervals. Each new price is stored in a data table and compared with previous entries to detect significant changes. When a price movement of ±3% or more is detected, the workflow automatically triggers a secondary process. It fetches recent Bitcoin-related news articles using NewsAPI, filters and aggregates relevant descriptions and sends them to an AI agent powered by Google Gemini. The AI agent generates a concise summary of the news and explains the likely reason behind the price movement. Finally, it sends a well-crafted email alert with insights, helping users stay informed and react quickly to market changes. Who It's For Crypto traders and investors Financial analysts monitoring Bitcoin trends Automation enthusiasts using n8n Developers building AI-powered alert systems Anyone who wants real-time insights on Bitcoin price movements Requirements To use this workflow, you need: n8n account (self-hosted or cloud) Existing Data Table (crypto_price_db) NewsAPI account & API key** https://newsapi.org/ Google Gemini API key** https://aistudio.google.com/welcome Gmail account** connected via OAuth2 Internet access for API calls How It Works & Set Up 1. Schedule Trigger Node: Execute at every 30 minutes Runs the workflow at regular intervals. You can modify this interval as needed. 2. Fetch Bitcoin Price Node: Fetch BitCoin Price API: CoinGecko Endpoint: https://api.coingecko.com/api/v3/simple/price Query: ids=bitcoin vs_currencies=usd 3. Store Price in Data Table Node: Add bitcoin price to sheet Stores the latest price in crypto_price_db. 4. Retrieve Recent Prices Nodes: Get all prices from sheet** Get last two prices from sheet** Keeps only the latest two entries for comparison. 5. Prepare Data Node: Edit Fields Ensures the price field is properly formatted. 6. Detect Price Change 📈 Price Increase (≥ 3%) Node: If new price is increased by 3% Condition compares latest vs previous price. 📉 Price Decrease (≥ 3%) Node: If new price is dropped by 3% 7. Fetch News Nodes: Fetch news about bitcoin** Fetch news about bitcoin1** API: NewsAPI Query: q=bitcoin Setup NewsAPI Create account at https://newsapi.org/ Generate API key Add it in HTTP Request node → Headers 8. Filter & Aggregate News Nodes: Filter all news** Aggregate filtered news** Extracts only article descriptions and combines them. 9. AI Processing (Google Gemini) Nodes: AI Agent** Google Gemini Chat Model** Setup Gemini API Go to https://aistudio.google.com/welcome Generate API key Add credentials in n8n: Type: Google PaLM / Gemini Paste API key AI Task: Summarize news Explain price movement Generate email subject & content 10. Send Email Alert Nodes: Send a message in Gmail** Sends AI-generated email. Important: Replace: errorcommits@mailinator.com with your own email address. How To Customize Nodes Change Price Threshold** Modify IF node conditions (e.g., 5% instead of 3%) Change Cryptocurrency** Update CoinGecko ids parameter Modify Email Content** Adjust AI prompt inside AI Agent nodes Adjust Frequency** Change Schedule Trigger interval News Filtering** Modify Code node to include titles, sources or keywords Add-Ons (Enhancements) Add Slack / Telegram alerts Store historical data in Google Sheets or database Add support for multiple cryptocurrencies Create a dashboard using n8n + external tools Add sentiment analysis on news Trigger trading bots or alerts Use Case Examples Crypto Trading Alerts Get instant insights when Bitcoin price moves significantly. Market Analysis Automation Automatically correlate price changes with real-world news. Portfolio Monitoring Track assets and receive alerts without manual checks. AI-Powered Financial Reports Generate automated summaries for decision-making. Research & Insights Tool Understand market sentiment quickly. And many more use cases can be built on top of this workflow. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|---------| | No email received | Gmail not configured | Reconnect Gmail OAuth2 credentials | | No news data | Missing NewsAPI key | Add API key in HTTP Request headers | | AI not responding | Gemini API not configured | Verify Gemini credentials | | Workflow not triggering | Schedule not active | Activate workflow | | Incorrect price comparison | Data table missing values | Ensure table stores numeric USD values | | Empty email content | News descriptions missing | Check Code node output | Need Help? If you need assistance setting up this workflow, customizing it or extending it with advanced features like multi-crypto tracking, dashboards or AI enhancements — we’re here to help. Contact WeblineIndia for: Workflow setup & deployment Custom automation solutions AI-powered business workflows Add-on feature development Let us help you turn automation into a competitive advantage.
by WeblineIndia
Client Portfolio News Impact Detection with AI & Gmail This workflow automatically fetches the latest business news, analyzes its impact on clients using AI and sends alerts for high-impact articles while logging all processed data in Google Sheets. It ensures no duplicate processing using URL normalization and maintains a complete audit trail. Quick Implementation Steps Add your News API key in the HTTP Request node in your n8n account. Connect Google Sheets (Client Dataset + Article Log). Configure Gemini AI credentials. Set up Gmail node for alerts. Activate the workflow (runs daily at 8 AM). What It Does This workflow continuously monitors business news and evaluates its relevance to a predefined client dataset. It fetches the latest articles, validates them and ensures that only new articles are processed by comparing normalized URLs against previously logged entries. Each article is enriched with structured client data and sent to an AI model for classification. The AI determines the impact level (High, Medium, Low) and identifies which clients are affected along with precise reasoning. High-impact articles trigger automated email alerts, ensuring timely communication. All articles—regardless of impact—are logged in a Google Sheet along with metadata such as processing time, impact level, affected clients and email status. Who It's For Financial advisors and wealth managers Investment research teams Portfolio managers Risk analysis professionals Businesses tracking market impact on clients Requirements n8n account (Cloud or Self-hosted) News API key (newsapi.org) Google Sheets account (2 sheets required) Client Dataset Article Processing Log Google Gemini API credentials Gmail account (for sending alerts) How It Works & Setup Step 1: Trigger Setup Configure the Schedule Trigger to run daily at 8 AM. Step 2: News API Configuration Add your API key in the Fetch Latest Finance News node. Ensure category is set to business. Step 3: Google Sheets Setup Sheet 1: Client Dataset Must include fields like Client Name, Holdings, Sector Exposure, etc. Sheet 2: Article Processing Log Stores processed articles with status and timestamps. Step 4: Client Data Preparation The workflow converts raw sheet data into structured arrays for AI processing. Step 5: Deduplication Logic Previously processed article URLs are normalized and stored. New articles are compared against this list to avoid duplicates. Step 6: AI Configuration Configure Google Gemini (gemini-2.5-flash) credentials. Ensure JSON output format is enabled. Step 7: Email Setup Configure Gmail node with recipient email. Step 8: Workflow Execution Flow Fetch news articles Validate and split articles Process one article at a time Check for duplicates Attach client dataset Send to AI for classification Filter high-impact results Send email alerts (if high impact) Log all articles Wait 1 minute before next article How To Customize Nodes News API Node**: Change category or add keywords AI Prompt**: Modify classification rules or output structure Filter Node**: Adjust logic (e.g., include Medium impact) Email Node**: Customize email format or recipients Google Sheets**: Add more client attributes for deeper analysis Add-ons Slack or WhatsApp alerts instead of email Dashboard visualization (Google Data Studio / Power BI) Multi-language news support Sentiment analysis layer Priority scoring for clients Use Case Examples Alerting financial advisors about market-moving news Monitoring sector-specific risks for portfolios Identifying geopolitical risks affecting investments Automating daily research summaries Tracking impact of global events on client portfolios There can be many more use cases depending on how the workflow is extended. Troubleshooting Guide | Issue | Possible Cause | Solution | | ---------------------------- | -------------------------- | --------------------------- | | No articles fetched | Invalid API key | Verify News API key | | Workflow stops early | Empty articles array | Check API response | | Duplicate articles processed | URL normalization mismatch | Verify normalization logic | | AI output error | Invalid JSON response | Ensure strict JSON prompt | | Emails not sent | Gmail not configured | Reconnect Gmail credentials | | Clients not mapped | Incorrect sheet structure | Validate column names | Need Help? If you need assistance setting up this workflow, customizing it for your business or adding advanced features, feel free to reach out to our n8n automation developers at WeblineIndia. We can help you: Deploy and configure n8n workflows Customize AI-based automation Integrate additional tools and APIs Build scalable automation systems tailored to your needs Contact WeblineIndia to accelerate your automation journey.
by MANISH KUMAR
Shopify Product-to-Blog Automation with Perplexity web search, Gemini AI Agent & Google Sheets Shopify Blog Automation (From Shopify product to SEO-optimized blog post — fully automated) This workflow is an advanced n8n-powered automation that transforms newly created Shopify products into professionally written, SEO-ready blog posts using AI. By combining **Shopify Webhooks, Google Sheets, AI research, structured content generation, and automated HTML formatting**, this workflow removes all manual work from product-based content marketing. 💡 Key Advantages This Shopify Product-to-Blog Automation delivers the following benefits: 🛍️ Shopify Product Sync Automatically captures new product data (title, description, vendor, type, images) the moment a product is created. 🧠 AI-Powered Research & Writing Uses AI to perform market analysis, identify customer intent, and generate structured, high-quality blog content. 📊 Google Sheets Tracking Maintains a clear audit trail of products, generated blogs, and publishing status to prevent duplication. 🧩 Structured Content Output Generates strict JSON-based blog sections (problem, solution, features, usage, comparison, CTA) for consistency and scalability. 📤 End-to-End Automation Handles everything — from product detection to blog publishing — with zero manual writing. ⚙️ How It Works Step-by-Step Process Shopify Trigger Listens for products/create events in Shopify. Product Data Extraction Normalizes product fields and selects the primary product image. Google Sheets Storage Stores raw product data and sets initial processing status. AI Market & SEO Research Analyzes product intent, audience, use cases, FAQs, and keyword opportunities. AI Blog Content Generation Creates structured, SEO-focused blog content using a LangChain AI agent. HTML Structuring Cleans, escapes, and formats content into Shopify-safe, responsive HTML. Shopify Blog Publishing Automatically posts the article to the Shopify Blog via Admin API. Status Update & Tracking Updates Google Sheets to reflect successful blog publication. 🛠️ Setup Steps Required Node Configuration To run this workflow, configure the following nodes: Shopify Trigger** – Detect new product creation Set Node** – Normalize Shopify product fields Google Sheets Nodes** – Store and track workflow state AI Research Node** – Market & SEO analysis LangChain / Gemini Agent** – Blog content generation Code Node** – HTML formatting and safety handling HTTP Request Node** – Publish blog post to Shopify Error Handling Logic** – Retry and fail-safe routing 🔐 Credentials Required Before enabling the workflow, configure these credentials: Shopify Admin API Access Token** – For blog publishing Google Sheets OAuth** – For data tracking Google Gemini API Key** – For AI content generation Perplexity API Key** – For research and SEO insights 👤 Ideal For This automation is ideal for: Shopify store owners using content marketing Ecommerce teams managing large product catalogs SEO teams scaling product-driven blog content Agencies offering automated Shopify SEO solutions 💬 Bonus Tip This workflow is fully modular and extensible. You can easily enhance it to: Auto-link blogs to products Generate multilingual blog posts Schedule delayed publishing Route content by product category Add internal linking or schema markup All extensions can be implemented within the same n8n workflow. ✅ Result Every new Shopify product automatically becomes: Research-backed SEO-optimized Professionally structured Automatically published No manual writing. No copy-paste. Fully automated. Keywords shopify ai shopify automation shopify marketing automation shopify blog automation shopify content automation ai blog generator shopify shopify seo automation ecommerce automation ai ecommerce automation shopify workflow automation shopify product to blog auto generate shopify blogs shopify ai content how to automate shopify
by OwenLee
🤯 Problem of Traditional Bookkeeping 🔀 Context switch kills the habit: Because bookkeeping lives outside the apps you use every day, you postpone it → forget to log. 🧱 High input friction: You’re forced to fill rigid fields (amount/category/date/notes…), which is slow and discouraging for quick capture. 🎙️💸 Weak or pricey natural-language options: A few tools support voice/chat, but they’re often expensive, and the experience is hit-or-miss. 🔒📦 Limited data ownership: Records live on third-party servers, so privacy and control are diluted. 📲 How This Workflow Fixes It 💬 Put the capture back where you already are: Log expenses directly inside Telegram (or other channels) in a familiar chat—no new app to learn. ⚡ Ultra-low-friction, unstructured input: Send text, a voice note, or a receipt photo—the flow extracts amount · item · date, supports multiple languages and relative dates, and can split multiple expenses from one message. 🗂️📝 Your data, your sheet: Final records are written to your own Google Sheet (columnar fields or a JSON column). You keep full control. 🔗 Demo Google Sheet: click me 👥 Who Is This For 😤 Anyone fed up with traditional bookkeeping but curious about an AI-assisted, chat-based way to log expenses. 🤖 People who tried AI bookkeeping apps but found them pricey, inflexible, or clunky. 💵 Bookkeeping beginners who want frictionless capture first, simple review and categorize later. 🧩 How It Works 💬 Captures expenses from Telegram (text, voice note, or receipt photo). 🔎 Normalizes inputs into raw text (uses Gemini to transcribe voice and extract text from images). 🧠 Parses amount · item · date with an LLM expense parser. 📊 Appends tidy rows to Google Sheets. 🔔 Sends a Telegram confirmation summarizing exactly what was recorded. 🛠️ How to Set Up 1) 🔑 Connect credentials (once) TELEGRAM_BOT_TOKEN LLM_API_KEY GOOGLE_SHEETS_OAUTH 2) 🚀 Quick Start Setup:* Create a Google Sheet to store *Log Expense** data and configure it in n8n. Telegram:* Fill in and verify the *Telegram chatId**. Remember enable the workflow!* 🧰 How to Customize the Workflow 📝 Other user interaction channels: Add Gmail, Slack, or a website Webhook to accept email/command/form submissions that map into the same parser. 🌍 Currency: Extract and store currency in its own column (e.g., MYR, USD); keep amount numeric only (no symbols). 🔎 Higher-accuracy OCR / STT to reduce errors 📩 Help Contact: owenlzyxg@gmail.com
by Manav Desai
This n8n template demonstrates how to build a weekly Hollywood film industry briefing using Tavily for real-time search and Google Gemini for summarization. It sends a concise, emoji‑styled email with movie releases, box office results, industry news, and must‑watch recommendations every week automatically. Use cases: Great for film journalists, entertainment bloggers, or movie enthusiasts who want automated weekly updates without manually checking multiple sources. Good to know Free to use: Tavily provides **1,000 API credits per month on their free plan (no credit card required), so this workflow can run at zero cost. Real-time data**: Tavily’s search API is optimized for up-to-date information — perfect for weekly movie releases and box office stats. Google Gemini is used for summarization, and you only need basic API access (no paid tier required). How it works Trigger**: Scheduled every Thursday morning (configurable). Search**: Four Tavily API calls gather: Movies releasing this week Last week’s box office results Hollywood industry news Must‑watch movies currently in theatres Summarization**: Google Gemini turns this into Gmail‑friendly HTML with emojis and bullet points. Email**: The formatted newsletter is sent via Gmail node. How to use Configure Tavily API and Gmail OAuth2 credentials in n8n’s credential manager. (Optional) Edit Tavily queries to focus on specific genres or add filters. Adjust the schedule trigger to any day/time you prefer. Requirements Tavily API account (free plan – 1,000 monthly requests) Google Gemini API key for summarization Gmail account (OAuth2 credentials for sending emails) Want insane output quality? You can swap Gemini for OpenAI’s ChatGPT models: GPT‑3.5 Turbo** – \~\$0.002/run (crazy cheap) GPT‑4o** – \~\$0.009/run (latte price) GPT‑4.5** – \~\$0.15/run (god‑mode quality) This upgrade gives you cleaner, richer, “did‑a‑human‑write‑this?” vibes — perfect for journalist‑grade Hollywood briefings. Just note: OpenAI API requires a \$5 minimum credit to activate usage. Example Output (ChatGPT version) Subject: Daily Hollywood Film Industry Briefing – August 3, 2025 Good morning, Here's your daily Hollywood film briefing for August 3, 2025: 🎬 Releases The Bad Guys 2 – Released Friday, August 1, 2025 The Naked Gun – Released Friday, August 1, 2025 These are the confirmed new wide theatrical Hollywood releases this week (Monday through Sunday of current week). No additional new Hollywood theatrical releases found for this week. 📊 Box Office Highest‑grossing Hollywood films of 2025 (worldwide): Ne Zha 2 – approx. \$1.90 billion (non‑Hollywood Chinese animated film leads) Lilo & Stitch – approx. \$1.02 billion A Minecraft Movie – approx. \$955 million Jurassic World Rebirth – approx. \$731 million How to Train Your Dragon – approx. \$610 million Last week’s box office performance (Monday–Sunday): The Fantastic Four: First Steps – domestic debut \\$118 M; global \\$218 M, Marvel’s biggest opening of 2025 Superman – added \~\$94 M worldwide last week, passing \$500 M global total Jurassic World Rebirth – up \\$70 M worldwide last week, despite \40 % drop week‑on‑week F1: The Movie – up \~\$48 M last week internationally/domestically growth visible Lilo & Stitch – added \~\$10 M worldwide last week, slower tail but still billion‑plus gross Highlights & trends: Fantastic Four’s strong debut reboots Marvel success, signaling resumed audience interest; Superman continues to hold strong; Jurassic World Rebirth remains durable after holiday surge; surge in box office recovery noted across key titles. Overall box office up \~12–15 % year‑on‑year. 📰 Industry Buzz Christopher Nolan has signed to direct a massive \$250 million adaptation of Homer’s The Odyssey, starring Matt Damon and Tom Holland, with Imax pre‑sales at 95 % capacity across major locations. Marvel has relaunched the Fantastic Four franchise successfully with First Steps; positive CinemaScore and strong visuals marking a fresh start. DC’s Superman continues strong with over \$500 M global, solidifying DC’s summer comeback. Universal’s Jurassic World Rebirth continues strong overseas, especially in China, contributing to \$318 M global in opening holiday weekend. Warner Bros.–Discovery stock surges (\~30 %) amid box office rebound, with Disney, IMAX and Cinemark also seeing robust growth in 2025. Ne Zha 2 becomes highest‑grossing animated and non‑Hollywood film ever, crossing \$2 billion globally—though not Hollywood, its impact on global trends is notable. Mission: Impossible – The Final Reckoning quietly solidifies strong global numbers (\~\$562 M) and continues reliable franchise performance. 🎥 Must‑Watch in Theatres (Surat, India) The Fantastic Four: First Steps** – Currently showing in English/Hindi/Tamil/Telugu in Surat cinemas; hyped globally, strong visuals, action‑heavy, best experienced in IMAX or premium formats if available in Surat multiplexes. Runs this week. F1: The Movie** – Available in Surat in multiple languages, strong reviews praising adrenaline‑fuelled direction and visuals and growing fan hype; ideal in standard or Dolby formats for immersive sound and speed feel. Jurassic World Rebirth** – Still playing in Surat, popular with family audiences; grand visuals and dinosaur action well‑suited to IMAX or large format screens. That’s all for today’s briefing. Have a great theatrical weekend ahead!
by Rajeet Nair
Overview This workflow transforms raw support tickets into actionable developer insights using AI and data processing. It automatically detects recurring issues, identifies root causes, ranks severity, and generates a structured engineering report. By combining embeddings, clustering, and AI analysis, it helps teams prioritize bugs, understand user pain points, and take data-driven product decisions. How It Works Scheduled Trigger Runs automatically at a defined time (e.g., daily). Workflow Configuration Defines time window, similarity threshold, scoring weights, and delivery options. Fetch Feedback Data Retrieves recent support tickets (bugs and feature requests) from Postgres. Preprocessing Cleans, normalizes, and removes duplicate messages. Embedding & Clustering Generates embeddings using OpenAI. Groups similar tickets using cosine similarity. Cluster Aggregation Combines related tickets into structured clusters. Root Cause Analysis AI agent analyzes clusters to identify: Root cause Impacted module Severity Debug steps Fix direction Severity Scoring Calculates weighted score based on: Frequency Sentiment Churn risk Enterprise impact Report Generation Generates a developer-focused report including: Executive summary Ranked bugs Feature requests Risk analysis Sprint priorities Delivery Sends report to Slack Optionally creates Jira issues Optional email delivery Setup Instructions Database Setup Configure Postgres credentials Ensure support_tickets table exists with required fields OpenAI Configuration Add API key for: Embeddings (text-embedding-3-small) AI analysis agents Slack Integration Add Slack credentials Set channel ID Email Setup (Optional) Configure SMTP or email service Jira Integration (Optional) Add Jira credentials Set project key and issue type Customize Parameters Adjust: Similarity threshold Scoring weights Time window Schedule Configuration Modify trigger timing as needed Use Cases Product teams analyzing user feedback at scale Engineering teams prioritizing bug fixes SaaS companies tracking churn-related issues Customer support insights automation AI-driven product intelligence dashboards Requirements OpenAI API key Postgres database with support ticket data Slack (optional) Email service (optional) Jira account (optional) n8n instance Key Features Automated feedback clustering using embeddings AI-driven root cause analysis Weighted severity scoring system Developer-ready intelligence reports Multi-channel delivery (Slack, Email, Jira) Fully customizable scoring and thresholds Summary A powerful AI-driven workflow that converts raw support tickets into structured developer intelligence. It automates clustering, root cause detection, prioritization, and reporting helping teams fix the right problems faster and build better products.
by Oneclick AI Squad
This enterprise-grade n8n workflow automates influencer contract compliance for Instagram campaigns — from deadline tracking to breach detection — using Claude AI, Instagram API, and smart reminders. It ensures timely deliverables by monitoring posts, sending proactive alerts, and escalating breaches, all with zero manual oversight. Key Features Daily contract scanning** from Google Sheets Deadline calculations** for approaching or passed dates Automated reminders** via Slack for nearing deadlines Post verification* using Instagram API and *Claude 3.5 Sonnet** for hashtag/description matching Breach detection engine** identifies non-compliant influencers Escalation notifications** to managers on breaches Audit logs** stored in Google Sheets for compliance records Scalable triggers:** Daily schedule or webhook for new contracts Workflow Process | Step | Node | Description | | ---- | ----------------------------------- | -------------------------------------------------------- | | 1 | Schedule Trigger | Runs daily at 9 AM or via webhook (/influencer-compliance) | | 2 | Get Contracts | Loads influencer contracts from Contracts sheet | | 3 | Loop Over Contracts | Processes each contract individually | | 4 | Calculate Deadline Status | Computes days to deadline, flags approaching/passed | | 5 | IF Approaching Deadline | Branches if within 3 days | | 6 | Send Reminder (Slack) | Notifies influencer/team of upcoming deadline | | 7 | IF Deadline Passed | Branches if deadline has passed | | 8 | Get Influencer Posts | Fetches recent posts from influencer's Instagram | | 9 | Check Post Compliance (Claude AI) | Uses AI to verify if post matches contract requirements | | 10 | IF Breach Detected | Branches if non-compliant | | 11 | Notify Breach (Slack) | Alerts manager of contract breach | | 12 | Log Breach | Records breach details in Logs sheet | | 13 | End (Compliant Path) | Terminates compliant branches | Setup Instructions 1. Import Workflow Open n8n → Workflows → Import from Clipboard Paste the JSON workflow 2. Configure Credentials | Integration | Details | | ----------------- | -------------------------------------------------- | | Google Sheets | Service account with spreadsheet access | | Instagram API | Business access token for fetching media | | Claude AI | Anthropic API key for claude-3-5-sonnet-20241022 | | Slack | Webhook or OAuth app | 3. Update Spreadsheet IDs Ensure your Google Sheets include: Contracts Logs 4. Set Triggers Webhook:** /webhook/influencer-compliance (for real-time updates) Schedule:** Daily at 9:00 AM 5. Run a Test Use manual execution to confirm: Reminder and breach notifications Post compliance checks Log entries in sheet Google Sheets Structure Contracts | campaignId | influencerName | influencerUserId | deadline | requiredHashtag | campaignDescription | |------------|----------------|------------------|------------|-----------------|---------------------| | CAMP-001 | InfluencerX | 1234567890 | 2023-12-31 | #BrandPromo | Promote new product | Logs | campaignId | influencerName | action | timestamp | details | |------------|----------------|-----------------|--------------------|----------------------| | CAMP-001 | InfluencerX | Breach Detected | 2023-10-01T12:00:00Z | Failed to post by deadline | System Requirements | Requirement | Version/Access | | --------------------- | ---------------------------------------------- | | n8n | v1.50+ (AI and API integrations supported) | | Claude AI API | claude-3-5-sonnet-20241022 | | Instagram Graph API| Business account access token | | Google Sheets API | https://www.googleapis.com/auth/spreadsheets | | Slack Webhook | Required for notifications | Optional Enhancements Add email reminders to influencers directly Integrate Asana/Trello for task creation on breaches Use advanced AI prompts for deeper post analysis (e.g., sentiment) Connect Payment APIs (Stripe) to withhold payments on breaches Enable multi-platform checks (e.g., TikTok/YouTube) Add reporting dashboard via Google Data Studio Implement auto-contract updates from CRM systems Result: A single automated system that tracks, reminds, and enforces influencer deliverables — with full AI verification and zero manual work. Get in touch with us for custom n8n automation!
by Anatoly
AI-Powered Voice Appointment Booking with ElevenLabs Transform your appointment scheduling with this production-ready workflow that connects ElevenLabs voice AI to your Google Calendar. Patients can call and book appointments naturally through conversation, while the system handles real-time availability checking, calendar management, and automated confirmations—completely hands-free. 🎯 What It Does: Voice-Activated Booking: Patients speak naturally to book appointments via ElevenLabs AI agent Real-Time Availability: Instantly checks calendar conflicts and returns available time slots Smart Scheduling: Automatically generates available 30-minute slots across business hours for the next 30 days Calendar Sync: Creates Google Calendar events with all appointment details, locations, and attendees Email Confirmations: Sends personalized HTML confirmation emails with appointment details and preparation instructions Dual Functionality: Handles both "check availability" queries and "book appointment" requests through a single webhook 💼 Perfect For: Medical/dental clinics • Beauty salons • Spas • Consulting services • Legal offices • Fitness studios • Therapy practices • Any appointment-based business seeking 24/7 automated scheduling Real conversation example: Voice version: https://drive.google.com/file/d/1CjhyjICTtLioA737SOkpbgcdLdUpVCr3/view Text version: ++AI Voice Assistant++ (00:00) Hello, I'm Ella from Evergreen Clinic. How can I assist you today? ++Patient++ (00:05) Hello Ella, I wanted to book an appointment for Botox treatment. ++AI Voice Assistant++ (00:11) I'd be happy to help you schedule a Botox appointment. Our Botox treatments take about 20 minutes and are performed by Dr. Sava or our nurse injector Sarah. Would you prefer our Zurich or Bern location? ++Patient++ (00:24) I prefer Zurich. ++AI Voice Assistant++ (00:28) great Zurich it is. Do you have a specific date in mind for your Botox appointment? ++Patient++ (00:32) Yeah, October the 7th and let's say 5 p.m. ++AI Voice Assistant++ (00:47) I have the 5 p.m. slot available on October 7th in Zurich. May I have your first name to proceed with the booking? ++Patient++ (00:54) Yes, my first name Anatoly, surname Sava. ++AI Voice Assistant++ (01:02) Thank you, Anatoly Sava. Could you please provide your email address for the appointment confirmation? Please spell it out slowly. ++Patient++ (01:08) [Your Email] ++AI Voice Assistant++ (01:19) Thank you. Just to confirm, your email is [Your Email] correct? ++Patient++ (01:29) Yes. ++AI Voice Assistant++ (01:34) Perfect. Lastly, may I have your phone number to complete the booking? ++Patient++ (01:39) My phone number is [Your Number] ++AI Voice Assistant++ (01:51) Thank you for the details, Anatoly. I will now book your Botox appointment in Zurich on October 7th at 5 p.m. Perfect. I've booked your Botox appointment at our Zurich clinic on October 7th at 5 p.m. A confirmation email will be sent to [Your Email]. Thank you for choosing Evergreen Clinic. If you have any questions before your appointment, please don't hesitate to call us back. Have a wonderful day. ++Patient++ (02:19) Perfect. You too. ++AI Voice Assistant++ (02:22) Thank you, take care and have a great day ahead. 🔧 Technical Features: Intelligent routing logic distinguishes between availability checks and booking requests Custom JavaScript algorithm calculates conflict-free time slots Timezone-aware date/time handling (customizable for any timezone) Configurable business hours, appointment duration, and look-ahead period Natural language date formatting for voice responses Webhook-based architecture for seamless ElevenLabs integration 📋 Requirements: ElevenLabs account (for voice agent) Google Calendar Gmail address for confirmations ⚡ Quick Setup: Step 1: n8n Configuration Connect your Google Calendar, customize business hours in the code node, update clinic details in the email template. Includes pinned test data for easy testing before going live. Step 2: ElevenLabs Agent Setup 1) Create a new Conversational AI Italicagent in ElevenLabs 2) Configure two tools into ElevenLabs with webhook URL pointing to this workflow: check_availability(date, time, appointmentType, location) book_appointment(fullName, email, phone, date, time, appointmentType, location) Create a detailed system prompt defining your agent's identity, personality, tone of voice, and conversation behavior This is a chunk of a system prompt (the full version is too long): IDENTITY You are Ella, an appointment scheduling voice assistant for Evergreen Clinic, which specializes in plastic surgery procedures. Your primary purpose is to efficiently schedule, confirm, reschedule, or cancel appointments while providing accurate information about services from your knowledge files only. VOICE & STYLE Use a friendly, professional yet warm tone suitable for a plastic surgery clinic Keep all your responses short and simple. Use casual language, phrases like "Umm..", "Well...", and "I mean" are preferred. NEVER interrupt a patient if they start talking This is a voice conversation, so keep your responses short, like in a real conversation. Don't ramble for too long. Keep responses concise (8-15 words per sentence ideal) Use natural speech patterns with occasional phrases like "I understand" and "Of course..." Insert brief pauses between information chunks to sound natural Show empathy and sensitivity appropriate for plastic surgery clients Never rush the caller, but keep the conversation focused Maintain a reassuring tone when discussing procedures Zürich — pronounce /ˈtsyːʁɪç/. In plain terms: start with “ts”, the ü is like French u in tu (rounded front, not “oo”), stress the first syllable, and the final “ch” is the soft German sound as in ich (not “k”). Avoid saying “ZOO-rich.” Bern — pronounce /bɛrn/. Short e like in bet, single r (not American “urn”), no extra vowel at the end. Avoid saying “BURN.” Full ElevenLabs set up guide: https://youtu.be/kbiWe93nFMk?si=_bQYIoq1cjXKO5kl 🎁 What You Get: Complete end-to-end automation with detailed sticky note documentation, live conversation example, video tutorial, system prompt template, customization guides, troubleshooting tips, and security best practices.
by Nguyen Thieu Toan
How it works 🧠 AI-Powered News Update Bot for Zalo using Gemini and RSS Feeds This workflow allows you to build a smart Zalo chatbot that automatically summarizes and delivers the latest news using Google Gemini and RSS feeds. It’s perfect for keeping users informed with AI-curated updates directly inside Vietnam’s most popular messaging app. 🚀 What It Does Receives user messages via Zalo Bot webhook Fetches the latest articles from an RSS feed (e.g., AI news) Summarizes the content using Google Gemini Formats the response and sends it back to the user on Zalo 📱 What Is Zalo? Zalo is Vietnam’s leading instant messaging app, with over 78 million monthly active users—more than 85% of the country’s internet-connected population. It handles 2 billion messages per day and is deeply embedded in Vietnamese daily life, making it a powerful channel for communication and automation. 🔧 Setup Instructions 1. Create a Zalo Bot Open the Zalo app and search for "Zalo Bot Creator" Tap "Create Zalo Bot Account" Your bot name must start with "Bot" (e.g., Bot AI News) After creation, Zalo will send you a message containing your Bot Token 2. Configure the Webhook Replace [your-webhook URL] in Zalo Bot Creator with your n8n webhook URL Use the Webhook node in this workflow to receive incoming messages 3. Set Up Gemini Add your Gemini API key to the HTTP Request node labeled Summarize AI News Customize the prompt if you want a different tone or summary style 4. Customize RSS Feed Replace the default RSS URL with your preferred news source You can use any feed that provides timely updates (e.g., tech, finance, health) 🧪 Example Interaction User: "What's new today?" Bot: "🧠 AI Update: Google launches Gemini 2 with multimodal capabilities, revolutionizing how models understand text, image, and code..." ⚠️ Notes Zalo Bots currently do not support images, voice, or file attachments Make sure your Gemini API key has access to the model you're calling RSS feeds should be publicly accessible and well-formatted 🧩 Nodes Used Webhook HTTP Request (Gemini) RSS Feed Read Set & Format Zalo Message Sender (via API) 💡 Tips You can swap Gemini with GPT-4 or Claude by adjusting the API call Add filters to the RSS node to only include articles with specific keywords Use the Function node to personalize responses based on user history Built by Nguyen Thieu Toan (Nguyễn Thiệu Toàn) (https://nguyenthieutoan.com). Read more about this workflow by Vietnamese: https://nguyenthieutoan.com/share-workflow-n8n-zalo-bot-cap-nhat-tin-tuc/
by Oneclick AI Squad
This workflow evaluates website or app screenshots against established UX best practices (Nielsen's 10 Heuristics, WCAG accessibility guidelines, and mobile usability standards) and delivers prioritized, actionable improvement suggestions with severity ratings. Who's it for • UX designers seeking automated design audits • Product managers reviewing UI quality pre-launch • Agencies conducting client UX audits at scale • Developers wanting accessibility compliance checks • Startups running lean without a dedicated UX team How it works / What it does Accepts screenshot(s) via webhook upload crawl Classifies the UI type (web app, mobile, landing page, dashboard, e-commerce) Encodes image and sends to vision AI for heuristic analysis Evaluates against 10 Nielsen heuristics + WCAG + mobile standards Scores each heuristic category (0–10) and calculates overall UX score Generates prioritized, actionable improvement suggestions per finding Delivers a structured report via email and logs results to Google Sheets How to set up Import this workflow Configure credentials (OpenAI with vision, SendGrid, Google Sheets) Set your brand/product context in the Set UX Config node Activate and submit screenshots via the webhook endpoint Requirements • OpenAI API key with GPT-4 Vision access • Google Sheets (for audit log) • SendGrid or Gmail (for report delivery) • Screenshot files (PNG/JPG) or publicly accessible URLs How to customize the workflow • Add or remove heuristic categories in the AI prompt node • Adjust severity thresholds in the Set UX Config node • Extend the Google Sheet columns to include client or project metadata • Chain multiple screenshots for full-flow UX audits Want to improve productivity with a custom-built workflow? Our specialists can deliver it fast—Get in touch with our team