---
title: "Datastore API"
url: "https://docs.unified.to/datastore/overview"
description: "API reference for Datastore API. Launch multiple pre-built Datastore integrations today with zero maintenance — all through a single API."
generated_at: "2026-06-11T22:38:24.155Z"
---
# 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?](#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](#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](#common-use-cases)

### [Spreadsheet & No-Code Data Sync](#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](#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](#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](#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](#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](#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.

## [Data Model](#data-model)

DATASTORE data model

SVG fallback viewer

[Open SVG](/images/models/UnifiedDatastore.svg)

Loading diagram...

 Share [](http://www.linkedin.com/sharing/share-offsite/?mini=true&url=%2Fdatastore%2Foverview&title=Datastore%20API&summary= "Share to LinkedIn")[](http://www.twitter.com/share?url=%2Fdatastore%2Foverview&text=Datastore%20API&summary= "Share to Twitter")[](http://www.reddit.com/submit?url=%2Fdatastore%2Foverview&title=Datastore%20API&summary= "Share to Reddit")[](https://news.ycombinator.com/submitlink?u=%2Fdatastore%2Foverview&t=Datastore%20API&summary= "Share to Hacker News")