Free guide
Send web form leads to a sheet automatically
This workflow automatically sends web form leads from a plumber’s website to a spreadsheet and replies to the customer. It is designed for plumbing businesses.
Download the workflowA small file you import into n8n. Free.
From the video: Plumbers: form to sheet, no typing
Before you start
- an automation tool that supports webhooks and HTTP requests
- a sheet to store leads
- an email account for sending replies
Step by step
-
1
Receive web lead
Triggers when the web form sends a message.
-
2
Extract fields
Selects Name, Job, and Phone from the incoming data.
-
3
Add to sheet
Creates a new row in the chosen spreadsheet.
-
4
Send reply
Emails the customer with the defined subject and text.
Test it
Enter the test data (Name: Test Customer, Job: Leaking tap, Phone: 555-0101) into the webhook, run the workflow, then verify that a row with those values appears in the sheet and that an email with the subject “We got your request” and the body “Hi Test Customer, thanks. We will call you today.” is received.
Questions
How do I import this workflow into the automation tool?
Use the import feature of your tool and paste the JSON definition of the workflow.
Where do I put my own email address?
Replace the placeholder address in the Email node with the address you want to send from.
Should I test before going live?
Yes, run the workflow with the provided test data and confirm the sheet entry and reply email.