Quick overview This workflow pulls companies from Supabase, uses an OpenAI (GPT-4o) agent to crawl each company website and collect social media profile URLs via HTTP requests and HTML parsing, and then writes the enriched company record (name, website, and social links) back to Supabase. How it works Runs manually and loads all company records from a Supabase companies_input table. Keeps only each company’s name and website fields and sends the website to an OpenAI (GPT-4o) agent. The agent fetches page text (HTML converted to Markdown) and extracts links from pages (anchor hrefs), following additional URLs as needed to find social profiles. The agent returns a structured JSON object of social media platforms and their profile URLs. The workflow combines the extracted social links with the original company name and website. Inserts the enriched record into the Supabase companies_output table. Setup Add a Supabase credential and set the correct workspace/project so the workflow can read from companies_input and write to companies_output. Add an OpenAI API key in the OpenAI Chat Model node (configured for GPT-4o).
Tags
Call n8n Workflow Tool
OpenAI Chat Model
Structured Output Parser
SupabaseRelated workflows
See all AI Automation→Manage Google and Trustpilot reviews with OpenAI and Slack
Quick overview This workflow runs hourly to fetch new Google Business Profile and Trustpilot reviews, deduplicates them, uses OpenAI via a LangChain agent to draft sentiment-aware replies, escalates negative reviews in Slack, and routes positive replies to Slack for approval before posting the reply back to Trustpilot. How it works Runs every hour on a schedule. Fetches the latest reviews from the Google Business Profile API and the Trustpilot API and combines the results. Deduplicates reviews by tracking previously seen review IDs in workflow static data and stops if there are no new reviews. Processes each new review and uses OpenAI (via a LangChain agent) to generate structured JSON containing sentiment, a draft reply, and an optional suggested resolution. Sends negative reviews to a Slack channel for the owner along with the suggested resolution. Sends positive draft replies to Slack for one-tap approval (with a 24-hour timeout) and, if approved, publishes the reply to the Trustpilot API. Sends a Slack alert to the ops channel if the workflow errors. Setup Configure authentication and replace placeholders for the Google Business Profile reviews endpoint (account and location) i
Publish AI social posts from Telegram to LinkedIn, Instagram, Facebook and Threads with OpenAI and Blotato
Quick overview This workflow listens for a Telegram message or voice note, uses OpenAI to turn it into a cross-platform social caption and matching AI image, publishes the post via Blotato to LinkedIn, Instagram, Facebook, and Threads, then sends a confirmation back to Telegram. How it works Triggers when a new Telegram message is received by your bot. Routes the input as voice or text, downloading voice notes from Telegram and transcribing them with OpenAI. Sends the resulting text to an OpenAI chat model to generate a single ready-to-publish caption plus an image prompt. Generates an image with OpenAI (gpt-image-1) using the returned image prompt. Uploads the generated image to Blotato to get a hosted media URL. Publishes the caption and image to LinkedIn, Instagram, Facebook Pages, and Threads through Blotato. Sends a Telegram message confirming publication and includes the posted caption. Setup Create a Telegram bot in @BotFather, add the bot token as a Telegram credential in n8n, and activate the Telegram Trigger. Add an OpenAI API credential for audio transcription, caption generation, and image generation, and (optionally) adjust the model, language, image size, and quality
Generate daily auto-service AI videos and post them with OpenAI, Perplexity, AtlasCloud, and Blotato
Quick overview This workflow runs daily (or manually) to research an auto-service topic with Perplexity, generate a caption and text-to-video prompt with OpenAI, render an AI video via AtlasCloud, then publish it to TikTok, YouTube, Instagram, and Facebook through Blotato while sending a Telegram preview. How it works Runs every morning on a schedule (or starts via a manual trigger). Loads your business settings (name, topic, language, video format, and CTA) from a central configuration. Uses Perplexity web research plus an OpenAI chat model to produce a structured caption, hashtags, and a cinematic text-to-video prompt. Sends the prompt to AtlasCloud to generate a short vertical video and waits before polling AtlasCloud for the render status. Repeats the wait-and-check loop until AtlasCloud reports the video render as completed. Prepares the final caption and video URL, then publishes the video to TikTok, YouTube, Instagram Reels, and Facebook Reels via Blotato and sends a Telegram message with the post preview and video link. Setup Add credentials for OpenAI, Perplexity, AtlasCloud (HTTP Header Auth), Blotato, and Telegram. Update the Configuration values (business name, topic, C