Agents & Automations

Get started building AI agents and automations to streamline your workflows!

๐Ÿค– Automated AI Agent System for Faceless Video Creation
The EASIEST fully automated n8n/Make AI agent system that creates and posts faceless AI videos, WITHOUT having to sign up for multiple tools to generate AI images, videos, voice, and stitch everything together. Faceless AI videos are blowing up on social media, getting millions of views. Anyone can start making them today, without expertise in video editing. This tutorial combines n8n/Make and Blotato to write, generate, and create faceless AI videos to every social media platform every single day. 100% automated.

Platform: Make

Tools Used: Blotato, AI Agent

Categories: AI, Content Creation, Social Media Management

๐Ÿ„ Transcribe Slack Messages to Airtable
Automatically transcribe Slack group messages and save them to Airtable. Capture conversations, download files, and create transcriptions for organized record-keeping.

Platform: Make

Tools Used: Slack, Airtable

Categories: Transcription, Data Management

๐Ÿš€ Summarize YouTube Videos from Transcripts
Who is this template for? This workflow template is designed for content creators, researchers, educators, and professionals who need quick, accurate summaries of YouTube videos. Itโ€™s ideal for those looking to save time, extract key insights, or repurpose video content into concise formats for reports, studies, or social media. What does it do? The workflow automates the process of summarizing YouTube videos by extracting the transcript, analyzing the content, and generating a concise summary. It leverages AI tools to ensure accuracy and relevance, making it easier to digest lengthy videos in seconds. Why is it useful? This template saves hours of manual effort by automating video summarization, enabling users to focus on analyzing or sharing insights rather than watching entire videos. Itโ€™s particularly useful for staying updated with trends, conducting research, or creating content efficiently. How does it work? The workflow integrates with YouTubeโ€™s Transcript API powered by Apify Actor to fetch video transcripts, process the text using AI-powered summarization tools, and deliver a clear, concise summary. Setup Instructions You need an Apify account and an API key to connect with the Actor. Follow the steps below: 1. Create a Free Account. 2. Choose the appropriate Actor from the Apify search. 3. Under the Integration tab, click on โ€œUse API endpoints.โ€ 4. Select the API that best suits your needs.

Platform: n8n

Tools Used: Apify, OpenAI, YouTube

Categories: Content Creation, Research, AI

๐ŸŽฅ Automated AI Video Generation & Multi-Platform Publishing
This comprehensive n8n automation template orchestrates a complete end-to-end workflow for generating engaging short-form Point-of-View (POV) style videos using multiple AI services and automatically publishing them across major social media platforms. It takes ideas from a Google Sheet and transforms them into finished videos with captions, voiceovers, and platform-specific descriptions, ready for distribution. Who Is This For? - Content Creators & Agencies: Mass-produce unique short-form video content for various clients or channels with minimal manual effort. - Digital Marketers: Automate video content pipelines to boost online presence and engagement across multiple platforms simultaneously. - Social Media Managers: Schedule and distribute consistent video content efficiently without juggling multiple tools and manual uploads. - Businesses: Leverage AI to create branded video content for marketing, reducing production time and costs. What Problem Does This Workflow Solve? Creating and distributing high-quality short-form video content consistently across multiple social networks is incredibly time-consuming and resource-intensive. This workflow tackles these challenges by: - Automating Idea-to-Video Pipeline: Generates video concepts, image prompts, scripts, images, video clips, and voiceovers using AI. - Streamlining Video Assembly: Automatically combines generated assets into a final video using a template. - Generating Platform-Optimized Descriptions: Creates relevant descriptions for posts by transcribing the final video audio. - Automating Multi-Platform Publishing: Uploads the final video and description to TikTok, Instagram, YouTube, Facebook, and LinkedIn simultaneously. - Reducing Manual Workload: Drastically cuts down the time and effort required for video production and distribution. - Centralized Tracking: Updates a Google Sheet with results, costs, and status for easy monitoring. How It Works - Trigger & Input: Runs on a daily schedule (configurable) and fetches new video ideas from a designated Google Sheet. - AI Content Generation: - Uses OpenAI to generate video captions and image prompts based on the idea. - Uses PiAPI (Flux) to generate images from prompts. - Uses PiAPI (Kling) to generate video clips from the images (Image-to-Video). - Uses OpenAI to generate a voiceover script based on the captions. - Uses ElevenLabs to generate voiceover audio from the script and uploads it to Google Drive. - Video Assembly: Combines the generated video clips, captions, and voiceover audio using a Creatomate template to render the final video. - Description Generation: Uploads the final video to Google Drive, extracts the audio using OpenAI (Whisper), and generates a social media description using OpenAI (GPT). - Multi-Platform Distribution: Uses upload-post.com to upload the final video and generated description to TikTok, Instagram, YouTube, Facebook, and LinkedIn. - Tracking & Notification: Updates the original Google Sheet row with output details (video link, costs, tokens used) and sends a completion notification via Discord. Setup - Accounts & API Keys: Obtain accounts and generate API keys/credentials for: - n8n - Google Cloud Platform (for Google Sheets & Google Drive APIs + OAuth Credentials) - OpenAI - PiAPI - ElevenLabs - Creatomate - upload-post.com - Discord (Webhook URL) - Google Sheet: Make a copy of the provided Google Sheet Template and connect it in the Load Google Sheet node. - Creatomate Template: Set up a video template in Creatomate (use the provided JSON source code as a base) and note its Template ID. - Configure Nodes: - Enter all API Keys/Credentials in the Set API Keys node and other relevant credential sections (Google nodes, upload-post nodes, etc.). - Configure Google Drive nodes (Folder IDs, Permissions). - Configure the upload-post.com nodes with your user identifier and necessary platform details (e.g., Facebook Page ID). - Customize AI prompts within the OpenAI nodes (Generate Video Captions, Generate Image Prompts, Generate Script, Generate Description...) if desired. - Set the Discord Webhook URL in the Notify me on Discord node. - Enable Google APIs: Ensure Google Drive API and Google Sheets API are enabled in your Google Cloud Project. Requirements - Accounts: n8n, Google (Sheets, Drive, Cloud Platform), OpenAI, PiAPI, ElevenLabs, Creatomate, upload-post.com, Discord. - API Keys & Credentials: API Keys for OpenAI, PiAPI, ElevenLabs, Creatomate, upload-post.com. Google Cloud OAuth 2.0 Credentials. Discord Webhook URL. - Templates: A configured Google Sheet based on the template, a configured Creatomate video template. - (Potentially) Paid Plans: Some services (OpenAI, PiAPI, Creatomate, upload-post.com) may require paid plans depending on usage volume after free trials/credits are exhausted. Use this template to build a powerful, automated video content factory, scaling your production and distribution efforts across the social media landscape.

