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

Description and use

An automated daily email digest of unhandled leads from Google Sheets, sent via email, helps prevent missed opportunities.

Problem

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

Outcome

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

Workflow

• 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.

Evidence

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

Source

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

Source

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

Source