Datastore API

The Unified Datastore API enables developers and product managers to access structured data from databases, data lakes, and spreadsheets through a single, standardized interface. Retrieve databases, tables, records, and run queries against Google Sheets, Airtable, Snowflake, and other data platforms - all with one API.

What is the Unified Datastore API?

Data platforms like Google Sheets, Airtable, and Snowflake each have unique APIs with different authentication methods, data models, and query languages. The Unified Datastore API normalizes these differences, allowing you to build once and read and write tabular data across spreadsheets, operational databases, and cloud data warehouses without maintaining separate integrations for each provider.

Datastore Data Objects

The Datastore API provides access to the following standardized objects:

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

Common Use Cases

Spreadsheet & No-Code Data Sync

Build tools that sync data between Google Sheets, Airtable, and other tabular platforms. Read and write records across spreadsheets and bases without building custom integrations for each product.

Analytics & Reporting

Create dashboards and reports by querying data from Snowflake and other data platforms. Run filtered queries, aggregations, and counts to power BI tools and internal reporting.

ETL & Data Pipelines

Develop data pipelines that extract records from spreadsheets and operational stores, transform them with a consistent query model, and load them into warehouses or downstream systems.

Operational App Backends

Use connected spreadsheets and databases as lightweight backends for internal tools and workflows. List tables, create and update records, and query data through one API regardless of the underlying platform.

Cross-Platform Data Migration

Migrate data between platforms by reading tables and records from one integration and writing them to another. Move bases, sheets, and table schemas with normalized field types and relationships.

AI & Automation Workflows

Build AI agents and automations that read structured data, filter records, and update rows across Google Sheets, Airtable, Snowflake, and other supported integrations using a single query and record model.