Platform: n8n

Tools Used: OpenAI, Google Sheets, Creatomate

Categories: Content Creation, Social Media Management, Marketing

๐ŸŽฅ Gemini AI Video Analysis Workflow
๐Ÿ“ Overview This workflow leverages Google Gemini 2.0 Flash multimodal AI to automatically generate detailed descriptions of video content from any public URL. It streamlines video understanding, making it ideal for content cataloging, accessibility, and content moderation. ๐Ÿ’ก Use Cases โ™ฟ Accessibility: Automatically generate detailed video descriptions for visually impaired users. ๐Ÿ›ก๏ธ Content Moderation: Detect inappropriate or off-brand material without manual watching. ๐Ÿ—‚๏ธ Media Cataloging: Enrich your media library with automatically extracted metadata. ๐Ÿ“ˆ Marketing & Branding: Gain fast insights into key elements, tone, and branding in video content. โš™๏ธ Setup Instructions ๐Ÿ”‘ Get a Gemini API Key Register at ai.google.dev and create an API key. Before running the workflow, set your Gemini API key as an environment variable named GeminiKey for secure access within the workflow. In the Set Input node, reference this environment variable instead of hardcoding the key. ๐ŸŒ Configure Video URL Replace the sample URL in the Set Input node with your desired public video URL. Ensure the video is directly accessible (no login or special permissions required). ๐Ÿ“ Optional: Customize the Analysis Edit the prompt in the Analyze video Gemini node to focus on the most relevant video details for your use case (e.g., branding, key actions, visual elements). ๐Ÿ”’ Security Tip Use n8n's credentials manager or environment variables (like GeminiKey) to store your API key securely. Avoid hardcoding API keys directly in workflow nodes, especially in production environments. ๐Ÿ”„ How It Works ๐Ÿ“ฅ Download the video from the provided URL. โ˜๏ธ Upload the video to Geminiโ€™s server for processing. โณ Wait for Gemini to complete processing. ๐Ÿค– Analyze the video with Gemini AI using your customized prompt. ๐Ÿ“„ Output a comprehensive description of the video as videoDescription. โšก Technical Details Uses HTTP Request nodes to interact with Gemini API endpoints. Handles file download, upload, status checking, and result retrieval. Customizable Gemini AI parameters for fine-tuned response. Main output: videoDescription (detailed text describing video content). ๐Ÿš€ Quickstart Set your Gemini API key as the GeminiKey environment variable and configure your video URL in the workflow. Execute the workflow. Retrieve your rich, AI-generated video description for downstream use such as automation, tagging, or reporting.

