{"product_id":"publish-operational-assessment-microsites-with-supabase","title":"Publish Operational Assessment Microsites with Supabase","description":"\u003ch3\u003eAutomatically publish Operational Assessment microsites from Supabase—every 6 hours\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls approved \u003cstrong\u003eoperational assessment\u003c\/strong\u003e records from \u003cstrong\u003eSupabase\u003c\/strong\u003e, validates the required fields, generates a structured microsite content payload, and upserts it into your Supabase \u003ccode\u003emicrosites\u003c\/code\u003e table—then updates the source record with a published URL or a failure reason.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or on a schedule\u003c\/strong\u003e—triggered manually or every six hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches approved queue items\u003c\/strong\u003e by requesting up to a configured maximum number of records from \u003ccode\u003eassessment_microsite_queue\u003c\/code\u003e where \u003ccode\u003estatus = approved\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses each assessment\u003c\/strong\u003e: splits the response into individual assessments, normalizes the microsite slug, and validates required fields (including company, slug, and assessment summary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds microsite page content\u003c\/strong\u003e including headlines, summary, cards, opportunity ideas, and a call-to-action URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts microsites\u003c\/strong\u003e into the \u003ccode\u003emicrosites\u003c\/code\u003e table using the slug as the conflict key (and requests the merged record back).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes or fails\u003c\/strong\u003e: updates the original Supabase assessment record as \u003ccode\u003epublished\u003c\/code\u003e with the generated microsite URL, or marks it as \u003ccode\u003efailed\u003c\/code\u003e with a validation\/publish error.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePublish client-facing operational assessment microsites as soon as records are approved in Supabase.\u003c\/li\u003e\n  \u003cli\u003eKeep microsite content consistent by enforcing required fields (company, slug, assessment summary) before publishing.\u003c\/li\u003e\n  \u003cli\u003eSupport an operations team pipeline where “approved” items in \u003ccode\u003eassessment_microsite_queue\u003c\/code\u003e automatically become live microsites.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\u003c\/strong\u003e: Manual Trigger and a six-hour schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNode types used\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, and HTTP Request steps (plus sticky notes\/structure).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase integration\u003c\/strong\u003e: Supabase API credential configured in each Supabase HTTP Request step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDatabase flow\u003c\/strong\u003e: reads from \u003ccode\u003eassessment_microsite_queue\u003c\/code\u003e, writes\/upserts to \u003ccode\u003emicrosites\u003c\/code\u003e, then updates the source assessment record with a microsite URL or failure reason.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e create\/align the referenced Supabase tables and update “Set Microsite Settings” with your Supabase project URL, table names, and public site base URL.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812004978867,"sku":"N8N-17981","price":44.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BknceIpd487GLVWwxoY1l_5fZD1Fbr.png?v=1786352540","url":"https:\/\/buyflowscripts.com\/products\/publish-operational-assessment-microsites-with-supabase","provider":"N8N Commerce","version":"1.0","type":"link"}