How to collect website leads straight into your Google Sheet

What are the steps?

1. 1

   Add your page

   In ownyourclick, open Pages and click Add page. Enter the address of the page that has your form, give it a name you'll recognise (it also becomes the end of your link), then click Create page.

2. 2

   Copy the tracking tag

   Your page opens on its Settings tab. Scroll to Add the tag to your landing page, pick how your site is built and click Copy. Always copy it from this page: the ID in it belongs to this page. The tag ends in data-form="form", so there's no setting to switch on: it captures any form on the page when someone submits it, with every field.

3. 3

   Paste it into your page's <head>

   Paste the tag where your site builder lets you add code to the head. On WordPress, use a header code plugin such as WPCode. On Webflow or Framer, open the site settings, then Custom code. In plain HTML, paste it inside <head>. Save and publish. You don't need to change your form. Every builder's exact path is in the tracking code docs.

4. 4

   Check the setup status

   Open your live page in a normal browser window and stay a few seconds. Back on Settings, Setup status re-checks every 10 seconds: "Script detected on your page", then "First visit recorded".

5. 5

   Send a test lead

   Fill in your form the way a visitor would and submit it. Within seconds the last check ticks: "First lead received". Open the Leads tab to see the lead with where it came from, its time on the page and its hot %. Your first test lead usually scores high, often 100%: the score compares leads on the same page, and so far it's the only one. You can set your own target instead under Configure Sheets → How Hot % is scored.

6. 6

   Connect Google Sheets

   Open the Configure Sheets tab and click Connect Google and create my sheet. Choose the Google account the sheet should live in. On the consent screen, tick the box that lets ownyourclick create files in your Google Drive, then continue. ownyourclick can only open the sheets it creates for you, never your other files.

7. 7

   Open your sheet

   Back in ownyourclick, click Create my sheet. The leads your page already has, your test lead included, are copied in straight away, then click Open sheet to see them with their name, email, phone and hot %. (The video uses Re-sync for this; it's no longer needed, but it's there on Configure Sheets if a lead is ever missing.) From then on, every new lead from your form goes straight into the sheet.