Platform: n8n

Tools Used: Google Gemini, OpenAI

Categories: AI, Content Creation, Marketing

๐Ÿ“ฑ Send Personalized WhatsApp Templates Triggered by KlickTipp
Community Node Disclaimer: As this workflow relies on a community node, it is limited to self-hosted environments. How It Works This workflow automates personalized WhatsApp message template delivery triggered by events in KlickTipp or by messages sent to the WhatsApp Business account. When a contact triggers an Outbound, the workflow uses a pre-approved WhatsApp message template to send dynamic, real-time messages through the WhatsApp Business Cloud API. When receiving messages, it checks whether a cancellation should be processed or if an auto-response is sent. This setup is ideal for time-sensitive campaigns such as: - Birthday greetings - Discount or promo notifications - Follow-ups on product or service interest Key Features - KlickTipp Trigger: Starts the workflow when a specific outbound is triggered. Typical use case: subscriber receives activation Tag and triggers an Outbound which sends a webhook call to trigger WhatsApp messaging. - WhatsApp Business Cloud - Message Trigger: Listens to messages from the contact and processes answers with an answering auto-responder or by tagging the contact in KlickTipp. - WhatsApp Business Cloud - Sending Template Messages: Sends WhatsApp message templates using a pre-approved template. Template placeholders are filled with data from KlickTipp custom fields. Setup Instructions 1. Set up the KlickTipp and WhatsApp nodes in your n8n instance. 2. Authenticate your WhatsApp and KlickTipp accounts. 3. Create the necessary custom fields to match the data structure. 4. Verify and customize field assignments in the workflow to align with your specific form and subscriber list setup. | Field Label | Field Type | |--------------------------------------|---------------| | Whatsapp_Produkt/Dienstleistung | Single line | | Whatsapp_Name/Unternehmen | Single line | | Whatsapp_Link_Endung | Single line | Testing & Deployment - Use a real test contact with all required fields filled. - Trigger the Outbound in KlickTipp using the activation tag and answer with a message to the template. - Run the scenario once in n8n to verify successful delivery of the WhatsApp message template to your test contact as well as the reception of the auto-responder and the subscription and tagging in KlickTipp to stop further messages. Campaign Expansion Ideas - Connect the campaign to process keywords like "STOP" from WhatsApp messages. - Pair WhatsApp with a welcome email series for onboarding. - Use tags like product_interest_X for precise segmentation. - A/B test templates with different CTA formats or timings. - Monitor CTRs via dynamic URLs in WhatsApp templates. Benefits - Multi-channel engagement: Adds WhatsApp to your marketing toolkit. - Dynamic content: Personalizes messages using contact data. - KlickTipp campaign control: WhatsApp contacts can, for example, signal with messages like "STOP" to receive the according Tag in KlickTipp in order to start/end automations. ๐Ÿ’ก Pro Tip: Customize the domain link ending per campaign or product line. This allows targeted redirects, e.g., meinshop.de/ProduktA.

Platform: n8n

Tools Used: KlickTipp

Categories: Marketing, Customer Support, Email Marketing

