ofapisv1
integration

OnlyFans + Airtable

Airtable makes a clean CRM for creators and agencies, and you can keep it in sync with live OnlyFans data using code Airtable already runs for you. Both the Scripting extension and the Run a script automation action expose a standard fetch, so ofapis — a plain Bearer-auth REST API — drops straight in. No plugin, no middle server.

The mechanism: Run script action (or Scripting block)

In an automation, add a Run script action. Airtable's sandbox has global fetch; put your key in the action's Input variables (mapped from a secure field) rather than pasting it inline.

const key = input.config().ofapisKey;
const res = await fetch(
  'https://api.ofapis.com/api/public/v1/accounts/42/subscribers?limit=100',
  { headers: { Authorization: `Bearer ${key}` } }
);
const { data } = await res.json();

const table = base.getTable('Fans');
for (const f of data) {
  await table.createRecordAsync({
    'Username': f.username,
    'Fan ID': String(f.id),
    'Subscribed': f.subscribedAt,
    'Total Spent': f.totalSpent
  });
}

For a one-off backfill, run the same code in the Scripting extension where output.table() lets you preview results before writing. Note Airtable's automation scripts have a ~30s runtime cap, so paginate in batches and let the schedule catch the rest.

Worked example: hourly fan sync with upsert

Trigger the automation on a schedule (At a scheduled time → every hour). The script pulls subscribers, then before creating a record it calls table.selectRecordsAsync() and matches on Fan ID — updating spend and last-active on existing rows, creating rows for new fans. That gives you a self-maintaining fan table you can group by segment and filter for win-back views. ofapis keeps the session alive server-side, so the hourly run never has to re-authenticate.

Three recipes to build

Every route and payload is documented in the OpenAPI spec, and the same fetch pattern reaches all of them.

FAQ

Is there an Airtable integration or plugin for OnlyFans?

No official plugin exists, and none is needed. Airtable's Run script action and Scripting extension both include fetch, which calls every ofapis endpoint with a Bearer token.

How do I keep my API key out of the base?

Pass it through the automation action's Input variables (mapped from a restricted field or hard-coded only in the action config), not in a visible cell. Rotate keys anytime from the dashboard.

How do I avoid the script timeout on large syncs?

Automation scripts cap around 30 seconds, so fetch one page (e.g. 100 records) per run and rely on the hourly schedule, or run a full backfill from the Scripting extension which has more headroom.

Do failed syncs cost credits?

No. ofapis bills one credit per successful call only; an expired-session or upstream error returns non-2xx and is free. See pricing.

Where do I get a token?

Create one free. The Free plan includes 250 credits per month, enough to wire up and test a full base.

Related: Google Sheets · Make.com · all integrations

Related guides

All guides
Start free — 250 credits, no card
Generate a token and make your first call in minutes.
Get started