Task. Leads come from the website, a marketplace and social media, get lost in different places, and nobody knows how many arrived yesterday.
Solution. Each lead from a website, Tilda, Google Forms or n8n becomes a row in the sheet, and a Telegram message with a link to it arrives at once. If Telegram is down the lead still stays in the sheet: three retries, then a line in the Log sheet. Bot spam (a hidden honeypot field) and leads without a phone number are filtered out. Phone numbers are normalised, so overnight repeats move to a Duplicates sheet with the original row number, and nothing is deleted. Every morning an e-mail report shows yesterday's leads by source.
A Flow Lab menu sits in the sheet, settings live on a sheet with no code, keys are kept in protected script properties, and 10 automated tests cover the code. Fictional kitchen workshop, all contacts invented. First step: the sheet and Telegram alerts in two days, from $80.
