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.
Additional information
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.
Frequently asked questions
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
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.