How to Track Which Automations Actually Make You Money

Most businesses add automations because they’re “supposed” to. New zaps, n8n flows, email sequences, follow-up reminders… and after a few months nobody can answer a basic question:

“Which of these actually makes us money?”

1. Decide what “money-making automation” means for you

Not every useful automation has to touch money directly. But you do need a clear definition so you don’t over-credit everything.

For most small businesses, a money-making automation is:

• Anything that directly creates a sales conversation (call, booked meeting, quote request).
• Anything that directly creates a transaction (order, invoice, paid invoice).
• Anything that reliably pushes deals forward in your pipeline (e.g., follow-up sequences that move “stuck” leads to next stage).

A nurture email that “keeps people warm” might be nice. But an automation that sends a “reply to this email to book a call” and actually results in booked calls? That’s what we’ll track as revenue-generating.

2. Set up a basic tracking stack (without overbuilding a CRM)

You don’t need a giant CRM project for this. Keep it boring and reliable:

1. One capture point for interest.
   Example: a “Book a strategy call” form, WhatsApp link, or “Request a quote” form.
2. One place where revenue is recorded.
   Example: Stripe, QuickBooks, a simple Google Sheet with “Invoice # / Amount / Client”.
3. One place where you list automations.
   This can be a simple table in Notion, Airtable, or even a Google Sheet called “Automation Map”.

In that Automation Map, create columns like:

• Name – “IG DM → Lead capture form → CRM”
• Trigger channel – Instagram, website, email, Google Ads
• Primary CTA – Book call, request quote, buy, download
• Tracking tag – a simple code like auto_ig_dm
• Where it writes the lead – Sheet name, CRM pipeline, etc.

3. Tag your automations so they can be measured

For an automation to be trackable, it needs to leave a fingerprint. Here are three simple ways to do that:

Option A – Hidden form fields or URL params

If your automation sends people to a form or landing page, add a query parameter like:

?source=auto_ig_dm

Then, on your form, store that value in a hidden field called lead_source. Every lead created from that automation will carry its source.

Option B – Specific pipeline stage

If you use a CRM or spreadsheet pipeline, make your automation move the lead into a specific column or status like “From IG DM automation”.

Later, you can filter deals by that status and see: “Deals created from this automation = X, won = Y, revenue = Z.”

Option C – Unique coupon or offer code

For e-commerce or service payments, give each automation its own code: AUTOIG10, AUTOEMAIL15… and log which automation owns which code.

Then, each time that code is used, you know which automation generated the sale.

4. Connect automations to revenue in a simple sheet

Now that leads and sales have a fingerprint (tags, stages, or codes), you can connect them in a very simple way:

1. Export your paid invoices or Stripe payments to a sheet once a week.
2. Make sure there is a column for lead_source or offer_code.
3. Use a simple PIVOT TABLE or group-by in the sheet: “Sum of revenue by lead_source / offer_code.”

You’ll immediately see something like:

• auto_ig_dm – 7 deals / $4,200
• auto_site_chat – 3 deals / $1,150
• auto_newsletter_ps – 0 deals / $0

5. Run a weekly 15-minute Automation ROI check

Once a week, block 15 minutes and do a quick review:

1. Open your Automation Map. Make sure new flows are listed.
2. Refresh your revenue sheet / pivot.
3. Highlight:
   • Top 1–2 automations by revenue.
   • Automations with leads but no closed revenue.
   • Automations with zero leads and zero revenue.

Then make three micro-decisions:

• Scale – increase traffic to the automations that are clearly working.
• Fix – tweak messaging or steps for automations that produce leads but no revenue.
• Kill – archive automations that have had enough time and are doing nothing.

6. Examples of money-making automations to copy

Example 1 – Daily content → leads → booked calls

Let’s say you post daily on Instagram or LinkedIn. A money-making automation could be:

• New comment or DM with certain keywords → send a pre-written reply.
• Reply includes one simple CTA: “Answer 3 questions here so I can see if I can help.”
• Form tagged with auto_daily_content.
• Form submission → adds lead to a “Content leads” pipeline + sends booking link.

Every deal that closes from that pipeline is now easily traceable back to your daily content automation.

Example 2 – SEO traffic → email → automated nurture → call

If you’re building an SEO system (like this n8n + Supabase content setup), a money-making automation could be:

• Visitor lands on an SEO article.
• They opt in to get a “checklist” related to that exact topic.
• Automation sends the checklist + a short 3-email sequence with one CTA: “Book a call.”
• Booking page is tagged auto_seo_checklist.

Now you can see how much revenue came from SEO-sourced checklist downloads, not just “SEO traffic looked good in Google Search Console.”

7. When to scale, when to kill

Give each new automation a clear test window — for example: 30–45 days with a reasonable amount of traffic.

After that:

• Scale if:
  • You can clearly tie at least a few deals or invoices to it.
  • Leads from that source don’t suck (good show-up rate / close rate).
• Fix if:
  • Lots of clicks or form fills, but low call show-up or low close rate.
  • The offer or messaging feels off compared to what closes in manual conversations.
• Kill if:
  • No leads, no calls, no revenue, and other channels clearly work better.

Bringing it all together

You don’t need a complex data warehouse to see which automations make you money. You need:

• A list of your automations with simple tags.
• One or two ways those tags show up on leads and payments.
• A weekly 15-minute review to scale, fix, or kill.

If you stick to that, your automation stack stops being a messy collection of “cool workflows” and becomes a set of profit levers.