Templates / Enrich company records with social media links using GPT-4o and Supabase

Enrich company records with social media links using GPT-4o and Supabase

Needs changes

by Redowan Ahmed Farhan ✓ · 6 views · created 2026-07-14 · Lead Generation, AI RAG

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What to replace before upgrading

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
Crawl website (v1.6)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (8)

Call n8n WorkflowOpenAI Chat ModelStructured Output ParserSupabaseAI Agent

What it does

Quick overview This workflow is manually triggered to pull company names and websites from Supabase, crawl each site with an OpenAI-powered agent to extract social media profile URLs, and write the enriched results to a separate Supabase table. How it works 1. Runs when you manually execute the workflow. 2. Reads all rows from the Supabase companiesinput table and keeps the name and website fields for processing. 3. Uses an OpenAI (GPT-4o) agent to crawl the company website, following discovered links and extracting social media profile URLs. 4. Forces the agent output into a structured JSON schema and maps the extracted links into a socialmedia array. 5. Merges the original company name and website with the extracted social media data. 6. Inserts the enriched record into the Supabase companiesoutput table. Setup 1. Add a Supabase credential and set the correct project details for both reading from companiesinput and writing to companiesoutput. 2. Add an OpenAI API credential for the GPT-4o chat model used by the crawling agent. 3. Ensure your input table has name and website fields or update the field selection and mapping to match your schema. 4. Confirm the output table accepts the mapped fields (for example companyname, companywebsite, and socialmedia) when auto-mapping input data.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.