Make Webhooks to Google Sheets: Capture Leads Automatically
Make webhooks can send each new enquiry into Google Sheets without copying it by hand. Start with two modules: Custom webhook and Add a Row. Use this when your form or app can send webhook events and you want control over what reaches your spreadsheet.
Mike Says earns commission if you sign up through our Make affiliate link and make a qualifying purchase, at no extra cost to you.
Affiliate link · I may earn commission from a qualifying purchase at no extra cost to you.
Concept artwork, not a screenshot of Make or Google Sheets.
Published 1 October 2026. Based on Make's official documentation, checked on this date. This is a documented build guide, not a claim of hands-on testing.
Is this worth building?
Yes, if you repeatedly copy enquiries into a sheet or need to route the same submission to several apps. Skip Make if your form already writes the right information directly to Google Sheets and that is all you need. Another service would add maintenance without solving a problem.
What you will build
A form or business app sends a submission to a private Make webhook address. Make reads that submission and adds a row to your chosen spreadsheet. You then use the sheet to track the next action.
For example, a small service business could keep a list of quote requests with the customer's name, email, requested service and submission ID. The result is a working enquiry list. It does not contact customers, qualify leads or replace a customer-management system by itself.
Our suggested starting columns are Submission ID, Received at, Name, Email, Service and Status. Keep the first version narrow. A dependable six-column list is more useful than a large workflow you cannot explain or repair.
What you need before starting
- A Make account and a Google account with permission to edit your target sheet.
- A source form or app that can send outgoing webhooks. Check its plan restrictions first.
- A dummy enquiry you can submit without using a real customer's information.
- A decision about which fields are required and who will check new enquiries.
If Make already offers an instant trigger for your form app, check that option before using a custom webhook. The dedicated connection may be easier to configure. This guide covers the custom route for services where you need to supply a receiving URL.
1. Prepare the spreadsheet
Create a spreadsheet called Enquiry tracker and a tab called Leads. Put the six suggested headings in the first row, one heading per column. Avoid merged cells in the input area.
Give each column a single purpose. Keep the customer's name separate from their email address. Use a submission ID from the source app if it provides one. That ID will help you investigate repeated events later.
Do not connect an existing business-critical sheet for your first test. Use a test copy until you have checked how every field lands.
2. Create the receiving webhook
In a new Make scenario, add Webhooks → Custom webhook. Create a webhook, name it clearly and save it. Copy the address Make provides into your source app's outgoing webhook setting. Use the actual address, including its region, rather than a URL copied from a tutorial.
Send one dummy submission while Make is listening. Its values should then become available for mapping. If a field is missing, use Detect new values and send another complete sample. Recognising a sample is different from validating future submissions: define a data structure in the webhook settings if you need Make to reject an invalid shape.
Make also supports optional API-key authentication through the x-make-apikey header. Use it if your sending service supports custom headers. Keep the webhook address and key out of public screenshots and front-end code.
Official custom-webhook setup and authentication reference.
Affiliate link · I may earn commission from a qualifying purchase at no extra cost to you.
3. Add Google Sheets and map the fields
Add Google Sheets → Add a Row after the webhook. Create a Google connection, select the account that can edit your sheet, then choose the spreadsheet and Leads tab. Indicate that the table has headers where the module asks for this.
Map the incoming values into their matching columns. Mapping means selecting the value from the webhook output, rather than typing an example customer's details into a box.
| Sheet column | Suggested value | What to check |
|---|---|---|
| Submission ID | The source's event or submission ID | Stable when the source retries |
| Received at | The submitted timestamp, if supplied | Time zone is understood |
| Name | The submitted name | No email address in this column |
| The submitted email | Complete address | |
| Service | The selected enquiry category | Readable description |
| Status | Fixed text: New | Consistent spelling |
These are suggested fields, not guaranteed names from your form provider. Inspect its actual sample output. If the source gives no timestamp, you can record the processing time instead, but label the column accordingly.
Official Google Sheets connection reference and available Google Sheets actions.
4. Test the result before switching it on
Run the complete scenario with a new dummy submission. Open the sheet and compare every cell against what you sent. A green module does not tell you that the name and service landed in the correct columns.
- Send a normal enquiry with all fields completed.
- Send an enquiry with an optional field left empty.
- Use a name containing an apostrophe and a service description containing punctuation.
- Send a second distinct enquiry and check that it creates a separate row.
- Replay the same submission ID to see the duplicate behaviour.
This two-module version appends rows. It does not check for an existing submission ID. Expect a repeated event to create another row until you add duplicate handling.
5. Activate it and check a fresh submission
Save the scenario and activate it with immediate processing if that is the behaviour you want. Submit a fresh test from the source after activation. Confirm the row appears without pressing Run once again.
Make normally processes instant webhook requests as they arrive. Its default accepted response means the request reached the queue; it is not proof that the spreadsheet write succeeded. Check the scenario history and the sheet when investigating a missing lead. You can add a Webhook response module later if the sending service needs a custom reply.
What does it cost?
Make's Free plan currently includes 1,000 credits per month. The published minimum interval for scheduled runs is 15 minutes; an instant webhook is a different trigger type. Your form provider may charge separately for outgoing webhooks.
A simple run with one custom webhook and one standard Add a Row action typically uses two credits. Illustration: 100 successful submissions × two credits is around 200 credits. This assumes one row per event and no additional modules, retries or other scenarios. Treat it as a planning estimate, not a promised allowance.
Make's Academy states that the custom webhook uses one credit when triggered. Additional searches, notifications and other actions change the total. Test realistic examples and inspect usage before choosing a paid plan. See our Make pricing guide and see Make plans. Affiliate link · I may earn commission from a qualifying purchase at no extra cost to you.
Before using it for real enquiries
Decide how to handle duplicates. A source can resend an event after a timeout. A small workflow can search for a submission ID before adding a row, but simultaneous runs can still race each other. For busy or important processes, use a store with enforced unique IDs or get help designing reliable duplicate handling.
Choose what happens when data is incomplete. Do not quietly lose an enquiry because one optional field is missing. Make required fields explicit, keep an error route or review list, and test that path separately.
Keep customer text as text. Where available, use RAW input mode for user-supplied fields so spreadsheet software does not interpret an enquiry beginning with an equals sign as a formula. Do not build executable expressions from submitted text.
Assign an owner. Someone should review failures and check that new leads receive a response. Automation moves information; it does not make the follow-up happen unless you build and supervise that part too.
Common problems
| Problem | First check |
|---|---|
| No event reaches Make | Check the source's delivery log and the complete webhook URL. |
| The webhook receives data but no row appears | Open the scenario history and inspect the Sheets module error. |
| Every row has the same customer name | Replace typed sample text with the mapped incoming value. |
| Only some columns fill | Compare the actual incoming field names with your mappings. |
| Repeated rows appear | Compare submission IDs and investigate source retries. |
| Tests work but later submissions do not | Check activation, connections, errors and remaining credits. |
Who should use this approach?
This is a sensible starting point for freelancers and small teams that want a simple enquiry list, already use Sheets and can maintain a modest automation. It also gives you a clear base for adding an internal notification after the row is saved.
Skip it for a form that already has a suitable direct Sheets connection. Choose a proper customer-management system when you need permissions, ownership, audit history and reliable sales follow-up across a larger team. Sheets is a flexible list, not a substitute for every business system.
Try one small workflow first
Build the two-module version with dummy data. Check the result and credit use before adding extra steps or choosing a paid plan.
Try Make free →Affiliate link. Mike Says may earn commission on a qualifying purchase.
Frequently asked questions
Do I need to write code?
The Make side uses its visual editor. Your sending app must support outgoing webhooks. A custom website may need development work to send the event safely.
If a custom website is more than you need, our guide to building a small business website covers a hosted builder such as Create, with hosting and SSL included, and a contact page for these enquiries.
Will it automatically prevent duplicates?
No. The basic version adds a row for each processed event. Add and test a separate duplicate-handling design before relying on one row per enquiry.
Can I add an email alert?
Yes, you can extend the workflow with a supported email action. Start with an internal alert, test it separately and include that action in your credit estimate.
Sources and related guides
Technical references: Make webhook processing, custom webhook configuration, Google Sheets connection, Google Sheets module options, Make Academy webhook explanation and Make plans. Affiliate link · I may earn commission from a qualifying purchase at no extra cost to you.
For the next step, read our Make review, Make automation ideas or Gmail-to-Google-Sheets guide. If you still need the site itself, see how to build a small business website.