Publish operational assessment microsites from Supabase records

by Craig ✓ · 1 views · created 2026-08-10 · Content Creation

What this workflow does

This workflow has 14 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). It uses only n8n's built-in nodes.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Set Microsite Settings (Edit Fields (Set)): sets 7 fields: supabase_url, queue_table, microsites_table…
2. Fetch Approved Assessments (HTTP Request): calls an HTTP API (GET)
3. Split Assessment Records (Code): runs custom JavaScript code
4. Validate Assessment (Code): runs custom JavaScript code
5. If: checks a condition and branches into true / false
6. Build Microsite Content (Code): runs custom JavaScript code
7. Mark Invalid Assessment Failed (HTTP Request): calls an HTTP API (PATCH)
8. Publish Microsite Content (HTTP Request): calls an HTTP API (POST)
9. Check Publish Result (Code): runs custom JavaScript code
10. If: checks a condition and branches into true / false

…plus 2 more steps. See the full node list below.

Before you upgrade to n8n 3.0

Nodes used (6)

• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if

From the author

Quick Overview This workflow runs manually or every six hours to pull approved operational assessment records from Supabase, validate required fields, generate a structured microsite content object, upsert it into a Supabase microsites table, and update the…

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