Get an instant phone alert for every Google Form lead

说明与用途

使用 ntfy 和 Apps Script 为每个 Google 表单线索即时接收电话提醒，确保及时跟进，无需额外费用。

问题

Business owners miss timely follow‑ups because Google Form responses are only checked when remembered, leading to lost leads.

结果

Within 10 minutes, a free, server‑less solution delivers instant phone alerts for every new Google Form lead, improving response time without subscription costs.

工作流

• Install ntfy app and subscribe to a secret topic
• Link the Google Form to a Google Sheet
• Create an Apps Script with an installable "On form submit" trigger
• Configure the script with the topic, fallback email, and field names
• Deploy the script; each submission posts to ntfy and sends an email if needed

证据

Speed matters. Calling a lead back within 5 minutes instead of an hour makes a huge difference in whether you reach them at all.

来源

A push notification with the actual lead details fixes all three.

来源