Gumloop + Supabase n8n Workflow: Event & Speaker Search Scoring

Turn event and speaker searches into scored opportunities—automatically (Gumloop + Supabase in n8n)

This n8n workflow accepts event or speaker search requests via webhook, runs them through Gumloop, then stores, scores, and sorts the results in Supabase (Postgres). It can also email the formatted results via Gmail and provide a separate webhook to generate an outreach email draft using OpenAI.

What this workflow does

• Receives search requests from a Lovable app through a POST webhook, including mode-specific parameters (event: industry/location/vendor type; speaker: topic/context/location). Inputs are validated and normalized.
• Creates a “running” tracking record in Supabase to monitor progress, then immediately returns a request_id for polling.
• Optionally stores requester email in a Supabase subscribers table, then triggers the appropriate Gumloop flow via an HTTP request.
• Handles Gumloop callbacks: when Gumloop returns results (including request_id and a results array), the workflow retrieves the original request context from Supabase.
• Scores and sorts results: event results are scored using deadlines, and speaker results are scored using recency.
• Updates Supabase status to completed, and optionally sends results by Gmail.
• Provides retrieval webhooks: a GET results webhook returns status, stored results, and any error by request_id.
• DRAFTS outreach emails: a POST draft-email webhook sends opportunity details to OpenAI Chat Completions and returns a JSON subject + body.

Use cases

• Build an n8n-powered SaaS search endpoint that converts event/speaker discovery into ranked opportunities in Supabase.
• Generate timely speaker shortlists where scoring prioritizes recency.
• Automate outbound workflows: store scored results, email them to prospects, then create an OpenAI outreach draft.

Technical details

• n8n nodes: webhook, if, code, switch, gmail, postgres
• Data store: Supabase/Postgres (tracks request lifecycle, results, and optional subscribers)
• Search engine: Gumloop via HTTP, with callback processing and request_id correlation
• Email: Gmail (optional formatted results delivery)
• AI drafting: OpenAI Chat Completions API for outreach email subject/body