by Bakdaulet Abdikhan
Analyze Meta ads with Gemini and Google Sheets Stop manually exporting CSVs and start automating your marketing insights. This workflow is designed for Marketing Agencies, Freelancers, and Media Buyers who want to keep a daily pulse on their Meta (Facebook/Instagram) Ads performance without logging into Ads Manager. It doesn't just scrape data; it uses Google Gemini AI to act as a virtual data analyst. It reviews your campaigns, identifies winning/losing creatives, and writes strategic suggestions for both your agency team and your clients. 🚀 What this workflow does Extracts Data: Wakes up every morning (6:00 AM) to fetch yesterday's Ad and Campaign performance from the Facebook Graph API. Cleans & Filters: Automatically ignores paused or zero-spend campaigns to keep your reports clean. Structuring: Uses a Code node to group Ads intelligently under their respective Ad Sets and Campaigns. AI Analysis: Sends the structured data to Google Gemini. The AI analyzes CTR, CPC, and Spend to identify the "Best Performing Ad" and "Worst Performing Ad" per Ad Set. Reporting: Saves raw Campaign Data to Google Sheets. Saves raw Ad Data to Google Sheets. Saves AI-Generated Insights (Client & Agency suggestions) to a dedicated sheet. Error Handling: If anything breaks (e.g., API token expiry), it instantly sends you an alert via Gmail with the error details. 💡 Key Features Zero-Spend Filter:** Keeps your spreadsheet tidy by excluding inactive ads. Hierarchical Data Processing:** Groups data logically so the AI understands the context of your tests. Dual-Perspective Insights:** The AI generates two types of advice: For the Client: Simple, performance-based updates. For the Agency: Technical optimization tips (e.g., "Pause Ad B, Scale Ad A"). Robust Error Monitoring:** Includes a dedicated error workflow to notify you of failures. 🛠️ Prerequisites To use this template, you will need: Meta/Facebook Developer App:** A System User Access Token with ads_read permission. Google Cloud Console Project:** Enabled APIs for Google Sheets, Gmail, and Vertex AI (Gemini). Google Sheet:** A sheet with three tabs: Campaigns, Ads, and AI_Insights. 📝 Setup Instructions Configure Credentials: Connect your Facebook Graph API and Google accounts in n8n. Set Configuration Node: Open the "Set Configuration" node and paste your Ad Account ID and Email Address for error alerts. Link Google Sheet: Open the three Google Sheets nodes and select your spreadsheet file. Activate: Turn on the workflow and let it run daily! Need help setting this up or want a custom automation for your agency? I specialize in building agentic workflows for consultants and agencies. 📧 Contact me: bakdaulet.mph@gmail.com
by Avkash Kakdiya
How it works This workflow runs on a daily schedule to analyze all Closed–Lost deals from your CRM and uncover the true reason behind each loss. It uses AI to classify the primary loss category, generate a confidence-backed explanation, and then create a realistic re-engagement strategy for every deal. All insights are consolidated into leadership-ready email and Slack summaries. Every analyzed deal and revival plan is logged for long-term tracking and audits. Step-by-step Trigger and fetch lost deals** Schedule Trigger – Runs the workflow automatically at a defined time. Get many deals – Fetches all deal records from the CRM. If – Filters only deals marked as Closed–Lost. Edit Fields – Standardizes key deal attributes like amount, industry, owner, and loss reason. Analyze loss reasons and generate revival strategies** Brief Explanation Creator – Uses AI to identify the primary loss category with confidence. Code in JavaScript – Parses and normalizes AI loss analysis output. Merge – Combines deal data with loss insights. Feedback Creator – Generates a practical re-engagement strategy for each lost deal. Code in JavaScript7 – Parses and safeguards revival strategy outputs. Merge4 – Merges deal details, loss analysis, and revival strategy into one final dataset. Report, notify, and store results** Code in JavaScript11 – Builds a consolidated HTML summary email. Send a message4 – Sends the summary to stakeholders via email. Code in JavaScript12 – Creates a structured Slack summary. Send a message1 – Delivers insights to a Slack channel. Code in JavaScript10 – Reconstructs final data with delivery status. Append or update row in sheet – Logs all results into Google Sheets for audit and tracking. Why use this? Turns lost deals into actionable learning instead of static CRM records Gives sales teams clear, realistic re-engagement plans without manual analysis Provides leadership with concise, decision-ready summaries Creates a historical database of loss reasons and revival outcomes Improves pipeline recovery while enforcing consistent sales intelligence
by Incrementors
Description Paste any YouTube, podcast, or Zoom URL into a simple form along with your video title, niche, and target audience and the workflow handles the rest. WayinVideo transcribes the full video with speaker labels and timestamps, then GPT-4o-mini writes exactly 10 tweets — a hook, eight content insights each under 270 characters, and a call-to-action. All 10 tweets are saved to Google Sheets as drafts, and if you choose Auto Post, each tweet is published to Twitter/X in sequence and the sheet row is updated with the live tweet ID. Built for content creators, marketers, and thought leaders who want to repurpose long-form video into Twitter/X threads without watching or manually summarizing anything. What This Workflow Does Transcribes any video with speaker labels** — WayinVideo processes the full video and returns every spoken segment attributed to the correct speaker with timestamps Polls automatically until transcription is complete** — Waits 60 seconds then checks every 45 seconds until the transcript is ready, with no manual monitoring required Writes exactly 10 tweets in one GPT call** — A hook tweet, eight standalone content insights each under 270 characters, and a CTA tweet — all grounded in the actual transcript Assigns a unique thread ID to every run** — All 10 tweets share one thread ID in Google Sheets so you can filter and find the full thread at any time Saves all 10 tweets to Google Sheets as drafts** — Each tweet gets its own row with character count, tweet number, thread ID, and Draft status for review Auto-posts to Twitter/X on request** — If you choose Yes at form submission, each tweet is posted to your connected Twitter/X account in sequence Updates the sheet with live tweet IDs** — After each tweet is posted, the corresponding row Status changes from Draft to Posted and the live tweet ID is saved Setup Requirements Tools Needed n8n instance (self-hosted or cloud) WayinVideo account with API access OpenAI account with GPT-4o-mini API access Google Sheets (one sheet with a tab named Twitter Threads) Twitter/X developer account with OAuth2 and tweet.write scope Credentials Required WayinVideo API key (pasted into 2. WayinVideo — Submit Transcription and 4. WayinVideo — Get Transcript Results) OpenAI API key Google Sheets OAuth2 (used in 11. Google Sheets — Save Thread Draft and 14. Google Sheets — Update Status to Posted) Twitter/X OAuth2 credential > ⚠️ WayinVideo API key appears in 2 steps — replace YOUR_WAYINVIDEO_API_KEY in both 2. WayinVideo — Submit Transcription and 4. WayinVideo — Get Transcript Results. Missing either one will cause the workflow to fail. > ⚠️ Google Sheet ID appears in 2 steps — replace YOUR_GOOGLE_SHEET_ID in both 11. Google Sheets — Save Thread Draft and 14. Google Sheets — Update Status to Posted. Estimated Setup Time: 20–25 minutes Step-by-Step Setup Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import Get your WayinVideo API key — Log in to your WayinVideo account → go to Account Settings → copy your API key Add your WayinVideo API key to node 2 — Open node 2. WayinVideo — Submit Transcription → find the Authorization header value Bearer YOUR_WAYINVIDEO_API_KEY → replace YOUR_WAYINVIDEO_API_KEY with your actual key Add your WayinVideo API key to node 4 — Open node 4. WayinVideo — Get Transcript Results → find the same Authorization header → replace YOUR_WAYINVIDEO_API_KEY with the same key Connect OpenAI — Open node 9. OpenAI — GPT-4o-mini Model → click the credential dropdown → add your OpenAI API key → test the connection Create your Google Sheet tab — Open your Google Sheet → add a tab named exactly Twitter Threads → add these 8 column headers in row 1: Video Title, Video URL, Thread ID, Tweet Number, Tweet Text, Character Count, Generated On, Status Add a Tweet ID column too — In the same tab, add a 9th column header: Tweet ID — this is where live tweet IDs are written after posting Get your Google Sheet ID — Open your Google Sheet in a browser → copy the string between /d/ and /edit in the URL — this is your Sheet ID Connect Google Sheets for saving — Open node 11. Google Sheets — Save Thread Draft → click the document field → replace YOUR_GOOGLE_SHEET_ID by selecting your spreadsheet or entering the ID → click the credential dropdown → add Google Sheets OAuth2 → authorize access Connect Google Sheets for updating — Open node 14. Google Sheets — Update Status to Posted → repeat the same process — select your spreadsheet, replace YOUR_GOOGLE_SHEET_ID, and confirm the same Google Sheets OAuth2 credential is connected Connect Twitter/X — Open node 13. Twitter/X — Post Tweet → click the credential dropdown → add Twitter OAuth2 → complete the OAuth flow — make sure your Twitter app has tweet.write permission enabled in the Twitter Developer Portal Activate the workflow — Toggle the workflow to Active → copy the Form URL from node 1. Form — Video URL + Details → open it in a browser to submit your first video How It Works (Step by Step) Step 1 — Form: Video URL + Details You open the form URL in a browser and fill in five fields: the video URL (YouTube, Zoom, Vimeo, or any direct link), the video title, your niche or topic, target audience, and whether to auto-post to Twitter/X (type Yes or No). Submitting the form starts the workflow. Step 2 — HTTP: WayinVideo — Submit Transcription The video URL is sent to the WayinVideo transcription API with the target language set to English. WayinVideo accepts the job and returns a task ID confirming transcription has started. Step 3 — Wait: 60 Seconds The workflow pauses for 60 seconds before checking the transcription status for the first time, giving WayinVideo time to begin processing. Step 4 — HTTP: WayinVideo — Get Transcript Results A GET request checks the WayinVideo results endpoint using the task ID from step 2. It returns the current processing status and, once complete, the full speaker-labeled transcript. Step 5 — IF: Transcription Complete? This is the polling gate. If the status equals SUCCEEDED (YES path), the transcript is ready and the workflow moves forward to formatting. If still processing (NO path), the workflow routes to 6. Wait — 45 Seconds Retry which pauses 45 seconds then loops back to step 4 to check again. This repeats until SUCCEEDED. Step 6 — Wait: 45 Seconds Retry When the transcript is not yet ready, the workflow waits 45 seconds then returns to step 4 for another check. The loop continues automatically. Step 7 — Code: Format Transcript Each segment is formatted as [Speaker Name | MM:SS] text for clear, structured GPT input. Total video duration in minutes, word count, and unique speaker names are also calculated. All form inputs (video title, URL, niche, target audience, auto-post preference) are packaged here for the AI prompt. Step 8 — AI Agent: Write Twitter Thread GPT-4o-mini receives the formatted transcript as the user message and a detailed system prompt specifying ten strict Twitter rules. The rules enforce exactly 10 tweets, a hook that does not start with "I", 270-character limits per tweet, one standalone insight per content tweet, and a CTA for tweet 10. The output format uses labeled sections TWEET 1: through TWEET 10: so parsing is reliable. Step 9 — OpenAI: GPT-4o-mini Model This is the language model powering the thread writing. It runs with default settings for natural output. Step 10 — Code: Parse Tweets The AI output text is parsed using regex to extract each tweet from its labeled section. All 10 tweets are returned as individual rows, each carrying the tweet text, character count, tweet number, video title, video URL, a unique thread ID, auto-post preference, and Draft status. If zero tweets are extracted, the step throws a clear error. Step 11 — Google Sheets: Save Thread Draft Each of the 10 tweets is appended as one row to your Twitter Threads tab. All 8 columns are populated including the shared thread ID that groups the full thread together. Status is set to Draft for all rows. Step 12 — IF: Auto Post Enabled? After each tweet is saved, this check reads the autoPost value from the form. If it equals Yes (YES path — case-insensitive), the workflow moves to post the tweet on Twitter/X. If No or anything else (NO path), the workflow ends here — the tweet stays as a draft in your sheet. Step 13 — Twitter/X: Post Tweet The tweet text is posted to your connected Twitter/X account using the Twitter OAuth2 credential. Twitter returns the live tweet ID on success. Step 14 — Google Sheets: Update Status to Posted The sheet row matching this tweet's Thread ID and Tweet Number is updated. Status changes from Draft to Posted and the live tweet ID is saved to the Tweet ID column. This lookup uses both Thread ID and Tweet Number together to find the exact row. The final result is 10 logged rows in your Twitter Threads sheet — all Drafts if Auto Post was No, or all updated to Posted with live tweet IDs if Auto Post was Yes. Key Features ✅ Optional auto-posting at form submission — You decide at submission time whether to save as draft or post immediately — no separate workflow run needed ✅ Speaker-labeled transcript for context — WayinVideo attributes each sentence to the right speaker so GPT understands dialogue flow and can write tweets that reflect real insights from the conversation ✅ Ten strict Twitter rules enforced in the prompt — Character limits, hook structure, standalone tweet requirement, no invented facts, and CTA placement are all built into the system prompt — not left to chance ✅ Unique thread ID per run — Every set of 10 tweets shares one thread ID so you can filter your Google Sheets library by thread and find all 10 tweets together at any time ✅ Character count per tweet logged — The sheet records the character count for every tweet so you can spot any that approach the 270-character limit before posting ✅ Status updates from Draft to Posted automatically — When auto-posting, the sheet updates in real time as each tweet goes live — no manual tracking needed ✅ Retry loop with 45-second intervals — The workflow polls on a sensible schedule without hammering the WayinVideo API or timing out on longer videos Customisation Options Change the number of tweets per thread — In node 10. Code — Parse Tweets, change the loop from i <= 10 to a different number — and update the system prompt in node 8. AI Agent — Write Twitter Thread to request that same number of tweets, adjusting the OUTPUT FORMAT section to match. Add a retry limit to stop infinite polling — Before node 6. Wait — 45 Seconds Retry, add a Set step that increments a counter, then add a second IF check to stop after 15 polls and route to a Gmail or Slack error notification instead of looping indefinitely. Post threads as replies to each other — In node 13. Twitter/X — Post Tweet, add the previous tweet's ID as a reply_to_tweet_id parameter so tweets are chained as a proper threaded reply on Twitter/X rather than separate posts. Add a Slack notification when the thread is drafted — After node 11. Google Sheets — Save Thread Draft (only on tweet 10), add a Slack step that posts the video title, hook tweet, and a link to your Twitter Threads sheet so your team sees new threads without checking email. Schedule threads for a future time — Replace node 13. Twitter/X — Post Tweet with a scheduling step that saves tweets to a Buffer or Hypefury queue instead of posting immediately, so you can plan threads in advance without live posting. Troubleshooting WayinVideo returning an error on submission: Confirm YOUR_WAYINVIDEO_API_KEY in node 2. WayinVideo — Submit Transcription is replaced with your actual API key — not the placeholder Also confirm the same replacement was made in node 4. WayinVideo — Get Transcript Results — both steps need the key Check the execution log of node 2 for the raw error — a 401 means wrong key, a 422 means the URL format is unsupported Workflow stuck in the retry loop: Check that the video URL is publicly accessible — private, password-protected, or region-blocked videos will not be processed Open the execution log of node 4. WayinVideo — Get Transcript Results and inspect the raw response — WayinVideo may have returned a FAILED status with an error message If the loop runs indefinitely, deactivate the workflow, fix the video URL, and resubmit GPT not generating all 10 tweets: Confirm the API key is connected in node 9. OpenAI — GPT-4o-mini Model and your account has available credits Check the execution log of node 8. AI Agent — Write Twitter Thread for the raw output — if fewer than 10 labeled tweet sections are present, the regex in node 10 will only extract what is there If the issue is consistent, check that the system prompt in node 8 is intact and has not been accidentally edited Google Sheets not saving rows or updating status: Confirm YOUR_GOOGLE_SHEET_ID is replaced in both 11. Google Sheets — Save Thread Draft and 14. Google Sheets — Update Status to Posted — both need the same Sheet ID Confirm the tab is named Twitter Threads exactly and all column headers match Check that the Google Sheets OAuth2 credential is connected and not expired in both steps Twitter/X posting failing: Confirm the Twitter OAuth2 credential in node 13. Twitter/X — Post Tweet is connected and your app has tweet.write permission enabled in the Twitter Developer Portal Twitter rate limits allow 17 posts per 15 minutes on free tier — if your thread of 10 tweets posts too fast, Twitter may reject later tweets Check the execution log of node 13 for the exact Twitter API error response — a 403 usually means a permission scope issue Support Need help setting this up or want a custom version built for your team or agency? 📧 Email: info@incrementors.com 🌐 Website: https://www.incrementors.com/
by 荒城直也
Title: Create daily AI news digest and send to Telegram Description: Stay ahead of the rapidly evolving artificial intelligence landscape without the information overload. This workflow acts as your personal AI news editor, automatically curating, summarizing, and visualizing the top stories of the day, delivered directly to your Telegram. It goes beyond simple RSS aggregation by using an AI Agent to rewrite headlines and summaries into a digestible format and includes a "Chat Mode" where you can ask follow-up questions about the news directly within the n8n interface. Who is it for AI Enthusiasts & Researchers:** Keep up with the latest papers and releases without manually checking multiple sites. Tech Professionals:** Get a morning briefing on industry trends to start your day informed. Content Creators:** Find trending topics for newsletters or social media posts effortlessly. How it works News Aggregation: Every morning at 8:00 AM, the workflow fetches RSS feeds from top tech sources (Google News AI, The Verge, and TechCrunch). Smart Filtering: A Code node aggregates the articles, removes duplicates, and ranks them by recency to select the top 5 stories. AI Summarization: An AI Agent (powered by OpenAI) analyzes the selected stories and writes a concise, engaging summary for each. Visual Generation: DALL-E generates a unique, futuristic header image based on the day's news context. Delivery: The digest is formatted with Markdown and emojis, then sent to your specified Telegram chat. Interactive Chat: A separate branch allows you to chat with an AI Agent via the n8n Chat interface to discuss the news or ask general AI questions. How to set up Configure Credentials: Set up your OpenAI API credential. Set up your Telegram API credential. Get Telegram Chat ID: Create a bot with @BotFather on Telegram. Send a message to your bot. Use @userinfobot to find your numeric Chat ID. Update Workflow Settings: Open the Workflow Configuration node. Paste your Chat ID into the telegramChatId value field. Activate: Toggle the workflow to "Active" to enable the daily schedule. Requirements n8n Version:** Must support LangChain nodes. OpenAI Account:** API Key with access to GPT-4o-mini (or preferred model) and DALL-E 3. Telegram Account:** To create a bot and receive messages. How to customize Change News Sources:** Edit the RSS URLs in the Workflow Configuration node to track different topics (e.g., Crypto, Finance, Sports). Adjust Personality:** Modify the system prompt in the AI News Summarizer Agent node to change the tone of the summaries (e.g., "explain it like I'm 5" or "highly technical"). Change Schedule:** Update the Daily 8 AM Trigger node to your preferred time zone and frequency.
by Kumar SmartFlow Craft
🚀 How it works Handles GDPR Article 15 (access) and Article 17 (erasure) requests end-to-end — from inbound email to legally-compliant response — with zero manual intervention and a full audit trail. 📬 Monitors Gmail inbox for incoming data subject requests 🤖 AI Agent classifies the request (access or erasure), extracts the requester email and data subject email with structured JSON output 🗄️ Queries Supabase for all personal data records matching the subject 📋 Queries Airtable CRM for matching contact records 📝 Second AI Agent compiles all found data into a GDPR-compliant HTML report ✉️ Access requests — sends a full data report to the requester 🗑️ Erasure requests — deletes records from both Supabase and Airtable, then sends a deletion confirmation 🔒 Logs every request to Google Sheets with timestamp for your audit trail 🛠️ Set up steps Estimated setup time: ~20 minutes Gmail Trigger — connect Gmail OAuth2; point it at your DSR inbox OpenAI — connect OpenAI API credential (used by both AI Agent nodes) Supabase — connect Supabase API credential; update the table name from users to match your schema Airtable — connect Airtable Personal Access Token; replace YOUR_BASE_ID and YOUR_TABLE_NAME Google Sheets — connect Google Sheets OAuth2; replace YOUR_AUDIT_SHEET_ID; create a tab named DSR Audit Log Follow the sticky notes inside the workflow for per-node guidance 📋 Prerequisites Gmail account receiving GDPR requests OpenAI API key (GPT-4o) Supabase project with a users/contacts table Airtable base with a Contacts table containing an Email field Google Sheets for audit log Custom Workflow Request with Personal Dashboard kumar@smartflowcraft.com https://www.smartflowcraft.com/contact More free templates https://www.smartflowcraft.com/n8n-templates
by WeblineIndia
AI-Powered Email Monitoring & Compliance Risk Detection > Gmail + Gemini + Google Sheets This workflow automatically monitors incoming Gmail messages, analyzes them using Google Gemini AI for compliance risks (fraud, phishing, data leaks), filters high-confidence threats, logs incidents securely in Google Sheets and sends alert emails to your security team. Quick Implementation Steps Connect your Gmail and Google Sheets accounts. Add your Google Gemini API credentials. Set the Gmail node to monitor your desired inbox. Create a Google Sheet with required columns: Incident_Hash Incident_Time Risk_Type Risk_Confidence Replace the alert email in the final Gmail node. Activate the workflow. That’s it — your AI-powered compliance monitoring system is live! What It Does This workflow acts as an intelligent email security and compliance monitoring system. It continuously scans incoming emails and uses AI to detect potential risks such as fraud attempts, phishing emails or sensitive data leaks. When an email arrives, the system extracts clean text by removing HTML clutter, signatures and hidden elements. This ensures that only relevant content is sent to the AI model, improving both accuracy and cost efficiency. The workflow then leverages Google Gemini to analyze the email in its original language, eliminating the need for translation. The AI returns a structured JSON response including risk type, severity level, confidence score and reasoning. To ensure reliability, a custom code node safely parses the AI output using regex and error handling. Based on the detected risk level, the workflow routes the email, filters out low-confidence alerts, logs incidents securely and sends formatted alerts to your compliance or security team. Who It's For Compliance teams monitoring sensitive communications Security teams handling phishing and fraud detection Enterprises managing high-volume email workflows Customer support teams dealing with external communications Organizations requiring audit trails for regulatory compliance Requirements To use this workflow, you need: n8n account (Cloud or Self-hosted) Google account with: Gmail access Google Sheets access Google Gemini API credentials A Google Sheet for logging incidents Basic understanding of n8n workflows How It Works & How To Set Up 1. Setup Credentials Connect Gmail OAuth2 in n8n Connect Google Sheets OAuth2 Add Google Gemini API credentials 2. Configure Gmail Trigger Node: Catch Incoming Emails Operation: getAll Set filters if needed (label, inbox, etc.) 3. Clean Email Content Node: Strip Email Formatting Extracts <body> content from HTML Outputs clean text as clean_body 4. AI Risk Analysis Node: Analyze Compliance Risk Uses Google Gemini to analyze: Subject Email body Returns structured JSON: { "risk_type": "", "risk_level": "", "confidence": 0, "reason": "" } 5. Safe Parsing (Critical Step) Node: Clean & Parse AI Output Uses: Regex to extract JSON try/catch for error handling Prevents workflow failure if AI output is malformed 6. Prepare Variables Node: Prep Variables for Routing Extracts: risk_type risk_level confidence reason 7. Route Based on Risk Node: Route by Risk Level Splits into: High Medium Low 8. Filter False Positives Node: Block Low-Confidence Alerts Condition: confidence > 80 Ensures only high-confidence threats proceed 9. Generate Secure Incident ID Node: Generate Secure Incident ID Uses SHA256 hash of: Sender email Timestamp Masks sensitive data (PII) 10. Log to Google Sheets Node: Save to Audit Log Appends data: Incident_Hash Incident_Time Risk_Type Risk_Confidence 11. Format Report Node: Format AI Report Converts AI reasoning (Markdown → HTML) 12. Send Alert Node: Send Security Alert Sends styled HTML email to your team Replace: REPLACE_WITH_YOUR_EMAIL How To Customize Nodes Adjust AI Prompt Modify the prompt in Analyze Compliance Risk Add custom risk categories or rules Change Confidence Threshold Update filter node (default: > 80) Lower for aggressive detection, higher for stricter filtering Customize Alert Email Edit HTML in Send Security Alert Add branding, logos or additional data Modify Logging Fields Extend Google Sheets columns Add fields like: Sender Subject Department Add-Ons (Extend Functionality) Slack / Microsoft Teams alerts instead of email Dashboard using Power BI or Looker Studio Auto-response to suspicious emails Integration with SIEM tools Store historical data for ML-based trend analysis Use Case Examples Detect phishing emails targeting employees Monitor customer support inbox for fraud attempts Identify accidental data leaks in outgoing communications Automate compliance monitoring for regulated industries Flag suspicious vendor or financial emails And many more use cases depending on your business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No emails detected | Gmail trigger not configured | Check Gmail credentials and filters | | AI output parsing fails | Invalid JSON from AI | Verify Code node logic and prompt format | | Alerts not sent | Email not configured | Replace recipient email in final node | | No data in Google Sheets | Sheet mapping incorrect | Verify document ID and column names | | Too many false alerts | Low confidence threshold | Increase threshold above 80 | | Workflow crashes | Missing credentials | Reconnect all services | Need Help? If you need help setting up this workflow, customizing nodes or building advanced process automation solutions: Reach out to our n8n workflow developers at WeblineIndia / Global We can help you with: Custom workflow development AI-powered automation solutions Integration with enterprise tools Scaling and optimization Let us help you turn automation into a competitive advantage
by sato rio
This workflow automates the initial screening process for new job applications, freeing up your recruitment team to focus on qualified candidates. It receives applications from a webhook, uses OpenAI (GPT-4) to analyze resumes for skill and culture fit, generates interview questions, logs the results to Google Sheets, sends interview invitations via Gmail, and notifies your team on Slack. 🚀 Who is this for? HR and Recruitment Teams** looking to automate repetitive screening tasks. Hiring Managers** who want a consistent, data-driven first pass on applicants. Startups and SMBs** aiming to build an efficient, scalable hiring pipeline without a large HR team. 💡 How it works Receive Application: The workflow triggers when a new application is submitted via a webhook from your job board or application form. Extract & Analyze: It downloads the resume/CV, extracts the text, and sends it to OpenAI (GPT-4) with a custom prompt. Score & Generate: The AI scores the candidate on skill match and culture fit, provides a summary, and generates tailored interview questions based on their experience. Log Data: The evaluation scores, AI summary, and candidate information are appended to a new row in a Google Sheet for tracking. Schedule Interview: A personalized email is sent to the candidate via Gmail with a link to schedule their interview. Notify Team: A summary card with the AI evaluation and links to the full report is posted in a Slack channel to keep the hiring team informed. ⚙️ How to set up Configure Credentials: Set up your credentials for OpenAI, Google (for both Sheets and Gmail), and Slack in n8n. Webhook URL: Copy the "Production URL" from the "Webhook: New Application" node and set it as the destination in your job board's webhook settings (e.g., Greenhouse, Lever, Ashby, or a web form). Google Sheet: Create a Google Sheet to track applicants. Update the "G Sheets: Save Evaluation" node with your Spreadsheet ID and Sheet Name. Ensure the columns in your sheet match the data you want to save. Customize Prompts & Email: Modify the prompts in the two OpenAI nodes to match your company's values and the specific job requirements. Update the Gmail node with your email content and the logic for your scheduling link (e.g., Calendly, SavvyCal). 📋 Requirements An n8n instance (Cloud or self-hosted). An OpenAI API key. A Google account for Google Sheets and Gmail. A Slack workspace. A job application source capable of sending webhooks.
by Yassin Zehar
Description Automatically triage Product UAT feedback using AI, route it to the right tools and teams, and close the feedback loop with testers, all in one workflow. This workflow analyzes raw UAT feedback, classifies it (critical bug, feature request, UX improvement, or noise), validates AI confidence, escalates when human review is needed, and synchronizes everything across Jira, Slack, Notion, Google Sheets, and email. Context Product teams often receive unstructured UAT feedback from multiple sources (forms, Slack, internal tools), making triage slow, inconsistent, and error-prone. This workflow ensures: Faster bug detection Consistent categorization Zero feedback lost Clear accountability between Product, Engineering, and Design It combines AI automation with human-in-the-loop control, making it safe for real production environments. Who is this for? Product Managers running UAT or beta programs Project Managers coordinating QA and release validation Product Ops / PMO teams Engineering teams who want faster, cleaner bug escalation Any team managing high-volume UAT feedback Perfect for teams that want speed without sacrificing control. Requirements Webhook trigger (form, internal tool, Slack integration, etc.) OpenAI account (for AI triage) Jira (bug tracking) Slack (team notifications) Notion (product roadmap / UX backlog) Google Sheets (UAT feedback log) Gmail (tester & manual review notifications) How it works Trigger The workflow starts when UAT feedback is submitted via a webhook (form, Slack, or internal tool). Normalize & Clean Incoming data is normalized into a consistent structure (tester, build, page, message) and cleaned to be AI-ready. AI Triage An AI model analyzes the feedback and returns: Type (Critical Bug, Feature Request, UX Improvement, Noise) Severity & sentiment Summary and suggested title Confidence score Quality Control If the AI output is unreliable (low confidence or parsing error), the feedback is automatically routed to manual review via email and Slack. Routing & Actions If confidence is sufficient: Critical Bugs → Jira issue + Engineering Slack alert Feature Requests → Notion roadmap UX Improvements → Design / UX tracking Noise → Archived but traceable Closed Loop The tester is notified via Slack or email, and the workflow responds to the original webhook with a structured status payload. What you get One unified UAT triage system Faster bug escalation Clean product and UX backlogs Full traceability of every feedback Automatic tester communication Safe AI usage with human fallback About me : I’m Yassin a Product Manager Scaling tech products with a data-driven mindset. 📬 Feel free to connect with me on Linkedin
by Avkash Kakdiya
How it works This workflow automatically creates a weekly report of tasks. Every Friday morning, it collects all task details from Airtable, checks progress, and prepares a summary. It also highlights important or late tasks and sends the report to Slack, email, and saves it for record. Step-by-step Trigger & fetch** Schedule: Every Friday 9AM – Triggers the workflow automatically every Friday at 9 AM. Airtable: Fetch This Week – Collects all task records from the Airtable base for the current week. Analysis & formatting** Code: Analyze & Format – Checks all tasks, detects fields, calculates completion rate, identifies overdue and urgent items, and builds the full Slack message with an {{AI_SUMMARY}} placeholder. AI summary generation** OpenAI: Generate AI Summary – Sends the weekly stats to GPT-4.1-mini with a structured prompt to produce a concise 2–3 sentence plain-English project manager summary. Merge & prepare** Code: Merge AI Summary – Injects the AI summary into the Slack message and prepares urgent alert messages for overdue or high-priority tasks. Parallel output actions** Slack: Post Weekly Digest – Posts the full formatted digest to a Slack channel with mrkdwn formatting. Gmail: Send Digest Email – Sends an HTML-formatted email with stats cards, AI summary, and a task table. Google Sheets: Log Weekly Stats – Appends week range, totals, completion rate, overdue count, AI summary, and status to a tracking sheet. Conditional urgent alert** IF: Has Urgent or Overdue? – Checks if overdue or urgent task count is greater than zero. Slack: DM Urgent Alert – Sends a separate urgent action-required message to Slack if flagged items exist. Gmail: Send Urgent Alert – Sends a red-header alert email listing overdue and urgent counts if flagged items exist. Why use this? Eliminates manual weekly reporting by automatically collecting, analyzing, and summarizing all Airtable task data Keeps the entire team informed across Slack and Email every Friday without lifting a finger AI-generated summaries give instant clarity on project health and what needs attention Logs every weekly digest to Google Sheets for long-term trend tracking and reporting Sends a separate urgent alert so critical or overdue tasks never get buried in the digest
by Cheng Siong Chin
How It Works This workflow automates continuous data integrity monitoring and intelligent alert management across multiple data sources. Designed for data engineers, IT operations teams, and business intelligence analysts, it solves the critical challenge of detecting data anomalies and orchestrating appropriate responses based on severity levels. The system operates on scheduled intervals, fetching data from software metrics APIs and BI dashboards, then merging these sources for comprehensive analysis. It employs AI-powered validation and orchestration agents to detect anomalies, assess severity, and determine optimal response strategies. The workflow intelligently routes alerts based on severity classification, triggering critical notifications via email and Slack for high-priority issues while sending standard reports for routine findings. By maintaining detailed compliance audit logs and preparing executive summaries, it ensures stakeholders receive timely, actionable intelligence while creating audit trails for data quality monitoring initiatives. Setup Steps Configure Schedule Data Integrity Check trigger with monitoring frequency Connect Workflow Configuration node with data source parameters Set up Fetch Software Metrics and Fetch BI Dashboard Data nodes with respective API credentials Configure Merge Data Sources node for data consolidation logic Connect Data Validation Agent with OpenAI/Nvidia API credentials for anomaly detection Set up Orchestration Agent with AI API credentials for severity assessment Configure Check for Anomalies node with routing conditions Connect Route by Severity node with classification logic Prerequisites OpenAI or Nvidia API credentials for AI-powered analysis, API access to software metrics platforms Use Cases SaaS platforms monitoring service health metrics, e-commerce businesses tracking inventory data quality Customization Adjust scheduling frequency for monitoring intervals, modify severity thresholds for alert classification Benefits Reduces mean time to detection by 75%, eliminates manual data quality checks
by Avkash Kakdiya
Quick overview This workflow runs every Monday to fetch your latest YouTube videos, calculate performance rankings, generate an OpenAI insight summary, then share a weekly digest to Slack, log metrics to Google Sheets, and email an HTML report via Gmail. How it works Runs every Monday at 08:00 using a schedule trigger. Calls the YouTube Data API to fetch the 20 most recent videos from your channel and extracts their video IDs and metadata. Batch-fetches each video’s statistics from the YouTube Data API, then calculates engagement rate, a composite performance score, ranks videos, and tags them as Top Performer, Average, or Underperformer. Aggregates the ranked list and sends it to OpenAI to generate a concise weekly performance insight summary and recommendations. Posts a formatted weekly digest to a Slack channel highlighting the best and worst video plus the top 5 rankings and AI insights. Appends each video’s weekly metrics to a Google Sheets tab for historical tracking, then emails a full ranked HTML report to the content manager using Gmail. Setup Enable the YouTube Data API v3 and set your YouTube API key and channel ID in the two YouTube HTTP requests. Add an OpenAI credential (Chat Model) and select the model you want to use for generating the insight summary. Add a Slack credential and set the target channel ID for where the digest should post. Create a Google Sheet with a tab named “YouTube Performance Log”, add a Google Sheets credential, and replace the placeholder spreadsheet ID. Add a Gmail credential and set the recipient address for the weekly email report.
by WeblineIndia
Zoho CRM – Deal Health Predictor with AI Scoring This n8n automation monitors open Zoho CRM Deals every week, identifies stalled opportunities, scores their health using Google Gemini AI and triggers sales intervention by emailing the deal owner and creating a high-priority task in Zoho CRM — before the deal goes cold. Quick Start — Implementation in 6 Steps Import workflow into your n8n instance. Connect Zoho OAuth2 credential in all Zoho nodes. Connect Gmail OAuth2 account for outbound alerts. Confirm stage names & inactivity thresholds match your CRM. Test with sample deals before scheduling. Activate the workflow once validated by your sales team. What It Does This workflow dynamically analyzes every open sales deal retrieved from Zoho CRM. It calculates key metrics per deal such as inactivity duration, stage aging and deal age to understand whether the opportunity has stalled. Only deals with significant inactivity move forward to AI scoring. Using Google Gemini, each deal receives a Health Score (0–100), along with a risk level, reasons and recommended next actions. If a deal is considered “At-Risk,” the system automatically: Sends an alert email to the assigned sales rep Creates a high-priority Task in Zoho CRM linked to that deal It ensures timely sales intervention without needing manual checks. Who’s It For Sales teams using Zoho CRM RevOps & Sales Managers monitoring deal movement Teams wanting data-backed alerts for slow-moving deals Businesses wanting proactive pipeline management with AI Requirements | Requirement | Why | |------------|-----| | n8n instance (Self-hosted or Cloud) | Runs the workflow | | Zoho CRM OAuth2 Credentials | Fetch deals + Create tasks | | Gmail (or SMTP) credentials | Send alert emails | | Google Gemini API access | AI scoring on deals | | Deals must have Stage + Owner + Activity history | Ensures accurate scoring | How It Works — Setup & Configuration Steps Step-by-Step Setup Import workflow into n8n Enable Zoho CRM OAuth2 credentials in: Fetch Open Deals Create At-Risk Task Enable Gmail OAuth2 on the email alert node Validate fields from Zoho API: Last_Activity_Time Stage Owner.email Update the deal stage list in the Fetch URL if needed: Example: Qualification, Negotiation, Proposal, etc. Confirm scanning frequency in the Weekly Trigger Run the workflow manually once → check logs + emails + tasks Turn workflow Active How To Customize Nodes | Node | What You Can Customize | Example | |------|-----------------------|---------| | Weekly Trigger | Change execution frequency | Daily scan | | Fetch Deals | Include additional deal stages | Add “Value Proposition” | | Filter Stalled Deals | Adjust inactivity threshold | > 15 days instead of 30 | | AI Prompt | Add more data points | Probability to close | | Email Alert | Modify message template | Localization | | Task creation | Add reminder / follow-up info | Due date +1 day | Add-Ons (Optional Enhancements) You can easily extend this workflow by adding: Stage Change Webhook Trigger** → near real-time monitoring Google Sheets or Database Logging** for reporting Duplicate task checker** so the same deal isn’t flagged repeatedly Slack / Microsoft Teams alerts** SLA-based scoring** (pipeline aging logic) Manager escalation** if no response in X days Practical Use Cases This workflow is ideal for: Sales manager auto-alert system for aging deals Leaderboard tracking for untouched deals Weekly CRM hygiene and rep performance tracking Early detection of churn risk in B2B sales cycles AI-assisted deal coaching and next-step suggestions Many more scenarios are possible based on deal movement automation. Troubleshooting Guide | Issue | Possible Cause | Fix / Solution | |------|----------------|----------------| | No deals processed | Stage filters too narrow | Update fetch URL stage list | | Emails not sent | Gmail credentials missing or expired | Reconnect Gmail OAuth2 | | Tasks not created | Zoho API permissions missing | Enable write permissions | | Owner email missing | CRM field not mapped correctly | Update sendTo expression | | Health score always null | Output parser mismatch | Check prompt & parser config | | Workflow runs but no alerts sent | No stalled deals or score >= threshold | Temporarily lower threshold for testing | Need Help? If you would like expert help customizing this workflow or implementing additional automation like stage-based triggers, dashboards or integration with Slack/Teams, our n8n automation team at WeblineIndia can assist you.