by Daniel Lianes
Automated Daily AI Summaries from WhatsApp Groups using a Custom AI Agent Transform your WhatsApp group conversations into actionable business intelligence through automated AI analysis and daily reporting. This workflow eliminates manual conversation monitoring by capturing messages in real-time, processing voice notes, and delivering structured insights directly to your team. Overview This workflow provides complete conversation intelligence automation from message capture to insight delivery. It eliminates manual monitoring, analysis, and reporting by using Evolution API integration, OpenAI transcription, and advanced LLM analysis for hands-free business intelligence that scales your team's awareness of important discussions. Core Function: Autonomous conversation analysis that transforms WhatsApp group chatter into structured business insights with zero manual intervention, maintaining consistent daily reporting while capturing emerging opportunities and trends before your competition. Key Capabilities Real-time message capture - Monitors multiple WhatsApp groups simultaneously with instant processing and smart filtering Voice message transcription - Automatic conversion of audio messages to searchable text using OpenAI Whisper AI-powered insight extraction - Advanced LLM analysis identifies trends, opportunities, and actionable information while filtering noise Automated daily reporting - Scheduled intelligence summaries delivered directly to your team via WhatsApp Multi-group organization - Separate tracking and analysis for different communities with unified reporting Smart content filtering - AI agent trained to focus on business-relevant discussions (AI, automation, tech trends, opportunities) Tools Used n8n: Workflow orchestration managing the entire intelligence pipeline from capture to delivery Evolution API: WhatsApp Business API integration for real-time message monitoring and sending OpenAI Whisper: Voice message transcription ensuring no important audio content is missed OpenRouter/GPT-4.1: Advanced AI analysis for intelligent insight extraction and content filtering Google Sheets: Organized message storage with timestamps and metadata for historical analysis Custom AI Agent: "WhatsOn" - specialized business intelligence detective for tech and automation insights How to Install Import the Workflow: Download the JSON file and import into your n8n instance Configure Evolution API: Set up WhatsApp integration and webhook endpoints for message capture API Credentials Setup: Add OpenAI, OpenRouter, and Google Sheets credentials in n8n Group Configuration: Update group IDs in the "Set Info" node with your monitored groups Google Sheets Setup: Create organized spreadsheet with separate tabs for each group Schedule Configuration: Set your preferred daily summary delivery time Test Execution: Run manual test to verify message capture and AI analysis work correctly Use Cases Business Intelligence Automation: Stay informed about industry discussions without manual monitoring Opportunity Detection: Identify emerging trends, tools, and business opportunities in real-time Team Knowledge Sharing: Automated distribution of relevant insights from multiple communities Competitive Intelligence: Monitor industry discussions to stay ahead of market developments Community Management: Track engagement patterns and important conversations across groups Voice Message Processing: Ensure audio-based insights aren't lost in team communications Setup Requirements Evolution API account: WhatsApp Business integration with webhook capabilities OpenAI API: Voice transcription access through Whisper API OpenRouter account: Access to GPT-4.1 for advanced conversation analysis Google Sheets: Message storage and organization with proper permissions configured WhatsApp Groups: Access to business or professional groups with relevant discussions Total setup time: 15-20 minutes once all API accounts are properly configured. How to Customize Analysis Focus: Modify the AI agent's system prompt to target your industry or specific topics. Adjust keyword priorities, conversation themes, or insight categories based on your business needs. Group Management: Add additional groups by extending the Switch node logic, creating new Google Sheets tabs, and updating group ID variables. Scale from 3 to unlimited group monitoring. Delivery Schedule: Change summary frequency from daily to weekly, multiple times per day, or custom schedules. Add multiple delivery destinations for different team segments. AI Intelligence: Customize the "WhatsOn" agent personality, adjust insight priorities, modify filtering criteria, or add sentiment analysis for deeper conversation understanding. Storage & Organization: Modify Google Sheets structure, add custom metadata fields, integrate with other databases, or connect to business intelligence dashboards for advanced analytics. Advanced Features Smart Voice Processing Automatically transcribes voice messages to text using OpenAI's Whisper API, ensuring critical audio-based discussions are captured and analyzed alongside text conversations. Intelligent Content Filtering The AI agent is specifically trained to identify valuable business insights while filtering out casual conversation, ensuring your daily summaries focus on actionable information that drives decisions. Multi-Fragment Delivery System Large intelligence summaries are automatically broken into properly formatted WhatsApp messages with natural pacing to avoid delivery issues and improve readability. Historical Analysis Capability All conversations are stored with full metadata in Google Sheets, enabling historical trend analysis, keyword tracking, and long-term pattern recognition for strategic planning. Ready to transform group conversations into competitive intelligence? This template converts casual WhatsApp discussions into structured business insights delivered automatically to your team, ensuring you never miss important industry developments or opportunities. Google Sheets Template The workflow includes a pre-configured structure for tracking: Message timestamps and sender information Full conversation content with voice transcriptions Group-specific organization and categorization Daily summary delivery logs and performance metrics Was this helpful? Let me know! I truly hope this WhatsApp intelligence system helps streamline your team's awareness of important conversations. Your feedback helps me create better automation resources for the n8n community. Ready to Build Something Great? If you're looking to take your n8n skills or business automation to the next level, I can help. 🎓 n8n Coaching: Want to become an n8n pro? I offer one-on-one coaching sessions to help you master workflows, tackle specific problems, and build with confidence. ➡️ Book a Coaching Session 💼 n8n Consulting: Have a complex project, an integration challenge, or need a custom workflow built for your business? Let's work together to create a powerful automation solution. ➡️ Inquire About Consulting Services Stay Updated on Automation For more content automation strategies, AI workflow tips, and business automation insights: Follow me on LinkedIn Happy Automating! Daniel Lianes
by SpaGreen Creative
WhatsApp Bulk Message Broadcast via Google Sheets (n8n Workflow) Use Case This workflow enables automated bulk WhatsApp message broadcasting using the WhatsApp Business Cloud API. It pulls recipient and message data from a Google Sheet, sends templated messages (optionally with image headers), and updates the sheet with the message status. It is ideal for marketing teams, support agents, and businesses handling high-volume outreach. Who Is This For? Businesses conducting WhatsApp marketing or outreach campaigns Customer support or notification teams Administrators seeking an automated, no-code message distribution system using Google Sheets What This Workflow Does Triggers automatically every minute to scan for pending messages Fetches unsent entries from a Google Sheet Limits the number of messages processed per execution to comply with API usage guidelines Sanitizes WhatsApp numbers for proper formatting Sends messages using a pre-approved WhatsApp template (text and optional image) Marks the row as "Sent" in the sheet upon successful delivery Workflow Breakdown (Node by Node) 1. Trigger Every 5 Minutes Initiates the workflow every minute using a scheduled trigger to continuously monitor pending rows. 2. Fetch All Pending Queries for Messaging Reads rows from a Google Sheet where the Status column is empty, indicating they haven’t been processed yet. 3. Limit Restricts processing to 2 rows per execution to manage API throughput. 4. Loop Over Items Uses SplitInBatches to iterate through each row individually. 5. Clean WhatsApp Number A code node that strips non-numeric characters from the WhatsApp No field, ensuring the format is valid for the API. 6. Send Message to 300 Phone No Sends a WhatsApp message using the WhatsApp Cloud API and a pre-approved template. Template includes: An image from the Image URL column (as header, optional) Dynamic variables for the recipient's Name and Message fields Template variables must be pre-defined and approved in the Meta Developer Portal, such as {{1}}, {{2}}. 7. Change State of Rows in Sent1 Updates the Status column to Sent for each successfully processed row using the row number as a reference. Google Sheet Format Structure your Google Sheet as shown below: | WhatsApp No | Name | Message | Image URL | Status | |--------------|------------|---------------------------|---------------------|--------| | +8801XXXXXXX | John Doe | Hello, your order shipped | https://.../img.jpg | | Leave the Status column empty for rows that need to be processed. Requirements WhatsApp Business Cloud API access via Meta for Developers A properly structured Google Sheet as described above Active OAuth2 credentials configured in n8n for: googleSheetsOAuth2Api whatsAppApi Customization Options Update the Limit node to control how many rows are processed in each run Adjust the trigger schedule (e.g., change to every 5 minutes) Replace the message template ID with your own custom-approved one from Meta Add error-handling logic (e.g., IF or Try/Catch nodes) to log failures or set Status = Failed Sample Sheet Template View Sample Google Sheet Workflow Highlights Automated execution every 1 minute Reads and processes only pending records Verifies WhatsApp numbers and delivers templated messages Updates Google Sheet after each attempt Support & Community Need help setting up or customizing the workflow? WhatsApp: Contact Support Discord: Join SpaGreen Server Facebook Group: SpaGreen Community Website: Visit SpaGreen Creative
by Jitesh Dugar
Streamline client onboarding and project setup from hours to minutes with AI-driven automation. This intelligent workflow eliminates manual coordination, builds proposals, creates projects in Asana, welcomes clients on Slack, and logs everything — ensuring 90% faster onboarding and zero dropped steps. What This Workflow Does Transforms your client onboarding from scattered tools and emails into one seamless automation: 📝 Capture Client Details – Jotform intake form collects client, company, and project information. 🧠 AI-Powered Analysis – LangChain AI Agent analyzes the project scope, estimates effort, and recommends team composition. 📄 Generate Proposal – Automatically builds a professional HTML proposal summarizing goals, timeline, and estimated hours. 🗂️ Create Asana Project – Generates a new project with all key details, milestones, and assigned team members. 💬 Slack Collaboration – Creates a dedicated Slack channel, sends welcome messages, and introduces the project team. 📧 Welcome Email – Sends a personalized onboarding email to the client with project summary and next steps. 💼 CRM Sync – Creates or updates a HubSpot contact with complete project and client information. 📊 Audit Logging – Logs all onboarding activity to Google Sheets for centralized record-keeping. Key Features 🤖 AI Proposal Generation – Uses LangChain AI to generate smart project summaries and resource plans. ⚙️ End-to-End Automation – From form submission to project creation, communication, and CRM logging. 💬 Smart Slack Setup – Automatic channel creation and messaging for internal coordination. 📧 Personalized Client Emails – Beautifully formatted, professional onboarding emails. 🗂️ Asana Integration – Project creation with dynamic task templates and priorities. 📊 Google Sheets Logging – Instant audit trail for every client submission and generated proposal. 💼 CRM Integration – Automatically syncs client data with HubSpot for sales and account tracking. Perfect For 🚀 Agencies & Service Providers – Automate client onboarding, proposal creation, and task setup. 🏢 Consultancies – Quickly turn client requests into structured projects with assigned resources. 💻 Freelancers & Creators – Impress clients with AI-built proposals and instant communication. 📈 Growing Teams – Scale onboarding without extra admin or coordination time. 🧠 Operations Teams – Ensure consistency and transparency across all onboarding activities. What You’ll Need Required Integrations 🧾 Jotform – Client intake form (project details, budget, company info). Create your form for free on Jotform using this link 🤖 AI Agent – For analyzing project scope and building proposals. 🗂️ Asana – Project creation and task assignment. 💬 Slack – For automated client channel creation and internal communication. 📧 Gmail – For onboarding and proposal emails. 💼 HubSpot – CRM contact creation and project linkage. 📊 Google Sheets – For logging all onboarding and AI results. Optional Enhancements 📄 PDF Generation (PDF Munk) – Convert AI-generated proposals into downloadable PDFs. 💬 Slack Interactive Approvals – Add buttons for internal review before client communication. 📈 Performance Dashboard – Connect Google Sheets data to Looker Studio for tracking onboarding times. 🌍 Multilingual Support – Add translation nodes for international clients. 🔐 File Attachments – Send proposal PDFs or onboarding kits automatically via Gmail. Quick Start 1️⃣ Import Template – Copy and import the JSON file into your n8n workspace. 2️⃣ Set Up Jotform – Create a form with fields for client name, company, project name, budget, and requirements. 3️⃣ Add Credentials – Connect Jotform, AI Agent, Asana, Slack, Gmail, HubSpot, and Google Sheets. 4️⃣ Configure Sheet ID – Replace YOUR_SHEET_ID in the Google Sheets node. 5️⃣ Customize Proposal HTML – Edit AI prompt and branding to reflect your company’s style. 6️⃣ Test Workflow – Submit a test form and verify Slack, Asana, Gmail, and Sheets outputs. 7️⃣ Deploy – Activate workflow and share the Jotform link with your sales or operations team. Customization Options 1️⃣ Proposal Branding – Customize proposal HTML with logos, brand colors, and formatting. 2️⃣ AI Prompt Tuning – Refine the LangChain AI prompt to match your tone or project style. 3️⃣ Task Templates – Adjust task names, assignees, and due dates in the Asana creation node. 4️⃣ Slack Messaging – Update welcome message formatting and team introduction details. 5️⃣ CRM Fields – Map additional HubSpot properties for better data tracking. 6️⃣ Sheet Logging – Add more columns for tracking team recommendations or proposal scores. Expected Results ⚡ 90% Faster Onboarding – Reduce manual setup from hours to minutes. 🤖 AI Precision – Intelligent proposals and team allocations that impress clients instantly. 📈 Zero Missed Steps – Every project automatically created, communicated, and logged. 💬 Seamless Collaboration – Slack, Gmail, and Asana in perfect sync. 🗂️ Complete Transparency – Every onboarding step logged for accountability and improvement. 🏆 Use Cases 🧑💼 Marketing & Creative Agencies – Automate creative project scoping and proposal creation. 💻 Software Development Teams – Rapidly assess client tech requirements and allocate developers. 🧾 Consulting Firms – Build data-backed, AI-enhanced proposals for client engagements. 🏢 Corporate PMOs – Standardize project setup and approvals across multiple departments. Pro Tips 💡 Refine AI Prompt – Include examples of past projects to improve proposal quality. 💬 Add Slack Approvals – Insert “manager approval” logic before sending proposals. 📄 Attach PDFs – Use PDF Munk for branded, downloadable proposals. 📊 Track Conversion – Link HubSpot deal stage changes based on Asana progress. 📅 Monitor Efficiency – Use Sheet timestamps to calculate average onboarding time. Learning Resources This workflow demonstrates: AI integration using Agents Multi-app orchestration and data syncing Advanced HTML and email template customization Real-world Asana and Slack API usage CRM syncing and Google Sheets logging Modular, scalable n8n workflow design Workflow Structure Visualization 📝 Jotform Submission ↓ 🧠 AI Project Analysis (Agent) ↓ 📄 Proposal Generation (HTML) ↓ 🗂️ Asana Project Creation ↓ 💬 Slack Channel Setup & Message ↓ 📧 Gmail Welcome Email ↓ 💼 HubSpot Contact Creation ↓ 📊 Google Sheets Log Ready to Revolutionize Client Onboarding? Import this template today and let AI handle the heavy lifting. Your team saves hours, your clients get instant engagement — and your entire process runs flawlessly. ✨
by WeblineIndia
Quick overview This workflow monitors Gmail for invoice emails, extracts structured fields from attached PDFs using Groq LLMs, validates invoices against Purchase Orders stored in Google Sheets, predicts rejection risk with an LLM, emails suppliers about problems, and logs approved invoices to an AP tracking Google Sheet. How it works Triggers every minute when a new invoice email arrives in Gmail. Downloads the email attachment and extracts text from the invoice PDF. Uses a Groq LLM chain to extract invoice fields (invoice/PO/GRN numbers, supplier details, currency, totals, and line items) into structured JSON. Looks up the referenced PO in a Google Sheets PurchaseOrders table, rejecting the invoice via Gmail if no matching PO is found. Merges the invoice data with the PO record and runs data integrity checks (required fields, non-zero amount, and PO status is Approved), emailing the supplier if validation fails. Applies 3-way match rules against the PO (supplier, amount, currency, PO approval, and presence of GRN) to set the invoice status as APPROVED, FLAGGED, or REJECTED. Uses an LLM to predict invoice rejection risk and, if risk is HIGH, emails the supplier a pre-submission warning, then routes approved invoices to a Google Sheets AP log and non-approved invoices to an AP manual-review Gmail alert. Setup Connect Gmail credentials for the Gmail trigger and all Gmail send/get actions, and verify the sender/recipient rules you want to monitor. Connect Google Sheets credentials and update the document IDs/sheet tabs for the PurchaseOrders lookup sheet and the Invoice Readiness logging sheet. Provide Groq (or compatible) LLM credentials/models for both the invoice extraction and the risk prediction steps. Ensure your PurchaseOrders sheet includes columns like po_number, supplier_name, currency, total_amount, and status (with "Approved" as the expected value). Set the supplier email field in the invoice template (or adjust the email recipient mapping) so supplier notifications go to the correct address. Additional info How To Customize Nodes Adjusting Match Rules:* Open the *3-Way Match Validator** node to edit the JavaScript logic (e.g., you can add a 5% "buffer" for price differences). Switching AI Models:** You can replace the Groq/Llama nodes with OpenAI nodes if you prefer to use GPT-4o for extraction. Email Templates:** The Gmail nodes use HTML templates. You can easily edit the colors, logos, and wording to match your company branding. Add‑ons Slack/MS Teams Integration:** Replace the "Manual Review" email with a real-time notification in a dedicated finance chat channel. Duplicate Detection:** Add a node to check your Google Sheet for existing Invoice Numbers to prevent paying the same bill twice. Currency Conversion:** Integrate a currency API to validate invoices billed in foreign currencies against a base-currency PO. Use Case Examples Supplier Compliance:** Automatically rejecting any invoice that doesn't reference a valid, approved PO. Partial Shipment Handling:** Flagging invoices where the billed amount is less than the PO, requiring a human to verify if it’s a partial delivery. Fraud Prevention:** Identifying "High Risk" invoices where the supplier's name or email does not perfectly match your approved vendor list. Automated Data Entry:** Seamlessly moving data from a PDF attachment into a structured spreadsheet without typing a single character. Proactive Supplier Support:* Automatically telling a supplier *exactly why their invoice might be rejected before they have to call and ask. Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | Extraction Failed | PDF is a low-quality scan or image. | Ensure the LLM node is using a vision-capable model or OCR is enabled in the PDF node. | | PO Not Found | Leading/Trailing spaces in PO numbers in the Sheet. | Use the .trim() function in the Search ERP node filter. | | Credentials Error | Gmail or Google Sheets token expired. | Re-connect your accounts in the n8n Credentials settings. | | AI Output is Malformed | LLM did not return valid JSON. | Ensure the "Output Parser" is correctly connected and the prompt is set to "STRICT JSON." | Need Help? Setting up automated financial workflows can be complex. If you need a helping hand to customize this workflow or connect it to a different ERP (like SAP, Oracle or QuickBooks) or build a completely custom automation solution, our n8n workflow developers at WeblineIndia are here to help. Our team of n8n experts can help you scale your business processes with high-precision AI integrations. Contact WeblineIndia Today to turn your manual tasks into automated wins!
by PollupAI
Who is this for? This workflow is ideal for individuals focused on nutrition tracking, meal planning, or diet optimization—whether you’re a health-conscious individual, fitness coach, or developer working on a healthtech app. It also fits well for anyone who wants to capture their meal data via voice or text, without manually entering everything into a spreadsheet. What problem is this workflow solving? Manually logging meals and breaking down their nutritional content is time-consuming and often skipped. This workflow automates that process using Telegram for input, OpenAI for natural language understanding, and Google Sheets for structured tracking. It enables users to record meals by typing or sending voice messages, which are transcribed, analyzed for nutrients, and automatically stored for tracking and review. What this workflow does This n8n automation lets users send either a text or voice message to a Telegram bot describing their meal. The workflow then: Receives the Telegram message Checks if it’s a voice message • If yes: Downloads the audio file and transcribes it using OpenAI • If no: Uses the text input directly Sends the meal description to OpenAI to extract a structured list of ingredients and nutritional details Parses and stores the results in Google Sheets Responds via Telegram with a personalized confirmation message A testing interface also allows you to simulate prompts and view structured outputs for development or debugging. Setup Create a Telegram bot via BotFather and note the API token. Create an empty Google Sheet and store the sheet ID in the environment. Set up your OpenAI credentials in the n8n credential manager. Customize the “List of Ingredients and Nutrients” node with your prompt if needed. (Optional) Use the “Testing” section to simulate messages and refine outputs before going live. How to customize this workflow to your needs • Enhance prompts in the OpenAI node to improve the structure and accuracy of responses. • Add new fields in the Google Sheet and corresponding logic in the parser if you want more detail. • Adjust the Telegram response to provide motivational feedback, dietary tips, or summaries. • Upgrade to the “Pro” version mentioned in the contact section for USDA database integration and complete nutrient breakdowns. This is a lightweight, AI-powered meal logging automation that transforms voice or text into actionable nutrition data—perfect for making healthy eating easier and more data-driven. See my other workflows here
by John Pranay Kumar Reddy
✨ Summary Efficiently monitor Kubernetes environments by sending only unique error logs from Grafana Loki to Slack. Reduces alert fatigue while keeping your team informed about critical log events. 🧑💻 Who’s it for DevOps or SRE engineers running EKS/GKE/AKS Anyone using Grafana Loki and Promtail for centralized logging Teams that want Slack alerts but hate alert spam 🔍 What it does This n8n workflow queries your Loki logs every 5 minutes, filters only the critical ones (error, timeout, exception, etc.), removes duplicate alerts within the batch, and sends clean alerts to a Slack channel with full metadata (pod, namespace, node, container, log, timestamp). 🧠 How it works 🕒 Schedule Trigger Every 5 minutes (customizable) 🌐 Loki HTTP Query Pulls logs from the last 10 minutes Keyword match: error, failed, oom, etc. 🧹 Log Parsing Extracts log fields (pod, container, etc.) Skips empty/malformed results 🧠 Deduplication Removes repeated error messages (within query window) 📤 Slack Notification Sends nicely formatted message to Slack ⚙️ Requirements Tool Notes Loki- Exposed internally or externally Slack App- With chat:write OAuth n8n- Cloud or self-hosted 🔧 How to Set It Up Import the JSON file into n8n Update: Loki API URL (e.g., http://loki-gateway.monitoring.svc.cluster.local) Slack Bearer Token (via credentials) Target Slack channel (e.g., #k8s-alerts) (Optional) Change keywords in the query regex Activate the workflow Ensure n8n pod/container is having access to your kubernetes cluster/pods/namespaces 🛠 How to Customize Want more or fewer keywords? Adjust the regex in the Query Loki for Error Logs node. Need to increase deduplication logic? Enhance the Remove Duplicate Alerts node. Want 5-log summaries every 5 min? Fork this and add a Batch + Slack group sender. Grafana Loki logs to Slack Output
by Rodrigue Gbadou
How it works Regulatory monitoring**: Continuously tracks changes in laws, regulations, and compliance requirements across multiple jurisdictions Contract analysis**: AI-powered review of existing contracts to identify compliance gaps and risks Automated alerts**: Real-time notifications when regulatory changes affect your contracts or business operations Compliance reporting**: Generates audit-ready reports and documentation for regulatory compliance Set up steps Legal databases**: Connect to legal research platforms (Westlaw, LexisNexis, EUR-Lex) Contract repository**: Integrate with your contract management system or document storage Regulatory feeds**: Configure government and regulatory body RSS feeds and APIs AI legal analysis**: Set up OpenAI or specialized legal AI for contract analysis Compliance calendar**: Integrate with calendar systems for deadline tracking Audit trail**: Configure logging and documentation systems for compliance records Key Features 🔍 Multi-jurisdiction monitoring**: Tracks regulatory changes across different countries and regions 📊 Risk assessment**: Automatically scores compliance risks and potential impact ⚡ Real-time alerts**: Instant notifications when regulations affecting your business change 📋 Gap analysis**: Identifies discrepancies between current contracts and new requirements 🤖 AI-powered analysis**: Uses natural language processing to understand legal text 📈 Compliance dashboard**: Visual overview of compliance status across all contracts 🔄 Automated remediation**: Suggests contract amendments and compliance actions 📱 Mobile notifications**: Critical compliance alerts on mobile devices Compliance areas monitored Data protection**: GDPR, CCPA, and other privacy regulations Financial services**: Banking regulations, securities law, anti-money laundering Healthcare**: HIPAA, medical device regulations, pharmaceutical compliance Employment law**: Labor regulations, workplace safety, discrimination laws Environmental**: ESG requirements, environmental protection regulations Industry-specific**: Sector-specific regulations and standards Contract types supported Vendor agreements**: Supplier contracts and service agreements Employment contracts**: Employee agreements and contractor terms Data processing agreements**: Privacy and data handling contracts Customer agreements**: Terms of service and customer contracts Partnership agreements**: Joint ventures and strategic partnerships Licensing agreements**: Software licenses and intellectual property Automated responses Low risk (0-30)**: Routine monitoring and documentation Medium risk (31-60)**: Enhanced review and stakeholder notification High risk (61-80)**: Immediate legal review and action planning Critical risk (81-100)**: Emergency legal intervention and compliance measures Integration capabilities Legal research**: Westlaw, LexisNexis, Bloomberg Law Document management**: SharePoint, Google Drive, Dropbox Contract systems**: DocuSign, PandaDoc, ContractWorks Communication tools**: Slack, Teams, email for legal team alerts Calendar systems**: Outlook, Google Calendar for compliance deadlines This workflow ensures continuous legal compliance by monitoring regulatory changes and automatically assessing their impact on your contracts and business operations.
by Arnaud MARIE
Monthly Spotify Track Archiving and Playlist Classification This n8n workflow allows you to automatically archive your monthly Spotify liked tracks in a Google Sheet, along with playlist details and descriptions. Based on this data, Claude 3.5 is used to classify each track into multiple playlists and add them in bulk. Who is this template for? This workflow template is perfect for Spotify users who want to systematically archive their listening history and organize their tracks into custom playlists. What problem does this workflow solve? It automates the monthly process of tracking, storing, and categorizing Spotify tracks into relevant playlists, helping users maintain well-organized music collections and keep a historical record of their listening habits. Workflow Overview Trigger Options**: Can be initiated manually or on a set schedule. Spotify Playlists Retrieval**: Fetches the current playlists and filters them by owner. Track Details Collection**: Retrieves information such as track ID and popularity from the user’s library. Audio Features Fetching**: Uses Spotify's API to get audio features for each track. Data Merging**: Combines track information with their audio features. Duplicate Checking**: Filters out tracks that have already been logged in Google Sheets. Data Logging**: Archives new tracks into a Google Sheet. AI Classification**: Uses an AI model to classify tracks into suitable playlists. Playlist Updates**: Adds classified tracks to the corresponding playlists. Setup Instructions Credentials Setup: Make sure you have valid Spotify OAuth2 and Google Sheets access credentials. Trigger Configuration: Choose between manual or scheduled triggers to start the workflow. Google Sheets Preparation: Set up a Google Sheet with the necessary structure for logging track details. Spotify Playlists Setup: Have a diverse range of playlists and exhaustive description (see example) ready to accommodate different music genres and moods. Customization Options Adjust Playlist Conditions**: Modify the AI model’s classification criteria to align with your personal music preferences. Enhance Track Analysis**: Incorporate additional audio features or external data sources for more refined track categorization. Personalize Data Logging**: Customize which track attributes to log in Google Sheets based on your archival preferences. Configure Scheduling**: Set a preferred schedule for periodic track archiving, e.g., monthly or weekly. Cost Estimate For 300 tracks, the token usage amounts to approximately 60,000 tokens (58,000 for input and 2,000 for completion), costing around 20 cents with Claude 3.5 Sonnet (as of October 2024). Playlists' Description Examples | Playlist Name | Playlist Description | |-------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------| | Classique | Indulge in the timeless beauty of classical music with this refined playlist. From baroque to romantic periods, this collection showcases renowned compositions. | | Poi | Find your flow with this dynamic playlist tailored for poi, staff, and ball juggling. Featuring rhythmic tracks that complement your movements. | | Pro Sound | Boost your productivity and focus with this carefully selected mix of concentration-enhancing music. Ideal for work or study sessions. | | ChillySleep | Drift off to dreamland with this soothing playlist of sleep-inducing tracks. Gentle melodies and ambient sounds create a peaceful atmosphere for restful sleep. | | To Sing | Warm up your vocal cords and sing your heart out with karaoke-friendly tracks. Featuring popular songs, perfect for solo performances or group sing-alongs. | | 1990s | Relive the diverse musical landscape of the 90s with this eclectic mix. From grunge to pop, hip-hop to electronic, this playlist showcases defining genres. | | 1980s | Take a nostalgic trip back to the era of big hair and neon with this 80s playlist. Packed with iconic hits and forgotten gems, capturing the energy of the decade.| | Groove Up | Elevate your mood and energy with this upbeat playlist. Featuring a mix of feel-good tracks across various genres to lift your spirits and get you moving. | | Reggae & Dub | Relax and unwind with the laid-back vibes of reggae and dub. This playlist combines classic reggae tunes with deep, spacious dub tracks for a chilled-out vibe. | | Psytrance | Embark on a mind-bending journey with this collection of psychedelic trance tracks. Ideal for late-night dance sessions or intense focus. | | Cumbia | Sway to the infectious rhythms of Cumbia with this lively playlist. Blending traditional Latin American sounds with modern interpretations for a danceable mix. | | Funky Groove | Get your body moving with this collection of funk and disco tracks. Featuring irresistible basslines and catchy rhythms, perfect for dance parties. | | French Chanson | Experience the romance and charm of France with this mix of classic and modern French songs, capturing the essence of French musical culture. | | Workout Motivation | Push your limits and power through your exercise routine with this high-energy playlist. From warm-up to cool-down, these tracks will keep you motivated. | | Cinematic Instrumentals | Immerse yourself in a world of atmospheric sounds with this collection of cinematic instrumental tracks, perfect for focus, relaxation, or contemplation. |
by Romain Jouhannet
Linear Project/Issue Status and End Date to Productboard feature Sync Sync project and issue data between Linear and Productboard to keep teams aligned. This workflow updates Productboard features with the status and end date from Linear projects or due date from Linear issues. It ensures consistent data and sends a Slack notification whenever changes are made. Features Listens for updates in Linear projects/issues. Maps Linear statuses to Productboard feature statuses. Updates Productboard feature details including timeframe. Sends a Slack notification summarizing the updates. Setup Linear Credentials: Add your Linear API credentials in n8n. Productboard Credentials: Configure the Productboard API credentials in n8n. Linear Projects or Issues: Select the Linear project(s) or Issue(s) you want to monitor for updates. Productboard Custom Field: Create a custom field in Productboard named "Linear". This field should store the URL of the Linear project or issue you want to sync. Retrieve the UUID of the custom field in Productboard and set it up in the "Get Productboard Feature ID" node. Slack Notification: Update the Slack node with the desired Slack channel ID. Activate the Workflow: Enable the workflow to automatically sync data when triggered by updates in Linear.
by Frank Chen
Automatically fetch existing domains from Notion's Database and verify the validity of SSL certificates through SSL-Checker. If the validity period is less than 14 days, send a Telegram message notification and trigger SSH remote automatic refresh. Successful refresh notification will be sent through Telegram. This can prevent problems with the server-side automatic refresh program, which may cause unexpected service interruptions. Main use cases: Notion store domain. Telegram receives warning messages. Remotely trigger Certbot to refresh SSL. How it works: Record who triggered this workflow, because if there is a credential that is about to expire, this workflow will be triggered repeatedly. After getting all the domains from Notion, send an http request to SSL-Checker. After getting all the SSL-Checker results, add the validity label. And use the IF node to check if there are any certificates that are about to expire. Then there are two workflows: If there is a certificate that is about to expire: send an SSH command to the remote control server to refresh the certificate, notify through Telegram, and call this workflow again to re-verify the validity of the SSL certificate. If the validity period of SSL is normal: then refresh the data on Notion, and if a re-called workflow is detected, Telegram will be used to notify that the SSL has been updated.
by Keith Rumjahn
Who's this for? If you own a website and need to analyze your Google analytics data If you need to create an SEO report on which pages are getting most traffic or how your google search terms are performing If you want to grow your site based on suggestions from data Use case Instead of hiring an SEO expert, I run this report weekly. It checks compares the data from this week to the week before: Views based on countries The top performing pages Google search console performance Watch youtube tutorial here Get my SEO A.I. agent system here Read my detailed case study here How it works The workflow gathers google analytics for the past 7 days then it gathers the data for the week before for comparison. It does this 3 times to get: views per country, engagement per page and google search console results for organic search results. The google analytics nodes has already chosen the correct dimensions and metrics. At the end, it passes the data to openrouter.ai for A.I. analyse. Finally it saves to baserow. How to use this Input your Google analytics credentials Input your property ID Input your Openrouter.ai credentials Input your baserow credentials You will need to create a baserow database with columns: Name, Country Views, Page Views, Search Report, Blog (name of your blog). Created by Rumjahn
by Dvir Sharon
💼 LinkedIn Job Finder Automation using Bright Data API & Google Sheets A comprehensive n8n automation that searches LinkedIn job postings using Bright Data’s API and automatically organizes results in Google Sheets for efficient job hunting and recruitment workflows. 📋 Overview This workflow provides an automated LinkedIn job search solution that collects job postings based on your search criteria and organizes them in Google Sheets. Perfect for job seekers, recruiters, HR professionals, and talent acquisition teams. ✨ Key Features 🔍 Smart Job Search:** Form-based input for city, job title, country, and job type 🛍 LinkedIn Integration:** Uses Bright Data’s LinkedIn dataset for accurate job posting data 📊 Automated Organization:** Populates Google Sheets with structured job data 📧 Real-time Processing:** Processes job search requests in real-time 📈 Data Storage:** Stores job details including company info, locations, and apply links 🔄 Batch Processing:** Handles multiple job postings efficiently ⚡ Fast & Reliable:** Built-in error handling for scraping 🎯 Customizable Filters:** Advanced job filtering based on criteria 🎯 What This Workflow Does Input Job Search Criteria:** City, job title, country, and optional job type Search Parameters:** Configurable filters and limits Output Preferences:** Google Sheets destination Processing Steps Form Submission Data Request to Bright Data API Status Monitoring Data Extraction Data Filtering Sheet Update Error Handling Output Data Points Field Description Example Job Title Position title from posting Senior Software Engineer Company Name Employer company name Tech Solutions Inc. Job Detail Job summary/description Remote position requiring 5+ years… Location Job location San Francisco, CA Company URL Company profile link View Profile Apply Link Direct application link Apply Now 🚀 Setup Instructions Prerequisites n8n instance (self-hosted or cloud) Google account with Sheets access Bright Data account with LinkedIn dataset access Steps Import the Workflow: Use JSON import in n8n Configure Bright Data: Add API credentials and dataset ID Configure Google Sheets: Create sheet, set credentials, map columns Update Workflow Settings: Replace placeholders with your actual data Test & Activate: Submit test form and verify data in Google Sheets 📖 Usage Guide Submitting Job Searches Go to your webhook URL and fill in the form with: City:** e.g., New York Job Title:** e.g., Software Engineer Country:** e.g., US Job Type:** Optional (Full-Time, Remote, etc.) Understanding Results Comprehensive job data Company info and profile links Direct application links Location and job descriptions Customizing Search Parameters Edit the Create Snapshot ID node to change: Time range (e.g., “Past month”) Result limits Company filters 🔧 Customization Options More Data Points:** Add salary, seniority, applicants, etc. Custom Form Fields:** Add filters for salary, experience, industry Multiple Sheets:** Route results by job type or location 🚨 Troubleshooting Bright Data connection failed:** Check API credentials and dataset access No job data extracted:** Verify search parameters and API limits Google Sheets permission denied:** Re-authenticate and check sharing Form not working:** Check webhook URL and field mappings Filter issues:** Review logic and data types Execution failed:** Check logs, retry logic, and network status 📊 Use Cases & Examples Job Seeker Dashboard:** Automate job search and track applications Recruitment Pipeline:** Source candidates and monitor hiring trends Market Research:** Analyze job trends and salary benchmarks HR Analytics:** Support workforce planning and competitive insights ⚙️ Advanced Configuration Batch Processing:** Queue multiple searches with delays Search History:** Track and analyze past searches Tool Integration:** Connect to CRM, Slack, databases, BI tools 📈 Performance & Limits Processing Time:** 30–60 seconds per search Concurrent Requests:** 2–3 (depends on Bright Data plan) Data Accuracy:** 95%+ Success Rate:** 90%+ Daily Capacity:** 50–200 searches Memory:** ~50MB per execution API Calls:** 3–4 Bright Data + 1 Google Sheets per search 🤝 Support & Community n8n Community:** community.n8n.io Documentation:** docs.n8n.io Bright Data Support:** Via your Bright Data dashboard GitHub Issues:** Report bugs and request features 🎯 Ready to Use! Your workflow is ready for automated LinkedIn job searching. Customize it to your recruiting or job search needs. Webhook URL: https://your-n8n-instance.com/webhook/linkedin-job-finder What Gets Extracted: * ✅ Job Title * ✅ Company Information * ✅ Location Data * ✅ Job Details * ✅ Application Links * ✅ Processing Timestamps ### Use Cases: * 🔍 Job Search Automation * 📊 Recruitment Intelligence * 📝 Market Research * 🎯 HR Analytics