Publish Operational Assessment Microsites with Supabase

Automatically publish Operational Assessment microsites from Supabase—every 6 hours

This n8n workflow automatically pulls approved operational assessment records from Supabase, validates the required fields, generates a structured microsite content payload, and upserts it into your Supabase microsites table—then updates the source record with a published URL or a failure reason.

What this workflow does

• Runs on demand or on a schedule—triggered manually or every six hours.
• Fetches approved queue items by requesting up to a configured maximum number of records from assessment_microsite_queue where status = approved.
• Processes each assessment: splits the response into individual assessments, normalizes the microsite slug, and validates required fields (including company, slug, and assessment summary).
• Builds microsite page content including headlines, summary, cards, opportunity ideas, and a call-to-action URL.
• Upserts microsites into the microsites table using the slug as the conflict key (and requests the merged record back).
• Publishes or fails: updates the original Supabase assessment record as published with the generated microsite URL, or marks it as failed with a validation/publish error.

Use cases

• Publish client-facing operational assessment microsites as soon as records are approved in Supabase.
• Keep microsite content consistent by enforcing required fields (company, slug, assessment summary) before publishing.
• Support an operations team pipeline where “approved” items in assessment_microsite_queue automatically become live microsites.

Technical details

• Triggers: Manual Trigger and a six-hour schedule.
• Node types used: if, set, code, and HTTP Request steps (plus sticky notes/structure).
• Supabase integration: Supabase API credential configured in each Supabase HTTP Request step.
• Database flow: reads from assessment_microsite_queue, writes/upserts to microsites, then updates the source assessment record with a microsite URL or failure reason.

Setup note: create/align the referenced Supabase tables and update “Set Microsite Settings” with your Supabase project URL, table names, and public site base URL.