Build a real, working automation in 15 minutes — free, visual, click by click
n8n Cloud: 14-day free trial, then $24/month. Self-hosted: FREE FOREVER.
Everything in this guide works on both Cloud and self-hosted. No paid features required.
We are building a Lead Capture Workflow. Here is what it does:
1. Someone submits a form on your website (we will use a webhook as the trigger)
2. n8n logs their info in a Google Sheet
3. n8n sends you an email notification
This is one of the most useful workflows in business. Every time someone fills out a contact form, signs up for a newsletter, or requests a quote, you get a tidy spreadsheet row and an instant heads-up in your inbox.
The flow looks like this:
Webhook (receives data) → Google Sheets (logs it) → Gmail (notifies you)
You will see a blank canvas. Click the workflow name at the top and rename it to "Lead Capture".
Select Webhook. This creates a URL that can receive data from any form, website, or app. Leave the default settings (POST method, JSON response). Click the node to see the settings.
Pro Tip: Copy the Test URL — you will use it in Step 6 to test the workflow. The Production URL is used after you activate the workflow.
Select Google Sheets → Append Row. Connect your Google account when asked. Then:
{{$json.name}}, Email = {{$json.email}}, Message = {{$json.message}}Select Gmail → Send Email. Connect your Gmail account. Then fill in:
The webhook starts listening. Now open a new browser tab and send a test request. You can use this command in your terminal, or use any API testing tool:
No terminal? Use reqbin.com — a free online tool. Paste your test URL, set method to POST, add the JSON body, and click Send.
Click the Webhook node — you should see the test data. Click Google Sheets — you should see the row was added. Click Gmail — you should see the email was sent. Green checkmarks on every node means success.
Click the toggle in the top right corner. It switches from "Inactive" to "Active." Your workflow is now live. The Production URL is what you put in your actual website form.
Important: The Test URL only works when you click "Listen for test event." The Production URL works 24/7 once the workflow is active. Use the Production URL in your real website forms.
Your workflow works. Now make it smarter:
{{$now.format('yyyy-MM-dd HH:mm')}}Action Step: Pick one upgrade from this list and add it to your workflow right now. It should take less than 5 minutes.
| Problem | Fix |
|---|---|
| "No data" on the Webhook | Make sure you clicked "Listen for test event" BEFORE sending the test request. The webhook needs to be listening. |
| Google Sheets node fails | Check that your column headers in the spreadsheet match exactly what you mapped in n8n. Case matters. |
| Gmail node fails | Reconnect your Gmail credentials. Go to Settings → Credentials → Gmail and reconnect. |
| Workflow does not run after activation | Use the Production URL (not the Test URL) in your website form. The Test URL only works during testing. |
| Data shows up garbled | Make sure the request sends JSON with Content-Type: application/json. If using a form, set the encoding to JSON. |
Our recommendation: We use Claude AI for our own business and recommend it to everyone we work with. You can connect Claude to n8n workflows for AI-powered automation. Try Claude.
Join thousands of people who use CreatorHQ to automate their work.
Explore CreatorHQ