by AppUnits AI
Generate Invoices for Customers with Jotform, Xero and Gmail This workflow automates the entire process of receiving a product/service order, checking or creating a customer in Xero, generating an invoice, and emailing it — all triggered by a form submission (via Jotform). How It Works Receive Submission Triggered when a user submits a form. Collects data like customer details, selected product/service, etc. Create/Update The Customer Creates/Updates the customer. Create The Invoice Generates a new invoice for the customer using the item selected. Send The Invoice Automatically sends the invoice via email to the customer. Who Can Benefit from This Workflow? Freelancers** Service Providers** Consultants & Coaches** Small Businesses** E-commerce or Custom Product Sellers** Requirements Jotform webhook setup, more info here Xero credentials, more info here Make sure that products/services values in Jotform are exactly the same as your item Code in your Xero account Email setup, update email node (Send email), more info about Gmail setup here LLM model credentials
by Dhruv from Saleshandy
Automatically import new user signups from any database, filter by signup date, and enroll users into your Saleshandy email sequence for immediate engagement. Activity is logged to a spreadsheet (e.g., Google Sheets) for tracking and analytics. Fully configurable, no hardcoded values. Prerequisites A database with a users table (fields: id, full_name, email, created_at) Saleshandy account with API key and an active sequence. Spreadsheet (e.g., Google Sheets) with columns: ID, Name, Email, Created_at Configured OAuth/API credentials for each service How It Works Fetches new signups from your database within your desired date range (e.g., daily or weekly). Splits user names and formats user data as needed. Adds each user to your Saleshandy sequence using their name and email. Logs every processed record in your spreadsheet for further tracking and analytics. Runs automatically on your defined schedule (example: daily trigger). Set Up Steps Estimated time: 10–20 minutes Collect your database and Saleshandy access credentials, and spreadsheet info. Edit database node(s) to include your connection and correct date filter. Set your Saleshandy API key and target sequence ID. Enter your spreadsheet link or ID and authenticate as needed. Test the workflow with a small user batch before scheduling it for routine runs. Check sticky notes by each workflow node for details and best practices. Requirements Database connection credentials and access Saleshandy API key and sequence ID Google Sheets (or alternative) setup credentials Customisation Tips Edit the date filter to adjust the range (last day, week, month, or custom) Add error-handling nodes to catch issues with API calls or data Set up notifications (email, Slack, etc.) for process success/failure Rename nodes to reflect your business logic or steps Replace the manual trigger with a webhook or scheduled cron if desired Configure workflow variables for all credentials and IDs—avoid hardcoding
by Daniel Rosehill
This workflow provides a mechanism for using AI transcribed voice notes using Voicenotes AI and then running them into an AI agent as prompts. On the "collection" end of the workflow, we gather the output (with the recorded prompt) and do two things: 1) It is saved into NocoDB as a new row on a database table recording AI outputs and prompts. 2) The prompt gets sent to an AI agent and the output gets returned to the user's email Who Is It For? If you like using voice AI tools to write detailed prompts for AI, then this workflow helps to remove the points of friction in getting from A to B! How Does It Work? Simply tag your voice note in Voicenotes with your preferred tag (I'm using 'prompt'). Then, provide the N8N webhook as the URL for a webhook that will trigger whenever a new note is created with this tag (and this tag only). Now, whenever you wish to use a voice note as a prompt, just add the 'tag.' This will trigger the webhook which, in turn, will trigger this workflow - sending the prompt to an AI agent of your choosing (configure within the workflow) and then saving the output into a database and returning it by email. Note: The AI agent system prompt is written to define a structured output to provide Gmail-safe HTML. This is thin injected into a template. You can use a Google Group to gather together the output runs or just receive them at your main address (if you don't use Gmail, just swap out for any other email node or your preferred delivery channel). How To Set It Up You'll need a Voicenotes account in order to use the service! Once you have one, you'll next want to create the tag and the webhook. In N8N, create your webhook node and then provide that to Voicenotes: Create a note. Then assign it a new tag: "Prompts" (or as you prefer). The webhook is matched to the tag. Requirements Voicenotes AI account Customisation The delivery mechanism can be customized to your preferences. If you're not a Google user, substitute the template and sending mechanism for your preferred delivery provider You could for example collect the outputs to a Slack channel or Telegram bot. You may omit the collector in NocoDB or substitute it for another wiki or knowledge management platform such as Notion or Nuclino.
by Robert Breen
This n8n workflow automates bulk AI video generation using Freepik's Image-to-Video API powered by Minimax Hailuo-02-768p. It reads video prompts from a Google Sheet, generates multiple variations of each video using Freepik's AI, handles asynchronous video processing with intelligent polling, and automatically uploads completed videos to Google Drive with organized file names. This is perfect for content creators, marketers, or video producers who need to generate multiple AI videos in bulk and store them systematically. Key Features: Bulk video generation from Google Sheets prompts Multiple variations per prompt (configurable duplicates) Asynchronous processing with smart status polling Automatic retry mechanism for processing delays Direct upload to Google Drive with organized naming Freepik Minimax Hailuo-02 AI-powered video generation (768p quality) Intelligent wait/retry system for video rendering Step-by-Step Implementation Guide Prerequisites Before setting up this workflow, you'll need: n8n instance (cloud or self-hosted) Freepik API account with Video Generation access Google account with access to Sheets and Drive Google Sheet with your video prompts Step 1: Set Up Freepik API Credentials Go to Freepik API Developer Portal Create an account or sign in Navigate to your API dashboard Generate an API key with Video Generation permissions Copy the API key and save it securely In n8n, go to Credentials → Add Credential → HTTP Header Auth Configure as follows: Name: "Header Auth account" Header Name: x-freepik-api-key Header Value: Your Freepik API key Step 2: Set Up Google Credentials Google Sheets Access: Go to Google Cloud Console Create a new project or select existing one Enable Google Sheets API Create OAuth2 credentials In n8n, go to Credentials → Add Credential → Google Sheets OAuth2 API Enter your OAuth2 credentials and authorize with spreadsheets.readonly scope Google Drive Access: In Google Cloud Console, enable Google Drive API In n8n, go to Credentials → Add Credential → Google Drive OAuth2 API Enter your OAuth2 credentials and authorize Step 3: Create Your Google Sheet Create a new Google Sheet: sheets.google.com Set up your sheet with these columns: Column A: Prompt (your video generation prompts) Column B: Name (identifier for file naming) Example data: | Prompt | Name | |-------------------------------------------------|---------------| | A butterfly landing on a flower in slow motion | butterfly-01 | | Ocean waves crashing on rocky coastline | ocean-waves | | Time-lapse of clouds moving across blue sky | clouds-timelapse | Copy the Sheet ID from the URL (the long string between /d/ and /edit) Step 4: Set Up Google Drive Folder Create a folder in Google Drive for your generated videos Copy the Folder ID from the URL when viewing the folder Note: The workflow is configured to use a folder called "n8n workflows" Step 5: Import and Configure the Workflow Copy the provided workflow JSON In n8n, click Import from File or Import from Clipboard Paste the workflow JSON Configure each node as detailed below: Node Configuration Details: Get prompt from google sheet (Google Sheets) Document ID**: Your Google Sheet ID (from Step 3) Sheet Name**: Sheet1 (or your sheet name) Operation**: Read Credentials**: Select your "Google Sheets account" Duplicate Rows2 (Code Node) Purpose**: Creates multiple variations of each prompt JavaScript Code**: const original = items[0].json; return [ { json: { ...original, run: 1 } }, { json: { ...original, run: 2 } }, ]; Customization**: Add more runs for additional variations Loop Over Items (Split in Batches) Processes items in batches to manage API rate limits Options**: Keep default settings Reset**: false Create Video (HTTP Request) Method**: POST URL**: https://api.freepik.com/v1/ai/image-to-video/minimax-hailuo-02-768p Authentication**: Generic → HTTP Header Auth Credentials**: Select your "Header Auth account" Send Body**: true Body Parameters**: Name: prompt Value: ={{ $json.Prompt }} Get Video URL (HTTP Request) Method**: GET URL**: https://api.freepik.com/v1/ai/image-to-video/minimax-hailuo-02-768p/{{ $json.data.task_id }} Authentication**: Generic → HTTP Header Auth Credentials**: Select your "Header Auth account" Timeout**: 120000 (2 minutes) Purpose**: Polls the API for video completion status Switch (Switch Node) Purpose**: Routes workflow based on video generation status Conditions**: Completed: {{ $json.data.status }} equals COMPLETED Failed: {{ $json.data.status }} equals FAILED Created: {{ $json.data.status }} equals CREATED In Progress: {{ $json.data.status }} equals IN_PROGRESS Wait (Wait Node) Amount**: 30 seconds Purpose**: Waits before re-checking video status Webhook ID**: Auto-generated for resume functionality Download Video as Base64 (HTTP Request) Method**: GET URL**: ={{ $json.data.generated[0] }} Purpose**: Downloads completed video file Upload to Google Drive1 (Google Drive) Operation**: Upload Name**: =video - {{ $('Get prompt from google sheet').item.json.Name }} - {{ $('Duplicate Rows2').item.json.run }} Drive ID**: My Drive Folder ID**: Your Google Drive folder ID (from Step 4) Credentials**: Select your "Google Drive account" Step 6: Customize for Your Use Case Modify Duplicate Count: Edit the "Duplicate Rows2" code to create more variations Update File Naming: Change the naming pattern in the Google Drive upload node Adjust Wait Time: Modify the Wait node duration based on typical processing times Add Video Parameters: Enhance the Create Video request with additional Freepik parameters Step 7: Test the Workflow Ensure your Google Sheet has test data Click Execute Workflow on the manual trigger (if present) Monitor the execution flow - note that video generation takes time Watch the Switch node handle different status responses Verify videos are uploaded to Google Drive when completed Step 8: Production Deployment Set up error handling for API failures and timeouts Configure appropriate batch sizes based on your Freepik API limits Add logging for successful uploads and failed generations Consider webhook triggers for automated execution Set up monitoring for stuck or failed video generations Freepik Video API Details Video Generation Process: Submit Request: Send prompt to generate video Get Task ID: Receive task_id for tracking Poll Status: Check generation status periodically Download: Retrieve completed video URL Status Types: CREATED: Video generation task created IN_PROGRESS: Video is being generated COMPLETED: Video ready for download FAILED: Generation failed Model Specifications: Model**: minimax-hailuo-02-768p Resolution**: 768p Duration**: Typically 5-10 seconds Format**: MP4 Example Enhanced Parameters: { "prompt": "{{ $json.Prompt }}", "duration": 5, "aspect_ratio": "16:9", "fps": 24 } Workflow Flow Summary Start → Read prompts from Google Sheets Duplicate → Create multiple runs for variations Loop → Process items in batches Generate → Submit video generation request to Freepik Poll → Check video generation status Switch → Route based on status: Completed → Download video Processing/Created → Wait and retry Failed → Handle error Download → Retrieve completed video file Upload → Save to Google Drive with organized naming Continue → Process next batch Troubleshooting Tips Common Issues: Long Processing Times**: Video generation can take 2-5 minutes per video Timeout Errors**: Increase timeout in "Get Video URL" node Rate Limits**: Reduce batch size and add longer waits between requests Failed Generations**: Check prompt complexity and API limits Upload Failures**: Verify Google Drive folder permissions Error Handling: Add Try/Catch nodes around API calls Implement exponential backoff for retries Log failed generations to Google Sheets Set up email notifications for critical failures Performance Optimization: Adjust wait times based on typical generation duration Use smaller batch sizes for more reliable processing Monitor API usage and costs in Freepik dashboard Cost Considerations Freepik API: Video generation typically costs more than image generation Check your plan's video generation limits Monitor usage through Freepik dashboard Consider upgrading for higher volume needs Processing Time: Each video can take 2-5 minutes to generate Plan workflow execution time accordingly Consider running during off-peak hours for large batches Contact Information Robert A Ynteractive For support, customization, or questions about this workflow: 📧 Email: rbreen@ynteractive.com 🌐 Website: https://ynteractive.com/ 💼 LinkedIn: https://www.linkedin.com/in/robert-breen-29429625/ Need help implementing this workflow or want custom automation solutions? Get in touch for professional n8n consulting and workflow development services.
by Abdul Mir
Overview Impress your leads with ultra-personalized “thank you” emails that look hand-written — sent automatically seconds after they submit your intake form. This workflow instantly scrapes the prospect's website, extracts meaningful copy, and uses AI to write a custom thank-you message referencing something specific from their site. It gives the impression you immediately reviewed their business and crafted a thoughtful reply — without lifting a finger. Who’s it for Agencies and consultants using intake forms Freelancers booking discovery calls B2B businesses that want high-touch first impressions Sales teams automating initial follow-ups How it works Triggered when a form (e.g. Tally, Typeform) is submitted Scrapes the website URL provided in the form Converts HTML to Markdown and extracts plain copy Uses AI to write a personalized thank-you message referencing the site Waits briefly to simulate real typing delay Sends the message via Gmail (or any email provider) Example use case > Prospect submits a form with their website: coolstartup.ai > > 30 seconds later, they receive: > > “Thanks for reaching out! I just checked out Cool Startup’s homepage — love the clean UX and mission around AI for teams. Looking forward to diving into how we might collaborate!” How to set up Connect your form tool (e.g. Tally or Typeform) Connect Gmail or another email provider Customize the AI prompt to match your tone Set the wait time (e.g. 30 seconds) for a realistic delay Update your website scraping logic if needed Requirements Form tool with webhook support OpenAI (or other LLM) credentials Email sending integration (Gmail, Mailgun, Postmark, etc.) How to customize Edit the email tone (casual, formal, funny, etc.) Add CRM integration to log form submission and response Trigger additional workflows like lead scoring or Slack alerts Add fallback logic if the website doesn’t scrape cleanly
by Lakindu Siriwardana
This visual workflow represents an AI-powered automated CV filtering system created using tools like n8n, Google Drive, Google Sheets, and Ollama (LLM) ⚙️ Key Features 📂 Google Drive Integration – Automatically searches and downloads CVs (PDF/DOCX/PPTX) from a shared folder. 📋 Criteria Matching – Reads and applies filtering rules from a Google Sheet. 🧠 LLM-Based Analysis – Uses a Large Language Model (Ollama) to assess and interpret CV content. 🧪 Smart Parsing – Includes structured and auto-fixing output parsers to ensure data accuracy. 📊 Automated Results Output – Writes matching candidates and analysis to a Google Sheet. 🔁 Loop and Aggregate Logic – Handles multiple CVs with iterative processing and aggregation. 🚀 No-Code Automation with n8n – Fully visual, modifiable without programming. 🛠️ How It Works Trigger: Workflow is initiated via a Webhook (from a UI “Start Workflow” button). CV Search: Searches for CV files in a designated Google Drive folder. Loop Over Files: Each file is downloaded. Text is extracted (from PDFs or other formats). Criteria Input: Matching rules are fetched from a predefined Google Sheet. Merge & Aggregate: Combines file text and criteria for unified processing. LLM Processing: Text + criteria are sent to the Basic LLM Chain. Utilizes Ollama Model for advanced language understanding. Structured or auto-fixing output parsers enhance reliability. Custom Code Execution: Optionally enriches or reformats the data. Output: Results are appended to a shared Google Sheet (the output sheet).
by AppStoneLab Technologies LLP
🤖 AI Support Bot for WooCommerce with Gemini & GPT (Telegram & Gmail) Managing customer support across multiple platforms like email and chat can be a huge time sink. Answering the same questions about order status repeatedly takes your focus away from growing your business. This workflow solves that problem by deploying a 24/7 conversational AI agent to act as your first line of support for your WooCommerce store. This AI-powered bot can handle customer inquiries from both Telegram and Gmail, understand conversational follow-ups, and use a tool to fetch live order data directly from your WooCommerce store. It's designed to be reliable, with a primary/fallback AI model setup, and robust enough to prevent the common pitfalls of email automation like infinite reply loops. How It Works ⚙️ The workflow operates in a clear, logical sequence: 📢 Multi-Channel Ingestion: The workflow starts when it receives a message from one of two sources: Telegram: An instant webhook trigger fires for every new message. Gmail: A polling trigger checks your inbox every minute for new, unread emails. 💎 Data Normalization: All incoming requests are merged and processed by a Set node. This crucial step transforms the platform-specific data into a universal format that the rest of the workflow can understand (e.g., platform, sender_id, query_text). 🧠 AI Processing: The standardized query is sent to a LangChain Agent. This agent is the "brain" of the operation. It uses Conversational Memory to understand the context of the conversation (like when a user provides an order ID in a follow-up message). 🛠️ Tool Usage: Based on its prompt, the AI Agent determines if it has enough information to use its one available tool: Get an order in WooCommerce. If a valid Order ID is present, it calls the tool to fetch live order details. 📮 Response & Routing: The agent formulates a natural language response. A Switch node then inspects the platform field and routes the response to the correct channel. ✅ Cleanup: For the Gmail path, two final actions occur in parallel: the reply is sent, and the original incoming email is marked as 'Read'. This is a critical step to prevent the workflow from re-triggering on the same email in an infinite loop. Nodes Used 🔗 This workflow uses a combination of standard nodes and AI nodes to achieve its goal: Telegram Trigger: To receive messages from Telegram in real-time. Gmail Trigger: To poll for new unread emails. Merge: To combine inputs from multiple triggers. Set: To normalize data into a consistent format. LangChain Agent: The core AI "brain" that orchestrates the logic, memory, and tools. Google Gemini & OpenAI: Used as the primary and fallback language models for the agent. WooCommerce Tool: The tool the AI agent uses to fetch order data. Switch: To route the final reply to the correct platform. Telegram: To send the final response to Telegram. Gmail: To reply to emails and mark them as read. Prerequisites 🔑 To use this workflow, you will need: An active n8n instance (self-hosted or cloud). A Telegram Bot account and its API token. A Gmail account with OAuth2 credentials configured in n8n. A WooCommerce store with API credentials (Consumer Key and Secret). An OpenAI API key. A Google AI (Gemini) API key. Usage 🚀 Follow these steps to set up the workflow: Download the Workflow: Import the workflow JSON file into your n8n instance. Configure Credentials: Telegram: Select your Telegram API credentials in the Fetch user query and Send Telegram Response nodes. Gmail: Select your Gmail OAuth2 credentials in the Fetch support mail, Send Response via Mail, and Mark received mail as read nodes. WooCommerce: Select your WooCommerce API credentials in the Get an order in WooCommerce node. AI Models: Select your OpenAI and Google AI credentials in the Fallback Model and Primary Model nodes, respectively. Activate Telegram Webhook: Open the Fetch user query (Telegram Trigger) node. Copy the Webhook URL. Register this URL with your Telegram bot using the /setWebhook command in the BotFather chat. Customize AI Prompt (Optional): Open the WooCommerce Customer support Agent1 node. You can edit the prompt in the Text field to change the AI's personality, rules, or language. Activate the Workflow: Save the workflow and toggle the "Active" switch ON. Your multi-channel AI support agent is now live\! Send a message to your Telegram bot or a new, unread email to your connected Gmail account to test it out. Resources 📚 n8n Documentation n8n Community Forum LangChain in n8n
by Kdan
📌 Overview Description: This powerful workflow automates your sales quotation process by connecting Pipedrive with DottedSign. When a deal is moved to a specific stage in Pipedrive, this template automatically generates a professional PDF quotation, uploads it back to the deal, and sends it out for e-signature via DottedSign service, saving your sales team valuable time and eliminating manual work. What it does When a Pipedrive deal moves to a designated stage (e.g., "Quotation Stage"), this workflow triggers and performs the following actions: Gathers Data: It collects all relevant information, including deal details, client contacts, organization info, and associated products from Pipedrive. Generates PDF Quote: It populates a customizable HTML template with the collected data and uses a PDF generation service (Gotenberg) to create a polished PDF document. Uploads to Pipedrive: The generated PDF quote is automatically uploaded to the "Files" section of the corresponding Pipedrive deal for record-keeping. Sends for E-Signature: It creates a new signing task in DottedSign, sending the quotation to the client for their electronic signature. Requirements A Pipedrive account with admin permissions. A DottedSign developer account to obtain API credentials. A self-hosted instance of Gotenberg for HTML to PDF conversion. How to set up Pipedrive Trigger Stage: In the If node, change the stage ID 7 to the ID of the pipeline stage you want to use as the trigger. PDF Conversion Service: In the Gotenberg to PDF (HTTP Request) node, replace the placeholder URL with the endpoint of your running Gotenberg instance. DottedSign Credentials: In the Get DottedSign Access Token node, enter your client_id and client_secret in the request body. DottedSign Signature Field: In the Create DottedSign Task node, you must adjust the page and coord values under field_settings to match the desired signature location on your PDF template. How to customize the workflow Quotation Template:** Edit the Generate Quotation HTML node to modify the quote's appearance, text, company logo, and terms. The {{ ... }} expressions are placeholders that are filled with Pipedrive data. Trigger:** Replace the Pipedrive Trigger with another trigger, such as a webhook or a form submission, to adapt the workflow to different needs. Notifications:** Add a Slack or email node at the end of the workflow to notify the sales team once the quotation has been sent.
by PollupAI
Who it’s for Built for Customer Success and Account Management teams focused on proactive retention. This workflow helps you automatically identify at-risk customers – before they churn – by combining CRM, usage, and sentiment data into one actionable alert. What it does This end-to-end workflow continuously monitors customer health by consolidating data from HubSpot and Google Sheets. Here’s how it works: Fetch deals from HubSpot. Collect context — linked support tickets and feature usage from a Google Sheet. Run sentiment analysis on the tickets to generate a customer health score. Evaluate risk — an AI agent reviews deal age, sentiment score, and usage trends against predefined thresholds. Send alerts — if churn risk is detected, it automatically sends a clear, data-driven email to the responsible team member with next-step recommendations. How to set it up To get started, configure your credentials and parameters in the following nodes: Credentials: HubSpot: Connect your account (HubSpot: Get All Deals). LLM Model: Add credentials for your preferred provider (Config: Set LLM for Agent & Chains). Google Sheets: Connect your account (Tool: Get Feature Usage from Sheets). Email: Set up your SMTP credentials (Email: Send Churn Alert). Tool URLs: In Tool: Calculate Sentiment Score, enter the Webhook URL from the Trigger: Receive Tickets for Scoring node within this same workflow. In Tool: Get HubSpot Data, enter the Endpoint URL for your MCP HubSpot data workflow. (Note: This tool *does call an external workflow)*. Google Sheet: In Tool: Get Feature Usage from Sheets, enter the Document ID for your own Google Sheet. Email Details: In Email: Send Churn Alert, change the From and To email addresses. Requirements HubSpot account with Deals API access LLM provider account (e.g. OpenAI) Google Sheets tracking customer feature usage n8n with LangChain community nodes enabled A separate n8n workflow set up to act as an MCP endpoint for fetching HubSpot data (called by Tool: Get HubSpot Data). How to customize it Tailor this workflow to match your business logic: Scoring logic:** Adjust the JavaScript in the Code: Convert Sentiment to Score node to redefine how customer scores are calculated. Alert thresholds:** Update the prompt in the AI Chain: Analyze for Churn Risk node to fine-tune when alerts trigger (e.g. deal age, score cutoff, or usage drop). Data sources:** Swap HubSpot or Google Sheets for your CRM or database of choice — like Salesforce or Airtable. ✅ Outcome: A proactive customer health monitoring system that surfaces risks before it’s too late — keeping your team focused on prevention, not firefighting.
by Jitesh Dugar
Automated Influencer Campaign Management System A comprehensive n8n workflow template for streamlining influencer application processing with real-time social media data validation, intelligent scoring algorithms, and automated onboarding workflows. Who’s It For Marketing agencies managing high-volume influencer applications Brand marketing teams screening social media creators Influencer platforms automating creator onboarding Digital marketing consultants reducing manual workload E-commerce brands building creator partnerships Social media management companies scaling operations How It Works Capture influencer applications via Webhook (connected to forms/websites). Validate applicant emails using VerifiEmail to prevent fake submissions. Fetch real-time social data from Instagram (via Instagram120 API) and YouTube (via YouTube138 API). Calculate engagement scores using a weighted algorithm (Instagram 60% + YouTube 40%). Auto-approve qualified influencers based on follower count & engagement thresholds. Log approved applications in Google Sheets with complete metrics. Send personalized welcome emails with campaign information & next steps. Reject low-quality applications with detailed reasoning (for internal tracking). Generate scoring breakdown with platform-specific analytics & tier classification. Track application volume and approval rates for performance optimization. Offers: Real-time API integration, intelligent scoring, automated actions, scalable processing. 🛠️ How to Set Up Connect your application form to Webhook: POST → https://[your-n8n-url]/webhook/influencer-signup Sign up for RapidAPI and subscribe to Instagram120 + YouTube138 APIs. Get VerifiEmail API key (100 free verifications/month). Configure Gmail OAuth2 in Google Cloud Console for email automation. Create a Google Sheets database for approved influencer storage. Add credentials in n8n: RapidAPI, VerifiEmail, Gmail, Google Sheets. Customize scoring thresholds & email templates in Function nodes. Test with sample data: { "name": "Test Creator", "email": "test@gmail.com", "social_handles": { "instagram": "testuser", "youtube": "testchannel" }, "niche": "fitness", "rate_card": 500 } Requirements n8n instance** (cloud or self-hosted) API credentials**: RapidAPI (Instagram120 + YouTube138 APIs) VerifiEmail Gmail OAuth2 Google Sheets access Form/website integration** → sends webhook data Google Sheets** for database & reporting RapidAPI Integration Details Instagram120 API Pricing Plans:** Free: 1,000 requests/month Pro: 10,000 requests/month ($10/mo) Ultra: 100,000 requests/month ($50/mo) n8n Example:** { "method": "POST", "url": "https://instagram120.p.rapidapi.com/api/instagram/profile", "headers": { "X-RapidAPI-Host": "instagram120.p.rapidapi.com", "X-RapidAPI-Key": "YOUR_RAPIDAPI_KEY", "Content-Type": "application/json" }, "body": { "username": "{{ $('Data Sanitizer').item.json.social_handles.instagram }}" } } YouTube138 API Pricing Plans:** Free: 1,000 requests/month Pro: 10,000 requests/month ($15/mo) Ultra: 100,000 requests/month ($75/mo) n8n Example:** { "method": "GET", "url": "https://youtube138.p.rapidapi.com/channel/details", "headers": { "X-RapidAPI-Host": "youtube138.p.rapidapi.com", "X-RapidAPI-Key": "YOUR_RAPIDAPI_KEY" }, "queryParameters": { "id": "{{ $('Webhook').item.json.body.social_handles.youtube }}", "hl": "en", "gl": "US" } } Core Features Social Media Validation** Instagram follower counts, engagement, verification YouTube subscriber counts, channel stats Cross-platform scoring algorithm Fraud prevention via email validation Intelligent Scoring** Multi-tier classification (Nano, Micro, Macro, Mega) Engagement analysis per platform Customizable approval thresholds Automation Actions** Auto-approve/reject with reasoning Store results in Google Sheets Send onboarding emails Track performance stats Use Cases & Applications Marketing Agencies** → Process 100+ daily influencer applications automatically Brands** → Validate influencer metrics before partnerships Platforms** → Qualify creators for platform admission automatically E-commerce** → Build authentic influencer partnerships Key Benefits ✔️ Saves 80-90% processing costs ✔️ Cuts manual review time from 15 minutes → 30 seconds ✔️ Prevents fraud with real-time validation ✔️ Scales infinitely with no extra staffing Technical Specifications Execution time:** 30–45 sec per application Throughput:** 100+ applications/hour Success rate:** 95%+ valid applications Cost:** ~$0.05–$0.15 per application ROI & Cost Breakdown Manual:** $15–25/hour human review Automated:** $0.05–0.15/application Savings:** 80–90% at scale Break-even:** 50–100 apps/month Integration Example // Example website form submission fetch('https://your-n8n-instance.com/webhook/influencer-signup', { method: 'POST', headers: {'Content-Type': 'application/json'}, body: JSON.stringify(formData) }); Sample Application Data: { "name": "Sarah Johnson", "email": "sarah.fitness@gmail.com", "social_handles": { "instagram": "sarahfitlife", "youtube": "SarahFitnessJourney" }, "niche": "fitness", "country": "US", "rate_card": 750 } Installation Import workflow JSON file into n8n Add API credentials (RapidAPI, VerifiEmail, Gmail, Sheets) Configure Sheets with correct columns Customize scoring & emails Test with sample apps Activate workflow Disclaimers Requires paid RapidAPI plans for scale API rate limiting applies Data accuracy depends on APIs Ensure GDPR/CCPA compliance before production Always test before live deployment License This template is provided as-is for educational and commercial use. Users are responsible for ensuring compliance with laws, platform TOS, and data privacy rules.
by kote2
This workflow allows a LINE user to send either text or an image of food to a connected LINE bot. If text is sent, the AI agent responds directly via LINE. If an image is sent, the workflow downloads it from LINE’s API, analyzes it using OpenAI’s Vision model, estimates calories (only if the image contains food), and formats the result into JSON. Detected dishes and calories are appended to a Google Sheet, and a confirmation message is sent back to the user via LINE. Key Features: Integrates LINE Messaging API webhook with n8n Uses OpenAI Vision to detect food and estimate calories Automatically logs results into Google Sheets Sends real-time feedback to the LINE user How to use: Set up a LINE Messaging API channel and get your channel access token. Add your OpenAI API credentials in n8n. Replace placeholders for {channel access token}, {your id}, and Google Sheet IDs with your own. Activate the workflow and send a food image or text message to your LINE bot.
by AFK Crypto
Try It Out! The Daily AI-Powered Global Trend Analysis Workflow transforms your Discord server into a real-time AI-driven global intelligence dashboard. Every 6 hours, this automation gathers worldwide data from GDELT, Hacker News, and NewsAPI — analyzing patterns in technology, economics, and geopolitics to uncover emerging global narratives before they hit mainstream awareness. An integrated AI Trend Analyzer Agent distills this massive dataset into concise, actionable insights including: Top 5 emerging global trends A short AI-written daily summary Regional intelligence highlights** Notable mentions** in innovation, finance, and politics Each insight is automatically posted to your Discord channel, formatted for quick scanning and decision-making — keeping your team or community ahead of the curve. How It Works Automated Trigger (Schedule Node) – Executes every 6 or 24 hours (customizable) to fetch the latest global data. Multi-Source Intelligence Aggregation: GDELT – Captures worldwide media signals and geopolitical movements. Hacker News API – Surfaces trending stories in startups, AI, and innovation. NewsAPI – Collects major headlines across global media outlets filtered by defined keywords. Data Normalization (JavaScript Node) – Cleans and merges all incoming data into a unified format with timestamps. AI Trend Analyzer (LLM Node) – Evaluates data contextually to identify: 📰 Top 5 Global Trends 🌍 Regional Highlights 💡 Key Industry Insights 📈 100–150 Word Summary Output Structuring Node – Parses and formats AI responses into a clean, Discord-friendly layout. Discord Delivery – Sends the compiled report to your specified channel using a webhook or bot token. How to Use Import the workflow into n8n. Configure the following credentials: NewsAPI Key – for aggregating headlines. LLM API Key (OpenAI or Gemini) – for AI-based summarization. Discord Webhook URL or Bot Token – for automated posting. Edit NewsAPI keywords to match your industry focus (e.g., “AI,” “blockchain,” “defense,” “renewable energy”). Adjust the schedule trigger interval as desired (default: every 6 hours). Activate the workflow — and start receiving continuous, AI-curated global intelligence in Discord. (Optional) Extend This Workflow Sector Prioritization:** Focus on AI, finance, energy, or web3 insights only. Regional Filters:** Segment analysis by continent or language. Trend Scoring:** Introduce a numeric score to rank importance. Cross-Platform Broadcast:** Expand reports to Telegram, Slack, or X (Twitter). Knowledge Archive:** Auto-store each daily report in Notion or Airtable. Requirements n8n Instance** with HTTP Request, LLM, and Discord Nodes NewsAPI Key** Access to GDELT** (no authentication required) OpenAI or Gemini Key for AI Analysis** Discord Webhook URL or Bot Token** APIs Used GET https://api.gdeltproject.org/api/v2/doc/doc?query=crypto&format=json GET https://hn.algolia.com/api/v1/search?query=startup%20OR%20trend&tags=story&hitsPerPage=10 GET https://newsapi.org/v2/everything?q=crypto OR bitcoin OR web3 OR AI&language=en&sortBy=publishedAt&pageSize=10 Summary The Daily AI-Powered Global Trend Analysis Workflow (Discord Edition) delivers machine-curated global intelligence right where your community communicates. It combines AI-driven reasoning with real-time data aggregation from open sources — converting raw news into structured, actionable insights. Ideal for founders, analysts, researchers, and DAOs, this workflow ensures your Discord server becomes a live intelligence hub — automatically updated with what truly matters worldwide. Our Website: https://afkcrypto.com/ Check our blogs: https://www.afkcrypto.com/blog