StackedThink

Blog

SaaS Health Dashboard Automation Recipe (Make.com + Airtable + Softr)

05 April 2025

Aggregate Stripe, GitHub, and Slack metrics into a unified dashboard using Make.com, Airtable, and Softr — automate your SaaS monitoring without custom code.

SaaS Health Dashboard Automation Recipe (Make.com + Airtable + Softr)

For indie hackers, SaaS founders, and ops teams who want a single pane of glass for critical business metrics — without hiring a developer.

This Make.com automation scenario pulls key data from Stripe (revenue), GitHub (deployments), and Slack (team comms) into a unified health dashboard built with Airtable and Softr. It gives you instant visibility into business, product, and team pulse — all without writing a single line of backend code.

It’s the kind of lightweight, high-impact tool that ai-automation-roi-calculator would reward.

Why This Matters

Most SaaS founders cobble together dashboards using screenshots or half-baked spreadsheets. This scenario solves the "unified IT monitoring" gap we’ve seen in our own experiments — and it's fully reusable.

Like our cloud-metrics-aggregator-make-recipe, this one is built for speed and reuse. It’s a no-code ops stack that actually works.

Automation Scenario Overview

Trigger → Steps → Outcome

  1. Trigger: Daily schedule (via Make.com scheduler)
  2. Steps:
    • Fetch Stripe revenue for the last 24 hours
    • Fetch latest GitHub deployment status
    • Fetch Slack channel activity (e.g., #ops or #releases)
    • Normalize and combine data
    • Push to Airtable base
    • Softr pulls live from Airtable to render dashboard
  3. Outcome: A live health dashboard showing revenue, deployment status, and team comms — updated daily.

Make.com Scenario JSON Export

{
  "name": "SaaS Health Dashboard Aggregator",
  "modules": [
    {
      "id": 1,
      "type": "scheduler",
      "settings": {
        "cron": "0 9 * * *",
        "timezone": "UTC"
      }
    },
    {
      "id": 2,
      "type": "stripe.getTransactions",
      "settings": {
        "currency": "USD",
        "created": {
          "gte": "{{yesterday}}",
          "lt": "{{today}}"
        }
      }
    },
    {
      "id": 3,
      "type": "github.getDeployments",
      "settings": {
        "owner": "yourcompany",
        "repo": "yourrepo",
        "limit": 1
      }
    },
    {
      "id": 4,
      "type": "slack.searchMessages",
      "settings": {
        "query": "in:#ops status deploy",
        "sort": "timestamp",
        "count": 5
      }
    },
    {
      "id": 5,
      "type": "mapper",
      "settings": {
        "mapping": {
          "stripeRevenue": "{{2.transactions|sum(amount)}}",
          "lastDeployStatus": "{{3.deployments.0.state}}",
          "slackMessage": "{{4.messages.0.text}}",
          "timestamp": "{{now}}"
        }
      }
    },
    {
      "id": 6,
      "type": "airtable.createRecord",
      "settings": {
        "baseId": "app_health_dashboard",
        "tableId": "tbl_daily_metrics",
        "fields": {
          "Revenue": "{{5.stripeRevenue}}",
          "Deploy Status": "{{5.lastDeployStatus}}",
          "Slack Summary": "{{5.slackMessage}}",
          "Date": "{{5.timestamp}}"
        }
      }
    }
  ],
  "edges": [
    {"from": 1, "to": 2},
    {"from": 1, "to": 3},
    {"from": 1, "to": 4},
    {"from": 2, "to": 5},
    {"from": 3, "to": 5},
    {"from": 4, "to": 5},
    {"from": 5, "to": 6}
  ]
}

Step-by-Step Setup Guide

Prerequisites

  • A Make.com account (Pro plan recommended)
  • A Stripe account with API access
  • A GitHub repo with deployments enabled
  • A Slack workspace with a channel for ops comms
  • An Airtable base with a table named tbl_daily_metrics and fields:
    • Revenue (Number)
    • Deploy Status (Single line text)
    • Slack Summary (Long text)
    • Date (Date)
  • A Softr app connected to the Airtable base

Steps

  1. Import the scenario JSON into Make.com
  2. Connect your apps
    • Stripe → Add your live key
    • GitHub → Connect via OAuth
    • Slack → Add bot token with read access to messages
  3. Map your own identifiers
    • Replace yourcompany/yourrepo with your GitHub repo
    • Adjust Slack query to match your ops channel
  4. Test the scenario manually
    • Run a manual execution to verify data flows
  5. Set up Softr dashboard
    • Create a new app in Softr
    • Connect to your Airtable base
    • Add a List block to display records
    • Customize columns: Revenue, Deploy Status, Slack Summary
  6. Schedule daily runs
    • Scenario will run daily at 9am UTC

Troubleshooting FAQ

Q: Why is Stripe returning 0 revenue?

A: Ensure your Stripe account is live, not in test mode. Check the date filters — Make uses UTC by default.

Q: GitHub deployment data is blank.

A: Confirm deployments are enabled in your repo settings. Use GET /repos/{owner}/{repo}/deployments in GitHub API to verify.

Q: Slack messages aren’t showing.

A: Your Slack app needs the search:read scope. Also, ensure the channel is public or the bot is invited.

Q: Softr dashboard isn’t updating.

A: Softr syncs with Airtable every 15 minutes. Try refreshing manually or check your Softr connection.

Monetisation & Next Steps

This automation recipe is a perfect lead magnet for indie makers building ops tools or data-integration-roi-calculator products. Use it to:

👉 Download the full Make.com recipe JSON and start building your own SaaS health dashboard today.

StackedThink is an experimentation playground for AI-driven online businesses. We ship fast, measure what works, and spin out winners into standalone products. Want to build your own? Start with ai-content-roi-calculator.

← Back to blog