LightningSyncLightningSync

How LightningSync Works

From Facebook, Google, TikTok, and Square to your Supabase database in three simple steps. No code required. No servers to manage.

1Connect Your Accounts

Secure Connections in Seconds

Connect your ad accounts and payment processors with a single click. We use official OAuth flows for Facebook, Google, TikTok, and Square; no passwords stored, no API keys to manage.

  • Official Partner APIs
  • Read-only access to performance data
  • AES-256 encrypted token storage
  • Automatic token refresh (never expires)

Read-Only Access

Minimal permissions requested

ads_read: View ad performance
MERCHANT_PROFILE_READ: View Square data
https://www.googleapis.com/auth/adwords
2Configure Your Database

Point to Your Supabase

Connect Supabase via Supabase's official OAuth flow, choose a project, and we'll automatically create the necessary tables in your public schema. No keys to paste.

  • Works with any Supabase project
  • Also supports AWS RDS, Google Cloud SQL, self-hosted PostgreSQL
  • Tables created automatically
  • No manual schema setup required

Database Connection

Connect + choose a project

Connect Supabase
ls-demo (ref_********)
3Automatic Sync

Data Flows Automatically

Choose your sync frequency: hourly or daily. We handle the rest. fetching data, normalizing schemas, handling rate limits, and managing API versions.

  • Hourly or daily sync frequency
  • Historical backfill (up to 365 days)
  • Automatic retries on failure
  • Rate limit handling built-in

Sync Status

Real-time monitoring

Last sync2 hours ago
Next syncIn 22 hours
StatusActive

What Data Gets Synced

Clean, normalized PostgreSQL tables ready for analytics

-- Ad Platforms (Facebook, Google, TikTok)
facebook_ads_campaigns       -- Campaign metadata & settings
google_ads_campaigns         -- Performance metrics
tiktok_ads_groups            -- Ad group targeting

-- Payment Platforms (Square)
square_orders                -- Individual transaction details
square_items                 -- Product catalog & inventory
square_customers             -- Customer profiles & history

Under the Hood

Security First

  • AES-256 encryption at rest
  • TLS 1.3 in transit
  • Token refresh via secure OAuth
  • No password storage ever

Reliability

  • Automatic retries with exponential backoff
  • Rate limit-aware scheduling
  • API version migration handled
  • 99% uptime SLA

Developer Friendly

  • Standard PostgreSQL tables
  • Works with any SQL client
  • Compatible with Supabase RLS
  • Edge Functions integration

Ready to get started?

Set up your first sync in under 5 minutes. Free tier available.

Start Free TrialView Pricing

Start in minutes. Cancel anytime.