Unified Datastore API: Read, Query, and Write Structured Data Across Spreadsheets, Databases, and Warehouses

June 30, 2026

Unified now supports a new category: Datastore.

If your product works with structured data, you eventually hit the same wall: every customer keeps their data somewhere different — a spreadsheet, an operational database, a cloud warehouse — and each platform's API behaves differently.

The Unified Datastore API gives you a single, standardized way to read, query, and write tabular data across spreadsheets, operational databases, and cloud data warehouses, in real time, without maintaining vendor-specific integrations.

This is built for teams working with structured data as a product surface:

• Internal tools and operational app backends built on connected spreadsheets and databases
• Analytics and reporting features that query warehouse data
• AI agents and automations that read, filter, and update records across platforms
• Data pipelines moving records between spreadsheets, operational stores, and warehouses

Read our docs →

Why a unified Datastore API

Data platforms provide similar concepts — databases, tables, records, queries — but their APIs rarely line up. Authentication differs, data models are structured differently, and query languages range from SQL to platform-specific filter syntax. Supporting "one more platform" becomes recurring engineering work.

Traditional approach

• Build separate integrations per platform
• Maintain multiple auth systems and permission scopes
• Learn each platform's query language and data model
• Rework integrations when APIs change
• Repeat pagination, rate limits, and error handling per provider

With Unified

• Integrate once through one API surface
• Work with normalized Database, Table, Record, and Query objects across providers
• Query with one model: structured filters and aggregations, or raw SQL where supported
• Get real-time data through pass-through API calls: no caching, no sync jobs

What you can build with Datastore

Common use cases:

• Operational app backends using connected spreadsheets and databases as lightweight data stores
• Analytics and reporting features that run filtered queries and aggregations against warehouse data
• Spreadsheet and no-code data sync across Google Sheets, Airtable, and other tabular platforms
• ETL and data pipelines that extract, transform, and load records with a consistent query model
• Cross-platform data migration: read tables and records from one platform, write them to another
• AI agents and automations that read structured data, filter records, and write results back

This is especially useful for AI-powered products, where agents need consistent, real-time access to structured data and the ability to write results back across the platforms a customer already uses.

Supported providers

Datastore integrations include:

• Airtable
• Google BigQuery
• Google Sheets
• MongoDB
• MongoDB Data API
• Notion
• Snowflake
• Supabase

Looking for another provider? Request an integration.

Standardized objects across data platforms

The Datastore API provides normalized objects across providers:

• Databases: workbooks, bases, schemas, and data lake connections, with metadata and access details
• Tables: sheets, tables, and views with column definitions, field types, and relationships
• Records: rows and entries with typed field values mapped to a common schema
• Queries: structured queries and raw SQL with filters, sorting, pagination, and aggregations

Field-level coverage varies by provider. Unified normalizes the shared concepts and exposes provider-specific fields through raw passthrough where you need them.

One query model across every platform

The Query object is what unifies a spreadsheet and a data warehouse under one interface. It runs in two modes:

Structured queries — portable across platforms. Filter with conditions (eq, gt, lt, like, in, contains, and more), combine them with AND/OR, sort, paginate, and aggregate with count, sum, avg, min, max, and group_by.

Raw SQL — where the platform supports it. Set query.sql and it executes directly against the source, for window functions, joins, and warehouse-specific capability.

Endpoint: POST /datastore/{connection_id}/query

The same Query object works whether the underlying platform is a spreadsheet, an operational database, or a cloud warehouse. The structured model maps to each platform's native query mechanism; raw SQL passes through where the warehouse accepts it. Records come back with typed field values — string, number, boolean, date, or selection — so you work with structured data rather than raw JSON.

Example build

A cross-platform internal tool inside your product:

1. Customer connects Google Sheets + Snowflake + Supabase
2. You list tables to discover the schema — field names, types, and relationships
3. You run a query for the records you need: a structured filter for portable logic, or raw SQL for warehouse-specific work
4. You read, display, and write back records with typed fields, using the same code regardless of the underlying platform

Real-time, read/write by design

The Datastore API supports both read and write operations across supported objects.

• Read databases, tables, records, and run queries
• Create, update, and remove records, tables, and databases
• Query with structured filters and aggregations, or raw SQL where supported

All requests are stateless and routed directly to the source API: no caching, no sync jobs, no stored records. Traffic is regionalized (US/EU/AU) to support data residency requirements. Learn more about our data security →

The Datastore API is one of 506 sources across 30 categories on Unified, and is available on all plans. Start your 30-day trial or book a demo.

Frequently asked questions

What is a unified datastore API?

A unified datastore API provides a single interface to access and manage structured data across multiple data platforms. Instead of integrating with each provider separately, developers use one API to read, query, and write databases, tables, and records with consistent schemas across spreadsheets, operational databases, and cloud warehouses.

Can you query data across spreadsheets and warehouses with one API?

Yes. A unified datastore API provides one query model that works across platforms: structured filters and aggregations for portable queries, and raw SQL where the platform supports it. The same query interface runs against a spreadsheet, an operational database, or a cloud warehouse.

Which data platforms does Unified support?

Unified's Datastore API supports Airtable, Google BigQuery, Google Sheets, MongoDB, MongoDB Data API, Notion, Snowflake, and Supabase, with additional platforms added based on customer demand.

Author

Written for Unified.to by Mallory Greene

About the author: Mallory Greene is a writer specializing in generative engine optimization (GEO) and content, through her practice Search Everywhere. She covers integration infrastructure and technical content across Unified.to's technical content library. Based in Toronto.