Marketing

Supabase Automation

38 nodes 197 120 Automatic trigger
Download

Workflow Description

Advanced automation using Supabase database with an intelligent OpenAI agent to process, deduplicate, and analyze data automatically. Streamlines marketing workflows by eliminating manual data handling and ensuring clean, actionable insights.

How it works

  1. 1.Trigger workflow manually or receive event from Supabase database
  2. 2.Invoke OpenAI agent to analyze and classify incoming data intelligently
  3. 3.Remove duplicate records and cleanse dataset using deduplication logic
  4. 4.Merge results and apply custom filters based on business rules
  5. 5.Aggregate processed data and output via HTTP request or save to Supabase

Use cases

  • Automate subscriber list management by detecting and removing duplicates and errors
  • Analyze customer interactions and segment them for targeted marketing campaigns
  • Process incoming requests and organize data for follow-up actions

Requirements

  • Active Supabase account with pre-configured database and tables
  • Valid OpenAI API key with access to chat models
  • Read and write permissions on target Supabase tables

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Tool OpenAI Output Parser Supabase Remove Duplicates AI Agent

Details

Trigger Automatic trigger
Nodes 38
Apps 6
Views 197
Downloads 120

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (38)

/

Text

Tool Workflow

#1

URLs

Tool Workflow

#2

OpenAI Chat Model

OpenAI

#3

JSON Parser

Output Parser Structured

#4

Map company name and website

Set

#5

Execute workflow

Manual Trigger

#6

Get companies

Supabase

#7

Select company name and website

Set

#8

Set social media array

Set

#9

Merge all data

Merge

#10

Insert new row

Supabase

#11

Convert HTML to Markdown

Markdown

#12

Sticky Note

Sticky Note

#13

Sticky Note1

Sticky Note

#14

Sticky Note2

Sticky Note

#15

Retrieve URLs

HTML Page

#16

Split out URLs

Split Out

#17

Remove duplicated

Remove Duplicates

#18

Set domain to path

Set

#19

Filter out invalid URLs

Filter

#20

Aggregate URLs

Aggregate

#21

Filter out empty hrefs

Filter

#22

Set domain (text)

Set

#23

Add protocool to domain (text)

Set

#24

Get website (text)

HTTP Request

#25

Set response (text)

Set

#26

Set domain (URL)

Set

#27

Get website (URL)

HTTP Request

#28

Set response (URL)

Set

#29

Sticky Note3

Sticky Note

#30

Sticky Note4

Sticky Note

#31

Sticky Note5

Sticky Note

#32

Sticky Note6

Sticky Note

#33

Sticky Note7

Sticky Note

#34

Add protocool to domain (URL)

Set

#35

Sticky Note8

Sticky Note

#36

Sticky Note9

Sticky Note

#37

Crawl website

Agent

#38