Blog/Tutorials
Tutorials

Building an OnlyFans Growth Stack: n8n, Baserow and the OnlyFans API

Build an automated OnlyFans agency stack with n8n and Baserow.

T
The Only API Team·Mar 2, 2026·5 min read
Building an OnlyFans Growth Stack: n8n, Baserow and the OnlyFans API

The most successful OnlyFans agencies do not run their operations from spreadsheets. They build integrated growth stacks — automated systems that connect their OnlyFans data to databases, dashboards, and workflow engines. With The Only API running at 99.9% uptime across 200+ endpoints for both OnlyFans and Fansly, the infrastructure exists to build sophisticated agency operations without writing complex code.

This guide walks through building a complete growth stack using three tools: n8n for automation, Baserow for database management, and The Only API for OnlyFans data.

What Is a Growth Stack for OnlyFans Agencies?

A growth stack is the collection of interconnected tools that power your agency's operations. Instead of manually checking earnings, sending messages, and compiling reports, a growth stack automates these workflows and centralizes data.

A well-designed OnlyFans growth stack handles:

  • Data collection: Automatically pulling earnings, subscriber counts, message stats, and content performance from every managed account
  • Data storage: Centralizing all data in a structured database for analysis and reporting
  • Automation: Triggering actions based on data events (revenue milestones, subscriber churn signals, new tips and messages delivered by webhook)
  • Reporting: Generating dashboards and reports for internal use and creator-facing updates

The Architecture: n8n + Baserow + The Only API

Here is how the three components fit together:

The Only API (Data Layer)

  • Connects to OnlyFans accounts via API
  • Provides 200+ endpoints for earnings, subscribers, messaging, fans, campaigns, webhooks, and automations
  • Serves as the single source of truth for all OnlyFans data

Baserow (Database Layer)

  • Open-source alternative to Airtable
  • Stores structured data: creator profiles, earnings history, subscriber metrics, campaign results
  • Provides a visual interface for browsing and editing data
  • Supports API access for automated reads and writes

n8n (Automation Layer)

  • Open-source workflow automation platform
  • Connects The Only API to Baserow (and any other tool)
  • Triggers workflows based on schedules, webhooks, or data conditions
  • Ships native nodes for common tools (Slack, Google Sheets, Postgres). The Only API connects through n8n's generic HTTP Request node — there is no dedicated community node, but we publish turn-key recipes you can import

Step-by-Step: Connect API, Pipe Data to Baserow, Trigger Workflows

Step 1: Set Up The Only API

Sign up at theonlyapi.com and connect your first OnlyFans account. You will receive an API key that provides access to all 200+ endpoints.

Step 2: Set Up Baserow Tables

Create the following tables in Baserow:

Creators Table:

  • Creator Name (text)
  • OnlyFans Username (text)
  • Account ID (text)
  • Status (dropdown: active, paused, offboarding)
  • Start Date (date)

Daily Earnings Table:

  • Creator (link to Creators)
  • Date (date)
  • Subscriptions Revenue (number)
  • Tips Revenue (number)
  • PPV Revenue (number)
  • Total Revenue (number)
  • New Subscribers (number)
  • Churned Subscribers (number)

Campaign Results Table:

  • Creator (link to Creators)
  • Campaign Name (text)
  • Send Date (date)
  • Messages Sent (number)
  • Opens (number)
  • Purchases (number)
  • Revenue Generated (number)

Step 3: Build n8n Workflows

Workflow 1: Daily Earnings Sync

  1. 1.Schedule trigger: runs daily at 2:00 AM
  2. 2.For each creator in Baserow "Creators" table:
  • Call The Only API earnings endpoint for yesterday's date
  • Parse subscription, tip, and PPV revenue
  • Write a new row to "Daily Earnings" table
  1. 1.Send Slack notification with daily summary

Workflow 2: Subscriber Churn Alert

  1. 1.Schedule trigger: runs every 6 hours
  2. 2.For each creator:
  • Call The Only API subscriber endpoint
  • Compare current count to previous count in Baserow
  • If subscriber count dropped by more than 5% in 24 hours, trigger alert
  1. 1.Send alert to team with creator name and churn percentage

Workflow 3: Real-Time Tip and Message Alerts

Polling every hour wastes calls and adds latency. Use webhooks instead:

  1. 1.Register a webhook once with POST /api/crm/{crm_id}/webhooks, pointed at an n8n Webhook node
  2. 2.n8n receives a delivery the moment the event fires — no schedule trigger needed
  3. 3.For each delivery:
  • Write the tip or message to the relevant Baserow table
  • Post a Slack alert to the creator's channel
  1. 1.If a delivery looks wrong, replay a sample payload with POST /api/crm/{crm_id}/webhooks/{id}/test and inspect the log at GET /api/crm/{crm_id}/webhooks/{id}/deliveries

A note on content posting: The Only API has no first-party content scheduling or posting endpoint. Content posting is only reachable through the generic OnlyFans passthrough at /api/crm/{crm_id}/api2/v2/{path}, which forwards a raw platform request — it is not a scheduling feature, and you own the retry and timing logic.

Example Workflows: Revenue Alerts, Churn Detection, Fan Re-Engagement

Beyond the basics, here are advanced workflows that top agencies run:

Revenue milestone notifications. When a creator crosses a revenue threshold ($10K, $50K, $100K), automatically send a congratulations message and update their tier in your CRM.

Fan re-engagement campaigns. Identify subscribers who have not engaged in 7+ days using API data, then trigger an automated re-engagement mass message with special PPV content.

Automated weekly reports. Every Monday morning, generate a formatted report for each creator showing their weekly performance: revenue, subscriber growth, top-performing content, and campaign results.

New subscriber welcome flows. When a new subscriber joins, trigger a welcome DM sequence over 3 days: Day 1 welcome, Day 2 content teaser, Day 3 PPV offer.

Why This Stack Beats Spreadsheets

The difference between a spreadsheet-based agency and a growth stack agency:

Manual (Spreadsheets)Automated (Growth Stack)
Check earnings manually for each account dailyEarnings sync automatically every night
Notice churn when it is too lateReal-time churn alerts before subscribers leave
Send mass messages manuallyCampaigns trigger automatically based on segments
Weekly reports take hours to compileReports generate and send automatically
Data is always outdatedData is always current

How The Only API Helps

The Only API is the data foundation of this entire stack:

  • 200+ endpoints provide every data point you need: earnings, subscribers, messages, fans, campaigns, payouts
  • Turn-key n8n recipes — importable workflow templates built on n8n's HTTP Request node, no custom code required
  • Real-time webhooks (GET/POST /api/crm/{crm_id}/webhooks) and an SSE event stream (GET /api/crm/{crm_id}/events/stream) so workflows react instantly instead of polling
  • Unlimited API calls on paid slots — no credits and no per-call fees. The free plan includes 1,000 calls/month.
  • Real-time data ensures your dashboards and automations work with current information
  • From $0/mo — start building your stack on the free plan

Build your growth stack today. Start Building Free