Weekday growth digest of new signups, emailed to your team
Every weekday morning, get a short email that totals yesterday's new signups, compares them to your recent average, and flags anything notable.
Firebase
GmailProductOperationsDaily DigestsAI ReportsEmail AutomationEvery weekday at 8am, generate a short growth digest of my new signups from Firebase Firestore and email it to the founding team. Firestore is the data source and Gmail is the delivery channel.
Read the data with Firebase's Run Firestore Query. Pull the documents created in the last 24 hours from my signups collection (default: users), using a range filter on the created timestamp field (default: createdAt) and ordering by that field. Make both the collection name and the created timestamp field configurable at the top of the workflow so I can point this at whatever my project actually uses. Optionally run a second Run Firestore Query the same way against an orders collection if I want new orders included in the digest.
To compare against the recent daily average, also query the same collection over a trailing window (for example the last 7 to 14 days), count the new records per day, and compute the average number of new signups per day. Use that as the baseline the digest compares the last 24 hours against.
Then turn the raw records into a plain-language growth digest. Total the new signups from the last 24 hours, compare that total to the recent daily average, and describe the direction and rough size of the change. Call out anything notable: an unusually high or low day, a growth streak, a spike in new orders, or a quiet stretch. Write it so a non-technical founder can skim it in a few seconds.
Keep the email skimmable. Put the headline number at the very top (new signups in the last 24 hours and how that compares to the recent average), then a couple of supporting bullets underneath (for example the running daily average, any notable change, and new orders if that option is enabled). Keep the whole thing short.
Send the finished digest to the founding team using Gmail's Send a Message, with a clear subject line such as 'Growth digest: X new signups yesterday'. Let me configure the recipient list.
Assumption to note: this reads new signups (and optionally orders) as Firestore documents that carry a created timestamp field. The catalog has no operation for listing Firebase Auth accounts, so this digest reads a Firestore collection rather than Firebase Auth. If my collection or timestamp field is named differently, those are the two configurable inputs at the top of the workflow.
What does this prompt do?
- Counts the new signups added to your database in the last 24 hours and puts that headline number at the top of the email.
- Compares that total against your recent daily average so you can see at a glance whether growth is up or down.
- Calls out anything notable in plain language, like a standout day, a slow stretch, or a jump in new orders.
- Emails the whole digest to your founding team as a short, skimmable morning read.
What do I need to use this?
- A Firebase project where your signups (and optionally orders) are stored as records with a created date.
- A Gmail account to send the digest from.
- The email addresses of the people who should receive it.
How can I customize it?
- Point it at a different collection and tell it which field marks when a record was created.
- Change the send time or the days it runs, for example to include weekends.
- Update the recipient list, or turn on an orders summary alongside signups.
FAQs
Do I need to know how to code to use this?
What if my signups aren't stored in a collection called 'users'?
Can it include new orders too, not just signups?
How does it decide whether growth is up or down?
When does the email arrive, and can I change that?
Related templates
Every couple of hours we find the chats your team never answered, email those visitors a real reply, and hand the sensitive ones to a support lead.
One board showing every party you are onboarding, which documents are still missing or expiring, and a one click chase email for exactly what is outstanding.
Every hour, new email attachments get sorted by document type and vendor, saved under clear names, and logged in a spreadsheet index.
Pick an open role and see which past applicants deserve a second look, with an assistant that ranks the best fits and drafts personal outreach.
See every voyage on your books ranked by money at risk, open the full statement of facts, and let an agent draft the demurrage claim for review.
Look up any Kajabi member by email or name and see every offer, purchase, and payment in one profile, then grant, revoke, or swap access from the same row.
Start every weekday knowing your growth number.
Let this workflow total your new signups, compare them to your average, and drop a skimmable digest in your team's inbox before you finish your morning coffee.