Web site scraper for LLMs with Airtop
Recursive Web Scraping Use Case Automating web scraping with recursive depth is ideal for collecting content across multiple linked pages—perfect for content aggregation, lead generation, or research projects. What This Automation Does This automation reads a list of URLs from a Google Sheet, scrapes each page, stores the content in a document, and adds newly discovered links back to the sheet. It continues this process for a specified number of iterations based on the defined scraping depth. Input Parameters: Seed URL: The starting URL to begin the scraping process. Example: https://example.com/ Links must contain: Restricts the links to those that contain this specified string. Example: https://example.com/ Depth: The number of iterations (layers of links) to scrape beyond the initial set. Example: 3 How It Works Starts by reading the Seed URL from the Google Sheet. Scrapes each page and saves its content to the specified document. Extracts new links from each page that match the Links must contain string, appends them to the Google Sheet. Repeats steps 2–3 for the number of times specified by Depth - 1. Setup Requirements Airtop API Key — free to generate. Credentials set up for Google Docs (requires creating a project on Google Console). Read how to. Credentials set up for Google Spreadsheet. Next Steps Add Filtering Rules: Filter which links to follow based on domain, path, or content type. Combine with Scheduler: Run this automation on a schedule to continuously explore newly discovered pages. Export Structured Data: Extend the process to store extracted data in a CSV or database for analysis. Read more about website scraping for LLMS
By AirtopGenerate 360 social media reports with AI - Bright Data MCP
Social Media Intelligence Workflow with Bright Data and OpenAI Get a 360 Social media presence report for a person Who's it for Business development professionals, recruiters, sales teams, and market researchers who need comprehensive social media intelligence on individuals for lead qualification, due diligence, partnership evaluation, or candidate assessment. How it works Enter target person's details through the web form (name, company, location) AI Discovery Agent searches across selected platforms using name variations Profile validator verifies discovered profiles with confidence scoring Platform-specific agents analyze each profile using Bright Data MCP tools GPT-4 synthesizes all data into a comprehensive intelligence report Report automatically generated as formatted Google Doc with direct link Requirements Bright Data MCP account with PRO access (Get your Bright Data API key here) OpenAI API key (or alternative LLM provider) Google Drive OAuth connection for report delivery n8n self-hosted instance or cloud account How to set up Update Bright Data credentials: Find "Bright Data MCP" node (look for red warning note) Replace YOURBRIGHTDATATOKENHERE with your actual token Update UNLOCKERCODEHERE with your unlocker code Update Google Drive settings: Find "Create Empty Google Doc" node Select target folder there Configure your LLM credentials (OpenAI or alternative) Test with your own name using "Basic" search depth Watch Youtube Tutorial How to customize the workflow Add platforms: Extend the Switch node with new cases and create corresponding prompt builders Modify analysis depth: Edit the platform-specific prompt builders to focus on different metrics Change report format: Update the final LLM Chain prompt to adjust report structure Add notifications: Insert Slack or email nodes after report generation Adjust confidence thresholds: Modify validators to change profile verification requirements Alternative outputs: Replace Google Docs with PDF, Excel, or webhook to CRM
By Romuald CzłonkowskiAI call summary to HubSpot + follow-up task
This n8n template turns raw call transcripts into clean HubSpot call logs and a single, actionable follow-up task—automatically. Paste a transcript and the contact’s email; the workflow finds the contact, summarizes the conversation in 120–160 words, proposes the next best action, and (optionally) updates missing contact fields. Perfect for reps and founders who want accurate CRM hygiene without the manual busywork. --- How it works A form trigger collects two inputs: Contact email Plain-text call transcript The workflow looks up the HubSpot contact by email to pull known properties. An AI agent reads the transcript (plus known fields) to: Extract participants, role, problem/opportunity, requirements, blockers, timeline, and metrics. Write a 120–160 word recap a teammate can skim. Generate one concrete follow-up task (title + body). Suggest updates for missing contact properties (city, country, job title, job function). The recap is logged to HubSpot as a completed Call engagement. The follow-up is created in HubSpot as a Task with subject and body. (Optional) The contact record is updated using AI-suggested values if the transcript clearly mentions them. --- How to use Connect HubSpot (OAuth2) on all HubSpot nodes. Connect OpenAI on the AI nodes. Open Form: Capture Transcript, submit the email + transcript. (Optional) In AI: Summarize Call & Draft Task, tweak prompt rules (word count, date normalization). (Optional) In Update Contact from Transcript, review the mapped fields before enabling in production. Activate the workflow and paste transcripts after each call. --- Requirements HubSpot (OAuth2) for contact search, call logging, and tasks OpenAI for summarization and task drafting --- Notes & customization ideas Swap the form for a Google Drive or S3 watcher to ingest saved transcripts. Add a speech-to-text step if you store audio recordings. Extend Update Contact to include additional fields (timezone, department, seniority). Post the summary to Slack or email the AE for quick handoffs. Gate updates with a confidence check, or route low-confidence changes for manual approval.
By MihaAmplify social media presence with O3 and GPT-4 multi-agent team
Amplify Social Media Presence with O3 and GPT-4 Multi-Agent Team 🌍 Overview This n8n workflow acts like a virtual social media department. A Social Media Director Agent coordinates multiple specialized AI agents (Instagram, Twitter/X, Facebook, TikTok, YouTube, and Analytics). Each agent creates or analyzes content for its platform, powered by OpenAI models. The result? A fully automated, cross-platform social media strategy—from content creation to performance tracking. --- 🟢 Section 1: Trigger & Director Setup 🔗 Nodes: When chat message received (Trigger) → Starts the workflow whenever you send a request (e.g., “Plan a TikTok campaign for my product launch”). Social Media Director Agent (connected to OpenAI O3 model) → Acts as the strategist. Think Tool → Helps the Director “reason” before delegating. 💡 Beginner takeaway: This section makes your workflow interactive. You send a request → the Director decides the best approach → then it assigns tasks. 📈 Advantage: Instead of manually planning content per platform, you only send one command, and the AI Director handles the strategy. --- 🟦 Section 2: Specialized Social Media Agents 🔗 Nodes (each paired with GPT-4.1-mini): 📸 Instagram Content Creator → Visual storytelling, Reels, Hashtags 🐦 Twitter/X Strategist → Viral tweets, trends, engagement 👥 Facebook Community Manager → Audience growth, ads, group engagement 🎵 TikTok Video Creator → Short-form video, viral trends 🎬 YouTube Content Planner → Long-form strategy, SEO, thumbnails 📊 Analytics Specialist → Performance insights, cross-platform reporting 💡 Beginner takeaway: Each platform has its own AI expert. They receive the Director’s strategy and produce tailored content for their platform. 📈 Advantage: Instead of one-size-fits-all posts, you get optimized content per platform—increasing reach and engagement. --- 🟣 Section 3: Models & Connections 🔗 Nodes: OpenAI Chat Models (O3 + multiple GPT-4.1-mini models) Each model is connected to its respective agent. 💡 Beginner takeaway: Think of these as the “brains” behind each specialist. The Director uses O3 for advanced reasoning, while the specialists use GPT-4.1-mini (cheaper, faster) for content generation. 📈 Advantage: This keeps costs low while maintaining quality output. --- 📊 Final Overview Table | Section | Nodes | Purpose | Benefit | | --------------------- | -------------------------------------------------------- | -------------------------------------- | ------------------------------ | | 🟢 Trigger & Director | Chat Trigger, Director, Think Tool | Capture requests & plan strategy | One command → full social plan | | 🟦 Specialists | Instagram, Twitter, Facebook, TikTok, YouTube, Analytics | Platform-specific content | Optimized posts per platform | | 🟣 Models | O3 + GPT-4.1-mini | Provide reasoning & content generation | High-quality, cost-efficient | --- 🚀 Why This Workflow is Powerful Multi-platform coverage: All major platforms handled in one flow Human-like strategy: Director agent makes real marketing decisions Scalable & fast: Generate a full campaign in minutes Cost-effective: O3 only for strategy, GPT-4.1-mini for bulk content Beginner-friendly: Just type your request → get full campaign output ---
By Yaron BeenConvert task ideas to implementation plans with GPT-4o, Slack & Google Sheets
🚀 Turn your random ideas into concrete automation specs This workflow acts as your interactive "n8n Consultant." Simply write down a rough automation idea in Google Tasks (e.g., "Send weather updates to Telegram"), and the AI will research, design, and send a detailed n8n implementation plan to your Slack. ✨ Why is this workflow special? Unlike simple notification workflows, this features a Human-in-the-Loop review process. You don't just get a message; you get control. Regenerate: Not satisfied with the AI's plan? Click a button in Slack to have the AI rewrite it instantly. Archive: Happy with the plan? Click "Approve" to automatically save the detailed specs to Google Sheets and mark the task as complete. How it works Fetch: The workflow periodically checks a specific Google Tasks list for new ideas. AI Design: The AI (OpenAI) analyzes your idea and generates a structured plan, including node configuration and potential pitfalls. Human Review: It sends the plan to Slack with interactive "Approve" and "Regenerate" buttons. The workflow waits for your input. If Regenerate: The AI re-analyzes the idea and creates a new variation. If Approve: The workflow proceeds to the next step. Archive: The approved plan (Title, Nodes, Challenges) is saved to a Google Sheet for future development. Close: The original Google Task is updated with a "Processed" flag. How to set up Google Tasks: Create a new list named "n8n Ideas". Google Sheets: Create a new sheet with the following headers in the first row (A to H): Date Added Idea Title Status Recommended Nodes Key Challenges Improvement Ideas Alternatives Source Task ID Credentials: Configure credentials for Google Tasks, Google Sheets, OpenAI, and Slack. Configure Nodes: [Step 1] Fetch New Ideas: Select your Task list. [Step 4] Slack — Review & Approve: Select your target channel. [Action] Archive to Sheets: Select your Spreadsheet and Sheet. [Close] Mark Task Done: Select your Task list again. Requirements Google Tasks account Google Sheets account OpenAI API Key Slack account
By Shun NakayamaCreate an intelligent FAQ Telegram bot with Google Gemini and Supabase
Overview This template creates a smart FAQ bot on Telegram, powered by Google Gemini for intelligent answers and Supabase to store user data. The workflow can distinguish between new and existing users. How It Works Trigger: The workflow starts when a user sends any message to the Telegram Bot. Check User: It looks up the user's chatid in a Supabase telegramusers table. Route (New vs. Existing): New User (True Path): If the user is not found, the workflow saves their chat_id to Supabase and sends a one-time welcome message. Existing User (False Path): If the user exists, the workflow proceeds to the AI step. Generate Answer: It loads a predefined FAQ context and combines it with the user's question. This is sent to Google Gemini via the AI Agent node. Send Response: The AI-generated answer is sent back to the user on Telegram. Setup Instructions Telegram: Connect your Telegram credentials to the Telegram Trigger and both Send a text message nodes. Supabase: Connect your Supabase credentials to the Find user in DB and Create a row nodes. You MUST have a table named telegram_users. This table MUST have a column named chat_id (type: text or varchar). Google Gemini: Connect your Google Gemini (Palm API) credentials to the Google Gemini Chat Model node. (REQUIRED) Customization: Open the Set FAQ Context node and change its contents with Questions (Q) and Answers (A) that are appropriate for your bot. Change the text in the Send a text message (Welcome Message) node as you want.
By Mohammad JibrilAutomate faceless shorts with OpenAI, RunwayML & ElevenLabs: script to social media
⚙️ Faceless YouTube Generator - Automate Faceless YouTube Shorts with AI: Generate Scripts, Videos, Audio, and Captions in Minutes! Tired of grinding out YouTube content? This n8n workflow turns AI into your personal video factory—creating engaging, faceless shorts on autopilot. Perfect for creators, marketers, or side-hustlers looking to monetize without showing your face. From script writing to final upload, it's all handled: AI-generated scripts (optimized for 20-second hooks), stunning image-to-video animations via RunwayML, immersive audio with ElevenLabs, and pro captions. Scale your channel effortlessly and watch the views (and revenue) roll in! 🧑💻 Author: LeeWei --- 🚀 How It Works • Trigger & Script Magic: Starts via Google Sheets webhook—AI crafts a punchy 213-223 character script (via Anthropic) for ~20-second shorts, ensuring viral potential. • Visuals on Autopilot: Splits scenes, generates high-quality images with OpenAI, then animates them into videos using RunwayML's Gen3a Turbo. • Audio Layering: Adds soothing background sounds and professional voice-overs (Adam voice) via ElevenLabs for that polished, immersive feel. • Final Polish & Upload: Merges everything in Creatomate, slaps on captions with Replicate, uploads to Google Drive/YouTube, and updates your sheet—ready to post! Setup takes 15-20 minutes with API keys. Plug-and-play: Import the JSON into n8n, and you're set—edit only API tokens and credentials as noted. 🚀 Steps to Connect: Google Sheets & Drive Setup Use your existing Google OAuth2 credentials in the "Google Sheets" and "Google Drive" nodes. Clone the demo sheet (ID: 1Co9tTJelYyefLLxzkoOhUBU3XuQIspBpDudtZLynW2M) and update the ID in "Update Video Status" if needed. Tweak folder IDs in "Upload to Drive" nodes for custom storage. Anthropic API Key Head to Anthropic and grab your API key. Paste it into the "Anthropic Chat Model" node credentials. OpenAI API Key Visit OpenAI for your API key. Add it to the "OpenAI Chat Model" node credentials. RunwayML API Key Sign up at RunwayML and get your token. Replace "YOURAPITOKEN" in the "Authorization" headers of "Generate Videos" and "Get Generated Videos" HTTP nodes. ElevenLabs API Key Go to ElevenLabs and generate your key. Swap "YOURAPITOKEN" in the "xi-api-key" headers of "Generate Audio (Background sound)" and "Text to Speech (Adam Voice)" nodes. Creatomate API Key Register at Creatomate for your token. Update "YOURAPITOKEN" in the "Authorization" header of the "Render Video with Creatomate" HTTP node. Replicate API Key Get your token from Replicate. Insert "YOURAPITOKEN" in the "Authorization" header of the "Add Captions - replicate" HTTP node. (Optional) YouTube Upload For direct uploads, add your Google YouTube OAuth credentials to the "Upload Video" node.
By LeeWeiQualify & route leads with GPT-4o, Clearbit, HubSpot CRM & Slack alerts
How it works • Webhook receives lead form submissions from your website • AI Agent (GPT-4o) analyzes lead quality using intelligent scoring framework • Clearbit enriches company data automatically (employee count, industry, revenue) • Qualification score (0-100) determines routing: high-quality leads → HubSpot CRM + Slack alert, low-quality leads → Airtable for manual review • Structured output parser ensures reliable JSON formatting every time Set up steps • Time to set up: 15-20 minutes • Import the Clearbit sub-workflow first (separate workflow file included) • Create 7 custom properties in HubSpot (qualificationscore, buyingintent, urgencylevel, budgetindicator, aisummary, painpoints, recommended_action) • Create Airtable base with 14 columns for low-quality lead tracking • Get Slack channel IDs for sales alerts and review requests • Add credentials: OpenAI (GPT-4o), Clearbit API, HubSpot OAuth2, Slack OAuth2, Airtable Token • Replace placeholder IDs in Slack and Airtable nodes • Configure the Clearbit Enrichment Tool node with your sub-workflow ID What you'll need • OpenAI API - OpenAI model access for AI qualification • Clearbit API - Free tier available for company enrichment • HubSpot - Free CRM account works • Slack - Standard workspace • Airtable - Free plan works • Website form - To send webhook data Who this is for Sales teams and agencies that want to automatically qualify inbound leads before they hit the CRM. Perfect for B2B companies with high lead volume that need intelligent routing.
By GreypillarAI-powered outreach & follow-up automation (GPT-4o + Gmail + Google Sheets)
Description Automate your AI-powered outreach and follow-up pipeline end-to-end with GPT-4o, Gmail, and Google Sheets. 🤖📬 This workflow personalizes emails for each lead, manages follow-ups automatically, tracks client replies, and updates CRM records in real time — all from a single Google Sheet. Ideal for sales and growth teams looking to convert leads faster without manual effort. ⚙️🚀 What This Template Does 1️⃣ Starts manually when you click “Execute workflow.” 🕹️ 2️⃣ Fetches all leads from the Google Sheet (sampleleads50). 📊 3️⃣ Validates email format and filters only active (unbooked) leads. 🔍 4️⃣ Uses Azure OpenAI GPT-4o to generate short, personalized outreach emails in HTML. ✉️ 5️⃣ Cleans and parses the AI output (subject + HTML body). 🧠 6️⃣ Sends the first outreach email via Gmail and stores its thread ID. 📤 7️⃣ Waits 24 hours, then checks for a client reply in the Gmail thread. ⏱️ 8️⃣ If a positive reply is found → marks lead as BOOKED and updates in Sheets. ✅ 9️⃣ If no reply → triggers a polite follow-up email, waits again 24 hours, and checks the thread a second time. 🔁 🔟 If a second reply is found → marks BOOKED and logs the client message. 1️⃣1️⃣ If still no response → updates status to Declined in Google Sheets. ❌ 1️⃣2️⃣ Logs invalid or incomplete leads to a separate sheet for data cleanup. 🧾 Key Benefits ✅ Eliminates manual outreach and follow-up effort. ✅ Produces personalized, context-aware AI emails for every lead. ✅ Auto-tracks replies and updates CRM status with zero input. ✅ Prevents duplicate or repeated contact with booked clients. ✅ Keeps lead database synchronized and audit-ready. Features Google Sheets integration for dynamic lead retrieval and updates. Regex-based email validation for clean data pipelines. Azure OpenAI GPT-4o for contextual email writing. Two-stage Gmail automation (initial + follow-up). JavaScript parsing for AI output and Gmail thread analysis. Automated 24-hour wait and recheck logic. Conditional branches for Booked / Declined / Invalid outcomes. End-to-end CRM synchronization without manual review. Requirements Google Sheets OAuth2 credentials with read/write access. Azure OpenAI API key for GPT-4o model access. Gmail OAuth2 credentials with send, read, modify permissions. Environment Variables GOOGLESHEETLEADS_ID GOOGLESHEETOUTREACHTABID AZUREOPENAIAPI_KEY GMAILOAUTHCLIENT_ID GMAILOAUTHSECRET Target Audience 💼 Sales and Business Development teams automating outreach. 📈 Marketing and Growth teams running re-engagement campaigns. 🤖 Automation and RevOps teams integrating AI lead workflows. 💬 Freelancers and agencies managing large prospect lists. 📊 Operations teams maintaining CRM cleanliness and tracking. Step-by-Step Setup Instructions 1️⃣ Connect your Google Sheets, Azure OpenAI, and Gmail credentials. 2️⃣ Set your Google Sheet ID and tab name (outreach automation). 3️⃣ Update the GPT-4o system prompt to match your tone and signature. 4️⃣ Verify column headers (Company Name, Email, Booking Status, etc.). 5️⃣ Test the email validation branch with sample data. 6️⃣ Run once manually to confirm Gmail thread creation and reply detection. 7️⃣ Confirm successful CRM updates in Google Sheets. 8️⃣ Activate for continuous lead outreach and follow-up automation. ✅
By Rahul JoshiEpa clean water act data access & compliance monitoring API integration
⚠️ ADVANCED USE ONLY - U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services MCP Server (36 operations) 🚨 This workflow is for advanced users only! Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community This MCP server contains 36 operations which is significantly more than the recommended maximum of tools for most AI clients. 🔍 Recommended Alternative for basic use cases Seek a simplified MCP server that utilizes the official n8n tool implementation for U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services if available, or an MCP server with only common operations as it will be more efficient and easier to manage. 🛠️ Advanced Usage Requirements BEFORE adding this MCP server to your client: Disable or delete unused nodes - Review sections and disable/delete those you don't need AFTER adding the MCP server to your client: 1.Selective tool enabling - Instead of enabling all tools (default), manually select only the specific tools you need for that Workflow's MCP client. Monitor performance - Too many tools can slow down AI responses 💡 Pro Tips Keep maximum 40 enabled tools - Most AI clients perform better with fewer tools Group related operations and only enable one group at a time Use the overview note to understand what each operation group does Ping me on discord if your business needs this implemented professionally ⚡ Quick Setup Import this workflow into your n8n instance Credentials Add U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services credentials Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL 🔧 How it Works This workflow converts the U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services API into an MCP-compatible interface for AI agents. • MCP Trigger: Serves as your server endpoint for AI agent requests • HTTP Request Nodes: Handle API calls to https://echodata.epa.gov/echo • AI Expressions: Automatically populate parameters via $fromAI() placeholders • Native Integration: Returns responses directly to the AI agent 📋 Available Operations (36 total) 🔧 CwaRestServices.Get_Download (2 endpoints) • GET /cwarestservices.get_download: Submit CWA Download Data • POST /cwarestservices.get_download: Clean Water Act (CWA) Download Data Service 🔧 CwaRestServices.Get_Facilities (2 endpoints) • GET /cwarestservices.get_facilities: Submit CWA Facility Search • POST /cwarestservices.get_facilities: Clean Water Act (CWA) Facility Search Service 🔧 CwaRestServices.GetFacilityInfo (2 endpoints) • GET /cwarestservices.getfacilityinfo: Submit CWA Facility Details • POST /cwarestservices.getfacilityinfo: Clean Water Act (CWA) Facility Enhanced Search Service 🔧 CwaRestServices.Get_Geojson (2 endpoints) • GET /cwarestservices.get_geojson: Submit CWA GeoJSON Data • POST /cwarestservices.get_geojson: Clean Water Act (CWA) GeoJSON Service 🔧 CwaRestServices.GetInfoClusters (2 endpoints) • GET /cwarestservices.getinfoclusters: Submit CWA Info Clusters • POST /cwarestservices.getinfoclusters: Clean Water Act (CWA) Info Clusters Service 🔧 CwaRestServices.Get_Map (2 endpoints) • GET /cwarestservices.get_map: Submit CWA Map Data • POST /cwarestservices.get_map: Clean Water Act (CWA) Map Service 🔧 CwaRestServices.Get_Qid (2 endpoints) • GET /cwarestservices.get_qid: Submit CWA Paginated Results • POST /cwarestservices.get_qid: Clean Water Act (CWA) Paginated Results Service 🔧 CwaRestServices.Metadata (2 endpoints) • GET /cwarestservices.metadata: Submit CWA Metadata • POST /cwarestservices.metadata: Clean Water Act (CWA) Metadata Service 🔧 RestLookups.BpTribes (2 endpoints) • GET /restlookups.bptribes: Submit BP Tribes Data • POST /restlookups.bptribes: ECHO BP Tribes Lookup Service 🔧 RestLookups.CwaParameters (2 endpoints) • GET /restlookups.cwaparameters: Submit CWA Parameters • POST /restlookups.cwaparameters: ECHO CWA Parameter Lookup Service 🔧 RestLookups.CwaPollutants (2 endpoints) • GET /restlookups.cwapollutants: Submit CWA Pollutants • POST /restlookups.cwapollutants: ECHO CWA Pollutants Lookup Service 🔧 RestLookups.FederalAgencies (2 endpoints) • GET /restlookups.federalagencies: Submit Federal Agencies • POST /restlookups.federalagencies: ECHO Federal Agency Lookup Service 🔧 RestLookups.IcisInspection_Types (2 endpoints) • GET /restlookups.icisinspection_types: Submit ICIS Inspection Types • POST /restlookups.icisinspection_types: ECHO ICIS NPDES Inspection Types Lookup Service 🔧 RestLookups.IcisLaw_Sections (2 endpoints) • GET /restlookups.icislaw_sections: Submit ICIS Law Sections • POST /restlookups.icislaw_sections: ECHO ICIS NPDES Law Sections Lookup Service 🔧 RestLookups.NaicsCodes (2 endpoints) • GET /restlookups.naicscodes: Submit NAICS Codes • POST /restlookups.naicscodes: ECHO NAICS Codes Lookup Service 🔧 RestLookups.NpdesParameters (2 endpoints) • GET /restlookups.npdesparameters: Submit NPDES Parameters • POST /restlookups.npdesparameters: ECHO NPDES Parameters Lookup Service 🔧 RestLookups.WbdCode_Lu (2 endpoints) • GET /restlookups.wbdcode_lu: Submit WBD Codes • POST /restlookups.wbdcode_lu: ECHO WBD Code Lookup Service 🔧 RestLookups.WbdName_Lu (2 endpoints) • GET /restlookups.wbdname_lu: Submit WBD Names • POST /restlookups.wbdname_lu: ECHO WBD Name Lookup Service 🤖 AI Integration Parameter Handling: AI agents automatically provide values for: • Path parameters and identifiers • Query parameters and filters • Request body data • Headers and authentication Response Format: Native U.S. EPA Enforcement and Compliance History Online (ECHO) - Clean Water Act (CWA) Rest Services API responses with full data structure Error Handling: Built-in n8n HTTP request error management 💡 Usage Examples Connect this MCP server to any AI agent or workflow: • Claude Desktop: Add MCP server URL to configuration • Cursor: Add MCP server SSE URL to configuration • Custom AI Apps: Use MCP URL as tool endpoint • API Integration: Direct HTTP calls to MCP endpoints ✨ Benefits • Zero Setup: No parameter mapping or configuration needed • AI-Ready: Built-in $fromAI() expressions for all parameters • Production Ready: Native n8n HTTP request handling and logging • Extensible: Easily modify or add custom logic > 🆓 Free for community use! Ready to deploy in under 2 minutes.
By David AshbyAutomatically update Amazon transaction memos in YNAB with AI & Gmail
Who it's for ------------ This workflow is ideal for YNAB users who frequently shop on Amazon and want their transaction memos to automatically show itemized purchase details. It's especially helpful for people who import bank transactions into YNAB and want to keep purchase records tidy without manual entry. How it works ------------ The workflow triggers on a set schedule, via a webhook, or manually. It retrieves all unapproved transactions from your YNAB budget, filters for Amazon purchases with empty memo fields, and processes each transaction individually. Using Gmail, it searches for matching Amazon emails (within ±5 days of the transaction date) and sends the email data to an AI agent powered by OpenAI. The AI extracts product names and prices, generating a concise memo line (up to 499 characters). If no valid purchase info is found, a fallback message is added instead. A 5-second delay prevents API rate limiting. How to set up ------------- Connect your YNAB account with valid API credentials. Connect Gmail with OAuth2 authentication. Add your OpenAI (or other LLM) API credentials. Configure the schedule trigger or use manual/webhook start. Run the workflow and monitor execution logs in n8n. Requirements ------------ YNAB API credentials Gmail OAuth2 connection OpenAI API key (or another compatible AI model) How to customize ---------------- You can change the AI model (e.g., Gemini or Claude) or add HTML-to-Markdown conversion to lower token costs. Adjust the wait node delay to fit your API rate limits or modify the email date range for greater accuracy. Security note: Never store or share API keys or personal email data directly in the workflow. Use credential nodes to manage sensitive information securely.
By Angel MenendezConvert YouTube videos to audio summaries with Decodo, OpenAI & Telegram
Stop watching long videos, start listening to concise summaries. This workflow transforms any YouTube video URL sent via Telegram into a high-quality, spoken audio summary (MP3) and a structured text overview. It acts as your personal AI research assistant, turning lengthy content into bite-sized audio files that you can consume on the go. It leverages Decodo for robust transcript extraction, OpenAI for intelligent summarization, and for realistic text-to-speech generation. --- ✨ Features Telegram-First Interface: Send links and receive audio directly in your chat app. Smart Validation: Automatically checks if the link is a valid YouTube URL before processing to save API credits. Multi-Language Support: Easily configure the output language (English, Spanish, German, etc.) via a simple Config node. The AI will translate and speak in this language. Robust Error Handling: Gracefully handles videos with no captions/transcripts by notifying the user instead of breaking the workflow. Structured Data Extraction: Uses AI to extract the Genre, Title, and Summary alongside the audio file. ⚙️ How it Works Trigger: You send a YouTube URL to your Telegram Bot. Validate: The workflow checks the URL pattern using Regex. Extract: Decodo scrapes the video page to retrieve the full transcript JSON. Process: A Code node flattens the complex JSON into a readable text format. Summarize: OpenAI (gpt-4o-mini) analyzes the text and writes a script optimized for listening. Speak: OpenAI converts the script into a high-definition MP3 file. Deliver: The bot replies with the Audio File and a formatted text summary including the genre tags and original link. --- 📥 Decodo Node Installation The Decodo node is used in this workflow for fetching the YouTube Transcript. Find the Node: Click the + button in your n8n canvas. Search: Search for the Decodo node and select it. Credentials: When configuring the first Decodo node, use your API key (obtained with the 80% discount coupon). Setup: Open the Decodo (Fetch YouTube Transcript) node to ensure it is correctly targeting the YouTube service. ----- 🎁 Exclusive Deal for n8n Users To run this workflow, you require a robust scraping provider. We have secured a massive discount for Decodo users: Get 80% OFF the 23k Advanced Scraping API plan. Coupon Code: ATTAN8N Sign Up Here: Claim 80% Discount on Decodo --- ➕ How to Adapt the Template This workflow is highly flexible and can be modified for various content tasks: Change AI Model: Easily swap the OpenAI Chat Model node with an OpenAI or Anthropic (Claude) node without altering the core logic. Create Long-Form Drafts: Modify the AI System Prompt to generate a full 1,000-word blog post draft or a set of social media updates instead of a short audio script. Change Destination: Replace the Telegram nodes with Slack, Microsoft Teams, Email (Gmail/SMTP), or Discord to deliver the audio and summary to your preferred channel. Create an Archive: Connect the successful output to a Google Sheets or Airtable node to keep a searchable archive of every video summary created.
By Atta