Do I need to know how to code to use this?

No. You tell it which part of your database holds new signups and who should get the email, and it handles the counting, comparison, and sending for you every weekday morning.

What if my signups aren't stored in a collection called 'users'?

The collection name and the date field that marks when a record was created are both settings you can change, so it works with whatever naming your project already uses.

Can it include new orders too, not just signups?

Yes. Turning on the optional orders summary lets the digest read a second collection and mention new orders alongside your signup numbers.

How does it decide whether growth is up or down?

It compares the last 24 hours against your recent daily average over the past week or two, then describes the direction and rough size of the change in plain language.

When does the email arrive, and can I change that?

By default it lands every weekday at 8am. You can adjust the time and the days it runs, including adding weekends if you want a daily digest.

New signup growth digest, emailed every weekday morning

Every 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 it does

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 you’ll need

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

Use cases

Daily Digests
AI Reports
Email Automation

Weekday growth digest of new signups, emailed to your team

Integrations

Type

Categories

What it does

What you’ll need

How to customize it

Use cases

FAQs

Related prompts