Make.com template · Google Form → HubSpot → Slack

Send Google Form leads to HubSpot and Slack automatically with Make.com

Every new Google Form response becomes one clean HubSpot contact and a Slack message in the right channel. A repeat submission updates the existing contact instead of creating a duplicate.

Get the template on Gumroad: $19 (opens in a new tab) One-time purchase · v1.1 · 30-day money-back guarantee Need more than one template? Get all 3 for $39 (opens Gumroad in a new tab): Lead Router, Polite Invoice Reminder and Quote Follow-Up Assistant.
What’s included
Lead Router flow: new form row, search HubSpot by email, create or update the contact, route hot leads to Slack
Trigger → exact-email lookup → create or update in HubSpot → route to Slack.

What it does

One Make scenario: 1 trigger and 16 other modules. You import it into your own Make account and connect your own apps. Nothing runs through Flowpaja.

Before it creates anything, it looks up the exact email in HubSpot, so a repeat submission updates the existing contact instead of adding a second one. Leads are processed on your Make schedule: a new form response waits for the next successful scheduled check of the linked Google Sheet.

Trigger

Watches your form sheet

Picks up new rows in the Google Sheet linked to your Google Form.

Dedupe

Exact-email lookup

Searches HubSpot for the exact email, then creates a new contact or updates the matching one.

Route

Hot leads to Slack

$10k+ budgets go to #sales-hot, everyone else to #leads. A blank budget shows as “not given”.

Alerts

No silent failures

If a HubSpot step fails, a short alert goes to #automation-alerts instead of the lead disappearing.

How the duplicate check works

Repeat submissions update the contact you already have. They don’t create a second one.

  1. Exact match only. The HubSpot search (module 4) uses the filter Email equal to the form’s email, limit 1. Similar names or partly matching emails are never picked.
  2. Decide. If a contact is found and its email equals the form email (any letter case), the scenario takes the Existing contact route and updates that contact. Otherwise it creates a new one.
  3. Same email twice within seconds? HubSpot’s search may not have indexed the first contact yet, so HubSpot blocks the second create as a duplicate. You get an alert in #automation-alerts and that row is skipped (the guide shows how to re-run it).

Changed in v1.1: earlier versions used a free-text search, where a contact that only partly matched could be updated by mistake. v1.1 switched to the exact email filter. The CHANGELOG includes steps for anyone who imported v1.0.

Exactly what’s in the download

One zip file (v1.1, updated 25 Sep 2026) with these nine files:

  • Flowpaja_Lead_Router_blueprint.jsonThe Make scenario blueprint. Account data removed: no connections, IDs or tokens. You connect your own apps.
  • Flowpaja_Lead_Router_Setup_Guide.pdf9-page setup guide: requirements and credits, import and reconnect steps, field mapping table, the budget-value gotcha, test plan, troubleshooting, ideas to extend.
  • google_form_questions.csvThe exact form questions, types, options and how each maps to HubSpot.
  • lead_intake_sheet_template.csvHeader row for the response sheet (columns A–G).
  • hubspot_custom_properties.csvThe 3 custom HubSpot contact properties to create.
  • test_leads_fictional.csv5 fictional test leads with the expected result for each.
  • BONUS_Form_to_CRM_Automation_Checklist.pdfBonus: our Form-to-CRM automation checklist (also available as a free download).
  • README.txtQuick start: what each file is for and where to begin.
  • CHANGELOG.txtWhat changed in each version.

Accounts you need

Four accounts are enough, and free plans can work (see the credit note under Honest limitations).

Free plan can work

Make.com

An account where you can create a scenario. The guide shows how to pick a schedule that fits the free plan’s monthly credits.

Any account

Google Forms + Sheets

A form with 6 questions, linked to a response sheet. The exact layout is in the guide and CSVs.

Free CRM works

HubSpot CRM

Permission to create 3 contact properties and connect apps. Uses standard search, create and update actions.

Free workspace works

Slack

Three channels: #sales-hot, #leads, #automation-alerts. Names are editable.

Setup overview

The guide walks through each step with module numbers and a mapping table.

Prepare your apps

Create the Google Form and response sheet, the 3 HubSpot properties and the 3 Slack channels.

Import and reconnect

In Make: Create a new scenario → ⋯ menu → Import Blueprint. Connect Google Sheets, HubSpot and Slack in each module.

Check budget values

Compare HubSpot’s internal dropdown values with the form answers and adjust one small formula if needed (about 2 minutes).

Test, then go live

Run the fictional test leads (the $10k+ test is required), set a schedule that fits your credits, switch it on.

Honest limitations

