This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically analyzes online data sources to uncover unmet customer needs and product opportunities. Instead of spending days on manual research, you receive an AI-driven report of market gaps directly in your inbox. Overview The automation aggregates product reviews, forum discussions, and competitor feature lists via Bright Data scraping. OpenAI then clusters complaints and feature requests to highlight where demand is high but supply is low. A summary table is generated in Google Sheets and a concise report is emailed to stakeholders. Tools Used n8n** – Automates the entire pipeline Bright Data** – Scrapes review sites and competitor pages reliably OpenAI** – Performs NLP clustering and gap analysis Google Sheets** – Stores structured opportunity data Gmail** – Delivers the weekly insight report How to Install Import the Workflow: Add the .json to your n8n instance. Configure Bright Data: Insert your credentials in the MCP Client node. Set Up OpenAI: Provide your OpenAI API key. Connect Google Sheets & Gmail: Authorize both services.
Tags
Auto-fixing Output ParserCCode
Google Sheets
OpenAI Chat Model
Structured Output ParserRelated workflows
See all AI Automation→
Route WhatsApp support requests with Claude, Supabase, HubSpot and Slack
Quick overview This workflow turns incoming WhatsApp messages (text, audio, images, and documents) into actionable support interactions by extracting content, detecting sentiment, and using an AI agent with a Supabase knowledge base to route requests to Google Calendar, HubSpot, Slack, Gmail, and back to WhatsApp. How it works Receives incoming WhatsApp messages via a WhatsApp webhook trigger. Routes the message by type and converts it into text using OpenAI Whisper for audio, OpenAI GPT-4o Vision for images, or a PDF extractor for documents (or passes text messages through). Loads the sender’s session context from Supabase and runs sentiment/language detection on the extracted text. Uses a LangChain AI agent (Claude) with Supabase vector search (with OpenAI embeddings and Cohere reranking) plus tool access (Google Calendar, HubSpot, Slack, and Gmail) to produce a structured intent, response, and metadata. Logs conversation analytics (intent, sentiment, message type, and response length) to an n8n Data Table. Routes by intent to either create a Google Calendar event, create/update a HubSpot contact, email a document via Gmail (and upload it to Google Drive), create a HubSpot ticket
Create TikTok carousel posts with Upload Post, Google Sheets, Gemini, GPT-4.1
Quick overview This workflow runs daily to pull TikTok post and profile analytics from Upload Post, updates a Google Sheets performance log, uses Google Gemini and OpenAI to generate a new carousel concept and caption, creates four images via fal.ai, publishes to TikTok, and updates a persistent “Agent Skill” sheet. How it works Runs on a daily schedule (or manually) and loads product, Upload Post, and Google Sheets configuration values. Reads the Google Sheets “Performance Log,” selects posts missing stats or posted recently, fetches TikTok post analytics from the Upload Post API, and writes updated metrics back to the sheet. Aggregates the refreshed history, fetches TikTok profile analytics from Upload Post, reads the “Agent Skill” sheet, and compiles a single context summary. Uses Google Gemini (via a structured JSON output) to generate a TikTok carousel plan including caption, strategy notes, four slide prompts, hashtags, and an engagement question. Sends the four prompts to fal.ai to generate four 9:16 PNG carousel images and collects their hosted image URLs. Uses OpenAI (GPT-4.1) to write a short TikTok photo-post description, publishes the carousel to TikTok via Upload Post
Create and approve AI social posts with OpenAI, Telegram and Blotato
Quick overview This workflow runs daily to generate an AI-written social post and DALL·E image with OpenAI, sends it to Telegram for approval, and—if approved—publishes it to LinkedIn, X, Instagram, Facebook, and Threads via Blotato while logging outcomes to Google Sheets. How it works Runs every 24 hours on a schedule trigger. Uses OpenAI to generate a single content topic (title, angle, and hook) based on your niche, audience, and language settings. Uses OpenAI to write one social post with a separate hashtag line and an image prompt in your specified tone and style. Uses OpenAI Images (DALL·E) to generate a matching image and extracts a shareable image URL. Sends the post text, hashtags, and image link to Telegram and waits for you to approve or skip within the configured time window. If approved, publishes the post with the image to LinkedIn, X, Instagram, Facebook, and Threads using Blotato and appends a “Published” log row to Google Sheets. If skipped or not approved, appends a “Skipped” log row to Google Sheets. Setup Add OpenAI API credentials and ensure the selected chat model and image model in the configuration match models available to your account. Add Telegram credent