Google Sheets API

Sync spreadsheet data into a queryable database on a schedule

Read rows from any Google Sheet using the Sheets API v4. Turn ad-hoc spreadsheets into structured, versioned data you can query with SQL. Track changes over time instead of losing them to overwrites.

Free. 300 read requests/min per project, 60/min per user, no daily cap.

Google Sheetsdocs →

How it works with Loony

Describe it.
Deploy it.
Query it.

Managed database.

Your Google Sheets data lives in its own Postgres instance. Zero config. Data accumulates over time.

Scheduled syncs.

Cron jobs run on Loony infra. Every minute on free. Your data stays fresh without you thinking about it.

REST + MCP endpoints.

Query from your agent, your dashboard, or connect BI tools directly. Full OpenAPI spec included.

TerminalSchema

$ "Pull the 'Sales Pipeline' Google Sheet every 2 days. Cast the revenue column to numeric and the close date to a proper date. Build a materialized view grouped by sales rep with total pipeline value and average deal size."

✓ Schema validated
✓ Database provisioned
✓ Scripts deployed
✓ Schedules registered

Done.

# Your data is now at:
REST  /data/v1/google-sheets/query
MCP   /mcp/v1/google-sheets/mcp
SQL   psql $DATABASE_URL

What you get

Google Sheets gives you a flat grid of strings with no history, no types, and no API for downstream consumers. Loony pulls your sheet into a typed Postgres table on a schedule, preserves snapshots over time, and exposes it as a REST or MCP endpoint. Your agents and dashboards query structured SQL instead of parsing CSV.

mv_pipeline_by_rep
  rep_name        text        -- sales rep full name
  deal_count      integer     -- number of open deals
  total_pipeline  numeric     -- sum of revenue column
  avg_deal_size   numeric     -- average deal value in USD
  avg_days_open   integer     -- average days since created
  next_close_date date        -- earliest expected close
  last_synced_at  timestamptz -- when Loony last pulled the sheet

Even better together

Join spreadsheet data with Notion databases for a unified project tracker. Pair with Linear issues to reconcile planning sheets against actual tickets. Combine with HubSpot to enrich CRM contacts from spreadsheet data.