Get a text message when someone fills in your website form

Short answer: Use a free Google Apps Script that adds each website form entry to a Google Sheet and sends you a text message with the details, through your own Twilio account, so you can call the lead back in minutes. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make a Leads tab; Paste the script; Add your Twilio details; Deploy it as a web app; Add the form to your site.

How to set it up

1. Make a Leads tab. Make a tab called Leads. Row one holds the column names: Timestamp, Name, Phone and Message. Apart from Timestamp, each name has to match a field name on your form exactly.
2. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save.
3. Add your Twilio details. In the Apps Script editor, open Project Settings and add four Script properties: TWILIO_SID and TWILIO_TOKEN from your Twilio console, TWILIO_FROM (your Twilio number, like +15551234567) and NOTIFY_TO, the cell phone the alerts go to. Run testText once from the editor to check a text arrives.
4. Deploy it as a web app. Click Deploy, then New deployment, and choose Web app. Set Execute as to Me and Who has access to Anyone, then copy the web app URL that ends in /exec.
5. Add the form to your site. Paste the form code from our email into your website page and replace PASTE_WEB_APP_URL with your URL. Each entry lands as a new row and you get a text like New lead: Name: Ann | Phone: 555 0100 | Message: Quote please.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• You need a Twilio account and a Twilio phone number. Texting your own phone is the simplest case.
• Texts are cut at 600 characters, so long messages are shortened in the text but kept in full in the sheet.

Questions

What does this script do?

It is a free Google Apps Script that adds each website form entry to a Google Sheet and sends you a text message with the details, through your own Twilio account, so you can call the lead back in minutes.

How do I set it up?

In 5 steps: 1. Make a Leads tab; 2. Paste the script; 3. Add your Twilio details; 4. Deploy it as a web app; 5. Add the form to your site. 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.