๐Ÿค– Intelligent Web Query & Semantic Re-Ranking Flow with Brave & Google Gemini
Workflow Description This workflow is a powerful, fully automated web query and semantic reranking system that allows users to perform precise, detailed searches, intelligently rank search results, and provide high-quality, structured output. Built with AI-powered components, the workflow leverages semantic query generation, result re-ranking, and real-time reporting to deliver actionable insights. It is particularly well-suited for real-time data retrieval, market research, and any domain requiring automated yet customizable search result processing. How It WorksWebhook Integration for Input: The workflow begins with a Webhook Node that captures the user's search query as input, enabling seamless integration with other systems. Step 1: Semantic Query Generation (Powered by "Semantic Search - Query Maker"): Using AI (Google Gemini), the initial query is refined and transformed into a context-aware, expert-level search query. The process ensures that the search engine retrieves the most relevant and precise results. Step 2: Web Search Execution: A free Brave Search API processes the refined query to fetch search results, ensuring speed and cost efficiency. Step 3: Semantic Re-Ranking of Results (Powered by "Semantic Search - Result Re-Ranker"): The workflow reranks the search results based on relevance to the original question, prioritizing the most relevant URLs dynamically. Results are passed through AI-powered intelligent reranking to ensure the final output reflects optimal relevance and quality. Step 4: Structured Output Generation: Results are converted into a well-structured, organized JSON format, ranking the top 10 search results with their titles, links, and descriptions. Missing ranks (if fewer than 10 results) are handled gracefully with placeholders, ensuring consistency. Step 5: Real-Time Reporting: The reranked search results are sent back to the user or integrated system via the Webhook Node in a JSON-formatted response. Reports are highly structured and ready for downstream processing or consumption. Key Features - AI-Powered Query Refinement: Transforms basic queries into detailed, expert-level search terms for optimal results. - Dual-Stage Semantic Search: Combines query generation and result reranking for precise, high-relevance outputs. - Top 10 Result Reranking: Dynamically ranks and organizes the top 10 results based on semantic relevance to the query. - Customizable Integration: Fully modifiable for alternative APIs or integrations, such as other search engines or custom ranking logic. - JSON-Formatted Structured Results: Outputs reranked results in a standardized format, ideal for integration into systems requiring machine-readable data. - Webhook-Based Flexibility: Works seamlessly with Webhook inputs for easy deployment in diverse workflows. - Cost-Effective API Usage: Pre-integrated with the free Brave Search API, minimizing operational costs while delivering accurate search results. Instructions for API Setup - Brave Search API: Visit api.search.brave.com to obtain a free-tier API key for web search. - AI Integration (Google Gemini): Visit Google AI Studio and generate an API key for semantic query generation and reranking. - Webhook Configuration: Set up the input Webhook to capture search queries and the output Webhook to deliver reranked results. Why Choose This Workflow? - Precision and Relevance: Combines AI-based query generation with advanced reranking for accurate results. - Fully Customizable: Easily adapt the workflow to alternative APIs, search engines, or ranking logic. - Real-Time Insights: Provides structured, real-time output ready for immediate use. - Scalable and Modular: Ideal for businesses, researchers, and data analysts needing a robust, repeatable solution. Tags AI Workflow, Semantic Search, Query Refinement, Search Result Reranking, Real-Time Search, Web Search Automation, Google Search, Brave Search, News Search, API Integration, Market Research, Competitive Intelligence, Business Intelligence, Google Gemini, Anthropic Claude, OpenAI, GPT, LLM

Platform: n8n

Tools Used: Google Gemini, Brave Search

Categories: AI, Business Intelligence, Data Management

๐Ÿค– AI Email Classification with Gmail, ChatGPT & Freshdesk
Learn how to automate email classification using AI. Integrate Gmail, ChatGPT, and Freshdesk to categorize emails based on sentiment, automatically creating tickets for positive, negative, and neutral feedback. Improve your customer support efficiency effortlessly.

Platform: Make

Tools Used: Gmail, ChatGPT, Freshdesk

Categories: AI, Customer Support, Productivity

๐Ÿค– AI Summary Block for WordPress Posts
This workflow automates the process of adding an AI-generated summary at the top of your WordPress posts. It retrieves, processes, and updates your posts dynamically, ensuring efficiency and flexibility without relying on a heavy WordPress plugin. ### Example of AI Summary Section How It Works - Triggers โ†’ Runs on a scheduled interval or via a webhook when a new post is published. - Retrieves posts โ†’ Fetches content from WordPress and converts HTML to Markdown for AI processing. - AI Summary Generation โ†’ Uses OpenAI to create a concise summary. - Post Update โ†’ Inserts the summary at the top of the post while keeping the original excerpt intact. - Data Logging & Notifications โ†’ Saves processed posts to Google Sheets and notifies a Slack channel. Why use this workflow? โœ… No need for a WordPress plugin โ†’ Keeps your site lightweight. โœ… Highly flexible โ†’ Easily connect with Google Sheets, Slack, or other services. โœ… Customizable โ†’ Adapt AI prompts, formatting, and integrations to your needs. โœ… Smart filtering โ†’ Ensures posts are not reprocessed unnecessarily. ๐Ÿ’ก Check the detailed sticky notes for setup instructions and customization options!

Platform: n8n

Tools Used: OpenAI, WordPress, Google Sheets

Categories: AI, Content Creation, Productivity

