Short answer: Use a free Google Apps Script that adds every website form entry to a Google Sheet as a new row, with the time it arrived. No Google Forms, no plugin. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make a Leads tab; Paste the script; Deploy it as a web app; Add the form to your website; Send a test.
How to set it up
- Make a Leads tab. Make a tab called Leads. Row one holds the column names: Timestamp, Name, Email and Message. Apart from Timestamp, each name has to match a field name on your form exactly.
- Paste the script. Open Extensions, then Apps Script, and paste in the code below. It's one short function: when your form sends data, it reads your header row and adds a line in the same order, with the time it arrived.
- Deploy it as a web app. Click Deploy, then New deployment, and choose Web app. Run it as yourself and set access to Anyone, so your website can reach it. Authorize it once, then copy the web app address.
- Add the form to your website. Paste the form code below into your website page and put the web app address in place of PASTE_WEB_APP_URL.
- Send a test. Fill in the form and send it. The row appears in your Leads tab. To collect another field, add it to the form and add a column with the same name to the sheet.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs and form.html). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a free Google Apps Script that adds every website form entry to a Google Sheet as a new row, with the time it arrived. No Google Forms, no plugin.
How do I set it up?
In 5 steps: 1. Make a Leads tab; 2. Paste the script; 3. Deploy it as a web app; 4. Add the form to your website; 5. Send a test. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs and form.html). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/