Enter app

Send your contact form to a Google Sheet

Bright Smile Dental already has a “Get in touch” form on its website. It emails nobody reliably and nothing keeps a record. In about ten minutes it will write every enquiry into a spreadsheet the practice owns.

Steps
6
Plan
Free
Output
Google Sheet row
Mode
Your own form
The scenario
A two-chair dental practice has a contact form on brightsmile.example/contact. Reception wants every enquiry in one list they can sort, filter and tick off — not scattered across an inbox.
What you end up with
A Google Sheet in the practice's own Drive that gains one row per enquiry, with the date it arrived and the date it reached Google.
You need
  • The Google account the practice wants to own the spreadsheet
  • Access to edit the page the form is published on
  • The exact domain the form is published at — brightsmile.example, not a preview address
  1. Account › Google

    Sign in, then connect Google separately

    Signing in with Google tells Webtzm who you are. It does not give Webtzm access to your Sheets or your Drive. Those are a second, separate decision, and you make it here.

    Open Account › Google and connect Sheets and Drive. Leave Gmail sending alone for now — this tutorial sends no email.

    The Account → Google view: the connected Google account with its Sheets, Drive and Gmail send permissions, Sheets and Drive and Gmail send each listed as Connected with its own Reconnect and Disconnect actions, beside the workspace's plan and this month's accepted submissions. Open full size
    Each Google service is listed with its own state, so you can connect only what the form you are building actually needs.
    Use one account, deliberately

    Sign in with the account that should own the spreadsheet. If you connect a different Google account here, the Sheet lands in that account's Drive, and moving it later is your job, not Webtzm's.

    Skipped this and gone straight to New connection instead? That works too — a workspace with nothing connected yet offers Connect Google on the empty Connections home and in the Webtzm helper, so you can grant access without leaving the page.

  2. Connections › New connection

    Make a connection

    In the console, select New connection in the top bar, or press N. Webtzm makes the connection and its managed Google Sheet in one step, and the new card appears first among your connections with its name ready to type. Type something you will recognise in Drive six months from now: Clinic contact form beats Form 1.

    Open the card. The panel beside the cards shows its Setup, one section at a time — Basics, Questions, Add to your site, What it can do, Google output, Submission handling and Advanced — and each saves as you change it. A form of your own needs only two of them: the website it lives on, and its address.

    Text fields only

    A form of your own carries text, choice and other non-file fields. A file input on the page is skipped rather than half-delivered. File uploads need fields designed in the Builder — see the job application tutorial.

  3. Setup › Basics

    Name the website it lives on

    1. Under Websites, type the hostname only — brightsmile.example — and select Allow website. No https://, no path, no port, no wildcard.
    2. Leave Email me for each submission, in Submission handling, off for now. It sends a short Webtzm alert to reception on every enquiry — free on every plan — but it is not required to finish setup.
    3. Leave Send visitors to empty too. Without a page there, a visitor who submits sees Webtzm's own confirmation page, which is enough while you are only testing.
    The Basics section of the Clinic contact form's Setup: its name, brightsmile.example listed under Websites with a remove control, an empty website field with Allow website, the switch that holds submissions from a website not on the list, and its status with Pause. Open full size
    The website becomes a chip once allowed. Webtzm protects exactly https://brightsmile.example — every other website is refused, or held for you to allow while Hold submissions from a website not on the list is on.
    Subdomains are separate

    brightsmile.example does not allow www.brightsmile.example. If the published page answers on both, add both. A connection accepts up to 25 websites.

  4. Setup › Advanced › Form address and code

    Point your form at its address

    Open Advanced. Its first group, Form address and code, holds the form address with Copy beside it, Get the form code, and Send test.

    The Form address and code group in a connection's Advanced settings: the form address with a Copy button, a Get the form code button and a Send test link. Open full size
    The address is the whole of the connection as far as your page is concerned. Send test opens the console-hosted test page.

    Before you touch your own site, select Send test. It opens the console-hosted test page, submits through the real path, and the row appears in Analytics and the managed Sheet — so you know the wiring works before anything is public. This is the same three-step quickstart in miniature: sign in, make the connection and paste its address, then send a test and see the row.

    Get the form code opens the setup guide, the one screen worth keeping open while you edit your site. It leads with the form's own HTML, which already carries the Webtzm script, then the form address for a form of your own, a four-step checklist, and a live indicator that flips the moment a real submission arrives.

    The setup guide for the Clinic contact form: Form ready, Copy form HTML as the one primary button with Open the form HTML beside it, the form address for a form of your own with its Copy address button, Open Sheet and Copy prompt for AI, a Waiting for a new submission status, the four setup steps, and a Send a test submission link. Open full size
    Reopen it at any time from the connection's Setup, under Advanced. It offers Send a test submission too, the same test page.

    Copy the form address, then change three things in your existing markup: the action, the method, and any field that has no name.

    Your existing contact form, after three edits — replace the address with the one your Setup shows
    <form action="https://webtzm.com/submit/YOUR_FORM_ID" method="post">
      <label for="name">Your name</label>
      <input id="name" name="name" type="text" required>
    
      <label for="email">Email</label>
      <input id="email" name="email" type="email" required>
    
      <label for="message">How can we help?</label>
      <textarea id="message" name="message" rows="4"></textarea>
    
      <button type="submit">Send</button>
    </form>
    Every field needs a name

    Webtzm reads the name attribute, not the id and not the label. A field with no name is not submitted by the browser at all, so it cannot arrive, and nothing on the page will tell you. Check every one before you publish.

  5. Your own site

    Publish, then send one safe test

    Publish the page, open it at its real address, and submit one enquiry using invented values. Do not use a real patient's details, and never put card numbers, passwords or anything confidential through a form field.

    A plain form POST like this one has no Webtzm helper on the page, so the browser navigates to a Webtzm confirmation page rather than showing a message inside the form. Both outcomes are readable, and both tell the visitor what happened.

    The Webtzm outcome page after a plain form POST, showing a heading, what Webtzm confirmed, what to do next, and the submission route diagram. Open full size
    The outcome page after a plain POST. This capture is the rejection wording, which is the version worth recognising: it names what was checked and what to do about it, and the route diagram shows exactly how far the submission got.
    Prefer staying on your own page?

    The setup guide offers a small, safe JavaScript handler under Keep visitors on your page that requests JSON and shows the result inside the form instead of navigating away. Copy it from the guide rather than writing your own — it handles the states you will not think of.

  6. Analytics

    Confirm it reached Google

    Acceptance and delivery are two different events, and Webtzm keeps them apart on purpose. The visitor is told the submission was accepted and queued. You are told, a moment later, that it reached Google.

    The Submissions section of Analytics filtered to the Clinic contact form and to Delivered, showing its three newest submissions, each with a Delivered status and a Sheet output. Open full size
    Delivered is the one you are waiting for. The other states are covered in running it after launch.
    You are done when three things agree

    The visitor saw a confirmation, Analytics shows Delivered, and the Sheet holds the test row. If the first two agree and the third does not, you are looking at the wrong spreadsheet — open it from the connection's own Open Sheet.

What the Sheet looks like

Webtzm created one spreadsheet, named after the form, in the Drive of the account you connected. It has one working tab, and every accepted enquiry is one row.

Header row of the delivery tab
ColumnWritten byWhat it holds
webtzm_idWebtzmThe protected reference for this row. An Update or Delete form finds the row again by this value. Always column A.
name, email, messageYour formOne column per submitted field, named after the field's name attribute.
accepted_atWebtzmWhen Webtzm accepted the submission.
synced_atWebtzmWhen Webtzm last wrote the row: when it arrived, and again after each change to it.

You may reorder any column except webtzm_id, hide the ones you would rather not look at, and add columns of your own. Every column after the first is matched by its header name on each write, and Webtzm only ever adds columns — it never removes them.

Renaming a header makes a new column

Rename message to Enquiry and the next delivery treats message as missing and adds it back beside your renamed one. Change the display with a second row, a filter view, or the clean view — not by editing the header.

Where to go next

Something missing or wrong on this page? Tell support.