๐Ÿค– Reply to Outlook Emails with OpenAI
Who is this template for? This template is for any Microsoft Outlook user who wants a trained AI agent to reason and reply on their behalf. Teach your agent tone and writing style to replicate your own, or develop a persona for a shared inbox. Requirements - Outlook with authentication credentials - OpenAI account with authentication credentials - A few sample email replies of various lengths and topics How it works: 1. Connect your Outlook account. 2. Select (filter) which email sender(s) your trained AI agent will reply to.Tip: pick a sender that has some repeatability either with a topic (i.e., sales) or an individual ([email protected]) 3. Connect your OpenAI account. Choose your AI model (i.e., gpt-4o-mini). 4. Add Prompt (User Message) and select "system message" from the option below. 5. Update the instructions by filling in your name (or persona), response style, and add full email replies from the topic or individual you want the AI agent to emulate.Tip: Add actual replies from your email sent folder, including your greeting and sign off. Paste each email sample between a set of <example> .... </example> tags. 6. Configure the reply (or reply all) to remain within the original email string. 7. Test it! Send an email from the address to which your agent wants to respond. Check your sent (or draft) folder for the result. Enjoy all the free time you now have!! If you have questions or need assistance, email us at: [email protected]: This template does not include retrieving email addresses out of the message or body of the email.

Platform: n8n

Tools Used: OpenAI, Outlook

Categories: Customer Support, Email, Productivity

