Send yourself a WhatsApp-free daily lead digest from Google Sheets

说明与用途

通过 Google Sheets 自动发送每日未处理线索的电子邮件摘要，帮助避免错失潜在客户。

问题

Leads from Google Forms can be missed when instant alerts are ignored, leading to lost opportunities.

结果

A free, 10‑minute setup delivers a daily digest email of unhandled leads, reducing missed follow‑ups.

工作流

• Add a "Status" column to the responses sheet.
• Paste the provided Apps Script into the sheet’s script editor.
• Set the column names for name and phone to match the form questions.
• Create a time‑driven trigger to run the script at 08:00.
• Test the script manually and verify the email output.
• Mark a lead as "called" and confirm it no longer appears in the digest.

证据

Add a "Status" column in your responses sheet (new / called / closed)

来源

A time-driven Apps Script trigger that runs at 08:00

来源

One digest email: new leads from the last 24 h + anything still new after 24 h, each with a tel: link

来源