🗄️ Data & StorageIntermediate● Active

01 - Keyword Search & Store

A 16-step data & storage automation, triggered by schedule, sub-workflow, connecting Supabase, HTTP / REST API, PostgreSQL.

⬇ Download workflow JSON
💡

What this does for your business

In plain terms: this keeps your systems in sync. It moves and updates information across Supabase, PostgreSQL on a set schedule (e.g. daily), so you never copy-paste between tools again.

16
Nodes
3
Integrations
15
Connections
Schedule, Sub-workflow
Trigger

🚀 Deploy this workflow

Deploy this automation in minutes

Log in and we'll walk you through every key step by step, then deploy it for you.

Get started free Log in

🏗️ Architecture diagram

The real node graph exported from n8n — triggers (green), AI nodes (violet), services and logic — laid out as they run.

Schedule TriggerscheduleTriggerGet Active Keywordssupabase🌐YouTube API SearchhttpRequestSplit Video ItemssplitOut🌐Get Video StatisticshttpRequestCalculate Viral Scorecode🐘Store in yt_videospostgresIs Viral?if🐘Update Keyword Timest…postgres🐘Store in yt_viral_vid…postgresWhen Executed by Anot…executeWorkflowTrig…Normalize Keyword Inp…setNormalize Competitor …set🐘Store in yt_viral_vid…postgres🐘Store in yt_videos co…postgreskw || comp_idif

⚙️ How it works

  1. Schedule Trigger · scheduleTrigger
  2. When Executed by Another Workflow · executeWorkflowTrigger
  3. Get Active Keywords · supabase
  4. Normalize Competitor Input · set
  5. YouTube API Search · httpRequest
  6. Get Video Statistics · httpRequest
  7. Split Video Items · splitOut
  8. Calculate Viral Score · code
  9. Normalize Keyword Input · set
  10. Is Viral? · if
  11. Update Keyword Timestamp · postgres
  12. kw || comp_id · if
  13. Store in yt_videos · postgres
  14. Store in yt_videos comp_ID · postgres

💼 Business analysis

🎯

Business use case

A data pipeline that moves, syncs and transforms records across Supabase, HTTP / REST API, PostgreSQL — the plumbing that keeps systems of record consistent without manual exports.

📈

Market need

Disconnected tools create silos and manual re-entry. Reliable sync pipelines are foundational infrastructure every scaling company needs.

💰

Market value

Integration/ETL work bills $100–$200/hr bespoke; a reliable pipeline template saves days of engineering per deployment.

🧩 Integrations & stack

Supabase🌐HTTP / REST API🐘PostgreSQL
Node typesscheduleTrigger, supabase, httpRequest, splitOut, code, postgres, if, executeWorkflowTrigger, setWorkflow IDfHr2mEuQ5Q1zcZE9
⬇ Download workflow JSON ← Back to library