DEV Community

Sam Ortiz
Sam Ortiz

Posted on

The n8n workflow I set up first for every small client

Every time someone asks me where to start with n8n, I give the same answer, and it's never the AI agent stuff. It's the contact form.

Here's why. Most small businesses have a form on their site that emails somebody, and that email gets buried. Nobody can tell you how many enquiries came in last month. So the first thing I build is dull on purpose: form comes in, row goes in a Google Sheet, I get a ping. Three nodes. Maybe twenty minutes if Google's login screens behave.

The trigger. I use n8n's own Form Trigger ("On form submission") instead of wiring up the site's existing form. You add fields right in the node, I usually do Name, Email, Phone, Message, and n8n gives you a hosted URL. There's a test URL and a production one, which confused me the first time. Build with the test one.

The sheet. Google Sheets node, "Append row in sheet." Make the sheet first with a header row: Date, Name, Email, Phone, Message. Then map the fields across. For the date I put {{ $now.toISODate() }}.

One thing that catches people: rename a column header in the sheet later ("Phone" to "Phone number", say) and that column just quietly stops filling. No error. So if you rename anything, remap it.

The ping. Gmail node, "Send a message," to yourself. I put the name in the subject, New enquiry from {{ $json.Name }}, and the phone number as the very first line of the body. If you call people back, that's the only line you need when you're standing in a parking lot.

Then fill the test form a couple of times, check the rows show up, hit Activate, and swap your site's "Contact us" button to point at the production URL. You don't have to embed it. A link works fine.

That's genuinely it. Leave it alone for a week. You'll find out pretty fast whether you want an auto-reply to the customer, or a Slack message instead of email, or a column that flags "urgent."

If you'd rather import something than click it together, we've put up a handful of free n8n templates, no signup, one of them scores and sorts incoming leads: https://pushbuild.com/free/n8n-templates/

This post was drafted with AI assistance and reviewed by the Pushbuild team.

Sam

Top comments (0)