Generate pro construction quotes from jotform to email with Supabase CRM
Ready for 3.0What 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).
- Parser (Edit Fields (Set)): sets 3 fields: body.rawRequest, ai.content, submission_id
- SQL Schema Generator (Code): runs custom JavaScript code
- Fetch Mapping Rules (Supabase): get many
- Save Form Submission (Supabase): uses Supabase
- Prepare AI Context (Edit Fields (Set)): sets 6 fields: service_types, property_types, ceiling_heights…
- upsert form submission -error (Stop and Error): stops the run with an error
- Normalize Form Data (Code): runs custom JavaScript code
- Upsert Customer (Supabase): uses Supabase
- Create Deal (Supabase): uses Supabase
- 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
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)
- Webhook
n8n-nodes-base.webhook - Split Out
n8n-nodes-base.splitOut - Stop and Error
n8n-nodes-base.stopAndError - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Supabase
n8n-nodes-base.supabase - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail
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.…