Worth knowing before you buy.

  • HubSpot dropdown values are portal-specific. Each dropdown option has a visible label and a hidden internal value. In our test portal, $10k+ was stored as 10k+$, so HubSpot rejected the label. The template’s default formula fits that portal only. Check your own values and adjust the formula, or hot leads will fail with a [400] error.
  • Choose a schedule that fits your credit budget. Every scheduled check uses 1 credit, even when there are no new rows, and each lead uses about 3 more. Over a 30-day month, hourly checks alone use about 720 credits; checks every two hours use about 360. Checking every 15 minutes around the clock (about 2,900 checks a month) is too much for the free plan’s 1,000 monthly credits. Your other scenarios use credits too, so the Free plan can fit a low-volume setup depending on your schedule and total account usage. Check your actual credit usage after testing; more frequent checks or more leads may require a paid Make plan. Current limits: make.com/pricing.
  • Tested with sample data. Built and tested end-to-end in a demo HubSpot portal and a demo Slack workspace with fictional leads only: new lead, hot lead, blank budget, repeat submission and a forced error. Test it in your own accounts before going live.
  • Column order matters. The blueprint maps sheet columns by position (B–G). Reordering questions or deleting rows in the response sheet breaks the mapping.
  • Failed leads are skipped, not retried. An error posts an alert and skips that row. You re-run it after fixing the cause (the guide explains how).
  • No owner assignment or round-robin. Leads are routed to Slack channels by budget, not to individual reps. To rotate new leads between reps, see Round-robin lead assignment in Make.
  • Built for Google Forms + HubSpot + Slack. Other form tools need a trigger swap and field remap. Other CRMs or Microsoft Teams mean replacing those modules yourself.
  • It’s a template, not a hosted service. It runs in your own Make, Google, HubSpot and Slack accounts. You are responsible for collecting personal data lawfully.

FAQ

Does it work on the Make free plan?
It can, if the scheduled checks, lead processing and your other scenarios stay within your account’s credit allowance and active scenario limit. The free plan currently includes 1,000 credits per month. Each scheduled check uses 1 credit (even when there are no new rows), and each lead uses about 3 more. Hourly checks alone use about 720 credits over 30 days, before any leads are processed. The guide shows example schedules; check your actual usage and the current Make plan limits when choosing a schedule.
Do I need a paid HubSpot plan?
No. It uses standard contact actions (search, create, update) and three custom contact properties, which you can create in HubSpot’s free CRM.
Can I use Typeform, Tally or another form instead of Google Forms?
Yes, with a small change: swap the first module for your form app’s trigger and remap the six fields. The guide explains which modules to update.
Can I use a different CRM (Pipedrive, etc.) or Microsoft Teams instead of Slack?
The logic (search, create/update, route, notify) carries over, but you’d replace those modules yourself. The template is built and tested for HubSpot + Slack.
Is my data sent to Flowpaja?
No. You import the blueprint into your own Make account and connect your own Google, HubSpot and Slack. The file contains no connections, IDs or tokens.
I’m new to Make. Is this too advanced?
The guide walks you through each step with module numbers and a mapping table. If you can create a Google Form and a HubSpot property, you can set this up.
Can I use it for client projects?
Yes. You can use it in your own accounts and to build automations for your own clients. Please don’t resell or publicly share the template files or the guide.
What if I get stuck?
Start with the troubleshooting page in the guide (the most common errors and their fixes). You can also reply to your Gumroad receipt with a question. If you’d rather have it built for you, see the done-for-you options. Errors in your other Make scenarios? See Make scenario fix / debugging on Fiverr, from $20.

Want to see how this kind of scenario is built first? Read our step-by-step guide: How to send Google Form leads to HubSpot and Slack with Make.com.

Not using HubSpot yet? The free Lead capture to Sheets + Slack template keeps one Google Sheets row and one Slack alert per new email.

Collecting leads with Typeform? The free Typeform hot-lead alert template saves each response to Google Sheets once per email and pings Slack only when the budget is 10,000 or more.

Get Lead Router for $19

Blueprint, 9-page setup guide, form and HubSpot templates, fictional test leads and a bonus checklist. Delivered as a download on Gumroad.

Need more than one? Get all 3 for $39 (opens Gumroad in a new tab) (Lead Router, Polite Invoice Reminder and Quote Follow-Up Assistant).

30-day money-back guarantee: if the template isn't right for you, reply to your Gumroad receipt email within 30 days of purchase for a full refund.

Make, HubSpot, Slack and Google are trademarks of their owners. Flowpaja is independent and not affiliated with or endorsed by them.

Put each lead in HubSpot and the right budget channel

Use the Google Form's linked sheet for scheduled intake, with an email lookup before creating or updating the HubSpot contact. Budget-based Slack routing keeps hot leads separate; this template does not assign owners in round-robin order.

Get Lead Router: $19 See how the form-to-HubSpot workflow is built

Want Sheets and Slack without HubSpot? Try free lead capture with email dedupe.

Downloadable files and setup guide. Connect and test in your own accounts; no call required. Full refund within 30 days by replying to your Gumroad receipt.