Templates / Generate pro construction quotes from jotform to email with Supabase CRM

Generate pro construction quotes from jotform to email with Supabase CRM

Ready for 3.0

by Stephan Koning ✓ · 322 views · created 2025-10-14 · CRM

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 21 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Supabase and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

  1. Parser (Edit Fields (Set)): sets 3 fields: body.rawRequest, ai.content, submission_id
  2. SQL Schema Generator (Code): runs custom JavaScript code
  3. Fetch Mapping Rules (Supabase): get many
  4. Save Form Submission (Supabase): uses Supabase
  5. Prepare AI Context (Edit Fields (Set)): sets 6 fields: service_types, property_types, ceiling_heights…
  6. upsert form submission -error (Stop and Error): stops the run with an error
  7. Normalize Form Data (Code): runs custom JavaScript code
  8. Upsert Customer (Supabase): uses Supabase
  9. Create Deal (Supabase): uses Supabase
  10. upsert form customer -error (Stop and Error): stops the run with an error

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

Services it uses

SupabaseGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (8)

From the author

Who it's for Construction and renovation businesses that need to generate detailed quotes from customer inquiries—plasterers, painters, contractors, renovation specialists, or any construction service provider handling quote requests through online forms.…

Excerpt from Stephan Koning's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.