๐Ÿค– Control Discord Bot with Natural Language via MCP Server
What it is: I wanted to create a simple, easy-to-use, MCP server for your Discord bot(s). How to set up: Literally all you do is select your bot auth (or create a new Discord Bot auth if you haven't entered your key in n8n before) and that's IT! How to use it: You can now ask your bot to do things via any MCP client, including from within N8N workflows! Note: If you need an example, you can check out my simple quickstart Discord MCP Server that uses 4o to send messages to channels on your server and users who are members of the server the bot is in.

Platform: n8n

Tools Used: MCP Server, Discord

Categories: AI, Dev Ops, Productivity

๐Ÿ“ฉ Send Telegram Messages for New Articles from RSS Feed using Perplexity AI & ChatGPT
Automatically send a Telegram message for every new article from an RSS feed, using Perplexity AI and ChatGPT to generate engaging content.

Platform: Make

Tools Used: Perplexity AI, ChatGPT, Telegram

Categories: Content Creation, Social Media Management

๐ŸŒ Extract University Term Dates from Excel Using Cloudflare
This n8n template imports an XLSX containing term dates for a university, extracts the relevant events using AI, and converts the events to an ICS file which can be imported into iCal, Google Calendar, or Outlook. Manually adding important term dates to your calendar by hand? Stop! Automate it with this simple AI/LLM-powered document understanding and extraction template. This cool use-case can be applied to many scenarios where Excel files are predominantly used. How it works The term dates excel file (xlsx) is imported into the workflow from the university's website using the HTTP request node. To parse the excel file, we use an external service - Cloudflare's Markdown Conversion Service. This converts the excel's sheets into markdown tables which our LLM can read. To extract the events and their dates from the markdown, we can use the Information Extractor node for structured output. LLMs are great for this use-case because they can understand the layout; one row may have many data points. With our data, there are endless possibilities to use it! But for this demonstration, we'll generate an ICS file so that we can import the extracted events into our calendar. We use the Python code node to combine the events into the ICS spec and the "Convert to File" node to create the ICS binary. Finally, let's distribute the ICS file by email to other students or instructors who may also find this incredibly helpful for the upcoming semester! How to use Ensure you're downloading the correct excel file and amend the URL parameter of the "Get Term Dates Excel" as necessary. Update the Gmail node with your email or other emails as required. Alternatively, send the ICS file to Google Drive or a student portal. Requirements - Cloudflare Account is required to use the Markdown Conversion Service. - Gemini for LLM document understanding and extraction. - Gmail for email sending. Customizing the workflow This template should work for other Excel files which - for a university - there are many. Some will be more complicated than others, so experiment with different parsers and extraction tools and strategies.

Platform: n8n

Tools Used: Cloudflare, Gemini, Gmail

Categories: AI, Data Management, Calendar

๐ŸŽง Translate Audio with AI
Overview This workflow takes some French text and translates it into spoken audio. It then transcribes that audio back into text, translates it into English, and generates an audio file of the English text. To do so, it uses ElevenLabs (which has a free tier) and OpenAI. Setup These steps should only take a few minutes: 1. In ElevenLabs, add a voice to your voice lab and copy its ID. Add it to the 'Set voice ID' node. 2. Get your ElevenLabs API key (click your name in the bottom-left of ElevenLabs and choose โ€˜profileโ€™). 3. In the 'Generate French audio' node, create a new header auth cred. Set the name to xi-api-key and the value to your API key. 4. In the 'credential' field of the 'Transcribe audio' node, create a new OpenAI cred with your OpenAI API key. 5. Run the workflow by clicking the orange button at the bottom of the canvas.

Platform: n8n

Tools Used: OpenAI, ElevenLabs

Categories: Translation, AI, Content Creation

โœ๏ธ๐ŸŒ„ WordPress AI Content Creator Quick Start
โœ๏ธ๐ŸŒ„ WordPress + AI Content Creator This workflow automates the creation and publishing of multi-reading-level content for WordPress blogs. It leverages AI to generate optimized articles, automatically creates featured images, and provides versions of the content at different reading levels (Grade 2, 5, and 9). --- How It WorksContent Generation & Processing ๐ŸŽฏ - Starts with a manual trigger and a user-defined blog topic - Uses AI to create a structured blog post with proper HTML formatting - Separates and validates the title and content components - Saves a draft version to Google Drive for backup --- Multi-Reading Level Versions ๐Ÿ“š Automatically rewrites the content for different reading levels: - Grade 9: Sophisticated language with appropriate metaphors - Grade 5: Simplified with light humor and age-appropriate examples - Grade 2: Basic language with simple metaphors and child-friendly explanations --- WordPress Integration ๐ŸŒ - Creates a draft post in WordPress with the Grade 9 version - Generates a relevant featured image using Pollinations.ai - Automatically uploads and sets the featured image - Sends success/error notifications via Telegram --- Setup Steps 1. Configure API Credentials ๐Ÿ”‘ - Set up WordPress API connection - Configure OpenAI API access - Set up Google Drive integration - Add Telegram bot credentials for notifications 2. Customize Content Parameters โš™๏ธ - Adjust reading level prompts as needed - Modify image generation settings - Set WordPress post parameters 3. Test and Deploy ๐Ÿš€ - Run a test with a sample topic - Verify all reading level versions - Check WordPress draft creation - Confirm notification system --- This workflow is perfect for content creators who need to maintain a consistent blog presence while catering to different audience reading levels. It's especially useful for educational content, news sites, or any platform that needs to communicate complex topics to diverse audiences.

Platform: n8n

Tools Used: WordPress, OpenAI, Google Drive

Categories: Content Creation, Education, AI

โœจ Survey Insights with Qdrant and Python
This n8n template is one of a 3-part series exploring use cases for clustering vector embeddings: Survey InsightsCustomer InsightsCommunity Insights This template demonstrates the Survey Insights scenario where survey participant responses can be quickly grouped by similarity, and an AI agent can generate insights on those groupings. With this workflow, researchers can save days and even weeks of work breaking down cohorts of participants and identifying frequently mentioned positives and negatives. How it works All survey questions and responses are imported from a Google Sheet. Responses are then inserted into a Qdrant collection, carefully tagged with the question and survey metadata. For each question, all relevant responses are put through a clustering algorithm using the Python Code node. The Qdrant points are returned in clustered groups. Each group is looped to fetch the payloads of the points and feed them to the AI agent to summarize and generate insights for. The resulting insights and raw responses are then saved to the Google Spreadsheet for further analysis by the researcher. Requirements - Survey data and format as shown in the attached Google Sheet. - Qdrant Vectorstore for storing embeddings. - OpenAI account for embeddings and LLM.Customizing the Template Adjust clustering parameters that make sense for your data. Add more clusters for open-ended questions and fewer clusters when responses are multiple choice.

Platform: n8n

Tools Used: Qdrant, OpenAI

Categories: Research, AI, Data Management

๐Ÿš€ Amazon Product Search Scraper with BrightData, GPT-4 & Google Sheets
This workflow automates web scraping of Amazon search result pages by retrieving raw HTML, cleaning it to retain only the relevant product elements, and then using an LLM to extract structured product data (name, description, rating, reviews, and price), before saving the results back to Google Sheets. It integrates Google Sheets to supply and collect URLs, BrightData to fetch page HTML, a custom n8n Function node to sanitize the HTML, LangChain (OpenRouter GPT-4) to parse product details, and Google Sheets again to store the output. Who Needs Amazon Search Result Scraping? This scraping workflow is ideal for teams and businesses that need to monitor Amazon product listings at scale: - E-commerce Analysts โ€“ Track competitor pricing, ratings, and inventory trends. - Market Researchers โ€“ Collect data on product popularity and reviews for market analysis. - Data Teams โ€“ Automate ingestion of product metadata into BI pipelines or data lakes. - Affiliate Marketers โ€“ Keep affiliate catalogs up to date with the latest product details and prices. If you need reliable, structured data from Amazon search results delivered directly into your spreadsheets, this workflow saves you hours of manual copy-and-paste. Why Use This Workflow? - End-to-End Automation โ€“ From URL list to clean JSON output in Sheets. - Robust HTML Cleaning โ€“ Strips scripts, styles, unwanted tags, and noise. - Accurate Structured Parsing โ€“ Leverages GPT-4 via LangChain for reliable extraction. - Scalable & Repeatable โ€“ Processes thousands of URLs in batches. Step-by-Step: How This Workflow Scrapes Amazon 1. Get URLs from Google Sheets โ€“ Reads a list of search result URLs. 2. Loop Over Items โ€“ Iterates through each URL in controlled batches. 3. Fetch Raw HTML โ€“ Uses BrightDataโ€™s Web Unlocker proxy to retrieve the page. 4. Clean HTML โ€“ A Function node removes doctype, scripts, styles, head, comments, classes, and non-whitelisted tags, collapsing extra whitespace. 5. Extract with LLM โ€“ Passes cleaned HTML into LangChain โ†’ GPT-4 to output JSON for each product: name, description, rating, reviews, price. 6. Save Results โ€“ Appends the JSON fields as columns back into a โ€œresultsโ€ sheet in Google Sheets. Customization: Tailor to Your Needs - Adaptable Sites โ€“ This workflow can be adapted to any e-commerce or other website, for example, Walmart or eBay. - Whitelist Tags โ€“ Modify the allowedTags array in the Code node to keep additional HTML elements. - Schema Changes โ€“ Update the Structured Output Parser schema to include more fields (e.g., availability, SKU). - Alternate Data Sink โ€“ Instead of Sheets, route output to a database, CSV file, or webhook. Prerequisites - Google Sheets Credentials โ€“ OAuth credentials configured in n8n. - BrightData API token โ€“ Stored in n8n credentials as BRIGHTDATA_TOKEN. - OpenRouter API Key โ€“ Configured for the LangChain node to call GPT-4. - n8n Instance โ€“ Self-hosted or cloud with sufficient quota for HTTP requests and LLM calls. Installation & Setup 1. Configure Credentials - In n8n, set up Google Sheets OAuth under โ€œCredentials.โ€ - Add BrightData token as a new HTTP Request credential. - Create an OpenRouter API key credential for the LangChain node. 2. Import the Workflow - Copy the JSON workflow into n8nโ€™s โ€œImportโ€ dialog. - Map your Google Sheet IDs and GIDs to the {{WEB_SHEET_ID}}, {{TRACK_SHEET_GID}}, and {{RESULTS_SHEET_GID}} placeholders. - Ensure the BRIGHTDATA_TOKEN credential is selected on the HTTP Request node. 3. Test & Run - Add a few Amazon search URLs to your โ€œtrackโ€ sheet. - Execute the workflow and verify product data appears in your โ€œresultsโ€ sheet. - Tweak batch size or parser schema as needed. Important - API Rate Limits โ€“ Monitor your BrightData and OpenRouter usage to avoid throttling. - Amazonโ€™s Terms โ€“ Ensure your scraping complies with Amazonโ€™s policies and legal requirements. This workflow delivers a fully automated, scalable solution to extract structured product data from Amazon search pages directly into Google Sheetsโ€”streamlining your competitive analysis and data collection.

Platform: n8n

Tools Used: BrightData, GPT-4, Google Sheets

Categories: Ecommerce, Data Extraction

๐Ÿš€ Extract & Summarize Bing Copilot Results with Gemini AI & Bright Data
Who is this for? This workflow automates the process of querying Bing's Copilot Search, extracting structured data from the results, summarizing the information, and sending a notification via webhook. It leverages the Microsoft Copilot to retrieve search results and integrates AI-powered tools for data extraction and summarization. Data Analysts and Researchers: Who need to gather and summarize information from Bing search results efficiently. Developers and Engineers: Looking to integrate Bing search data into applications or services. Digital Marketers and SEO Specialists: Interested in monitoring search engine results for specific keywords or topics. What this workflow does Manually extracting and summarizing information from search engine results can be time-consuming and error-prone. This workflow automates the process by: - Performing Bing searches using Bright Data's Bing Search API. - Extracting structured data from the search results. - Summarizing the extracted information using AI tools. - Sending the summarized data to a specified endpoint via webhook. How to customize this workflow to your needs - Modify Search Queries: Adjust the search terms to target different topics or keywords. - Change Data Extraction Logic: Customize the extraction process to capture specific data points from the search results. - Alter Summarization Techniques: Integrate different AI models or adjust parameters to change how summaries are generated. - Update Webhook Endpoints: Direct the summarized data to different endpoints as required. - Schedule Workflow Runs: Set up automated triggers to run the workflow at desired intervals.

Platform: n8n

Tools Used: Bright Data, Google Gemini, OpenAI

Categories: Data Extraction, AI, Research

๐Ÿ“ข Auto-Post Breaking News with Perplexity AI to X
Stay ahead of the curve and keep your followers informedโ€”automatically. This n8n workflow uses Perplexity AI to generate insightful answers to scheduled queries, then auto-posts the responses directly to X (Twitter). โš™๏ธ What this workflow does - Scheduled Trigger โ€“ Runs at set times (daily, hourly, etc.). - searchQuery โ€“ Define what kind of trending or relevant insight you want (e.g. โ€œlatest AI trendsโ€). - set API Key โ€“ Securely insert your Perplexity API key. - Perplexity API Call โ€“ Fetches a short, insightful response to your query. - Post to X โ€“ Automatically publishes the result as a tweet. ๐Ÿงฉ Requirements - An n8n account (self-hosted or cloud) - A Perplexity API key - A connected X (Twitter) account via n8nโ€™s credentials โœ… Setup Steps 1. Add this workflow into your n8n account. 2. Edit the searchQuery node with a topic (e.g. โ€œWhatโ€™s new in ecommerce automation?โ€). 3. Paste your Perplexity API key into the set API key node. 4. Connect your X (Twitter) account in the final node. 5. Adjust the schedule timing to suit your content frequency. ๐Ÿ’ก Ideas to Improve - ๐Ÿ’ฌ Add a formatting step to shorten or hashtag the response. - ๐Ÿ“Š Pull multiple trending questions and auto-schedule posts. - ๐Ÿ” Loop responses to queue a full week of content. - ๐ŸŒ Translate content before posting to reach a global audience. ๐Ÿ†˜ Need help? Join our Discord for tips, support, and inspiration.

Platform: n8n

Tools Used: Perplexity AI

Categories: Social Media Management, Content Creation, Marketing

๐ŸŒŸ Create Google Ads Copy with Notion & ChatGPT
Maximize your Google Ads performance and drive conversions by creating engaging, keyword-rich ads seamlessly integrating Notion and ChatGPT.

Platform: Make

Tools Used: ChatGPT, Notion

Categories: Marketing, Content Creation, Ads

๐Ÿค– Automate Cal.com Meeting Management with Google Sheets, Beehiiv & Telegram
This n8n workflow template automates the process of managing meeting guests booked through Cal.com. It captures attendee information, logs it in a Google Sheet, and subscribes new guests to your Beehiiv newsletter, while also notifying you in Telegram. How it Works This workflow is designed to streamline your post-booking process. When a new meeting is booked via Cal.com, the workflow automatically triggers. It extracts the attendee details, adds a new row with the guest's information to a designated Google Sheet, and then adds the guest as a subscriber to your Beehiiv newsletter. Finally, it sends a notification to a specified Telegram channel, keeping you informed of new subscribers. Features - Automated Data Entry: Automatically log meeting guest details into Google Sheets. - Newsletter Growth: Effortlessly add new meeting guests to your Beehiiv subscriber list. - Real-time Notifications: Get instant alerts in Telegram for new subscribers. - Seamless Integration: Connects Cal.com, Google Sheets, Beehiiv, and Telegram. Set Up To use this workflow, you will need the following: - Cal.com: Set up a Cal.com account and configure a webhook to trigger the workflow on new bookings. You will need the webhook URL provided by the first node in this workflow. - Google Cloud: A Google Cloud account with access to Google Sheets. You will need to specify the Sheet and the range where data should be added. - Beehiiv: A Beehiiv account. You will need your Beehiiv API key and the publication ID of your newsletter. - Telegram Account: A Telegram account and a channel where you want to receive notifications. You will need your Telegram Bot Token and the chat ID of the channel. Configure each node in the workflow with your respective API keys, IDs, and sheet details as required. The "Define your parameters" box in the workflow provides guidance on finding your Telegram chat ID and Beehiiv API key/publication ID. Additional Enhancements This workflow can be extended and customized further: - Conditional Logic: Add filters to only subscribe guests based on certain criteria (e.g., specific meeting types). - Data Enrichment: Integrate with other services to enrich guest data before adding to Google Sheets or Beehiiv. - CRM Integration: Connect to a CRM to create or update contact records for new guests. - Custom Notifications: Customize the content and format of the Telegram notification. Need Help? If you need assistance setting up this workflow, encounter any issues, or would like to explore setting up similar automation workflows tailored to your company's specific needs, please contact us at 1 Node.

Platform: n8n

Tools Used: Google Sheets, Beehiiv, Telegram

Categories: Productivity, Customer Support