---
title: "Integrations - Googlesheets"
url: "https://docs.unified.to/integrations/googlesheets"
description: "Unified.to documentation"
---
##  Integration: Google Sheets ![Google Sheets](https://api.unified.to/docs/images/googlesheets.png)

[Back to integrations](/integrations)

#### Overview

Company website:

<https://workspace.google.com/products/sheets/>

Integration launch date:

July 31, 2025

API Categories:

[Datastore](/datastore/overview)[File Storage](/storage/overview)[Authentication](/auth/overview)[Passthrough](/passthrough/overview)

API Authorization:

 OAuth2 flow Service Account Email / Service Account Private Key / Subject

#### DATASTORE DATABASE

End-API object:

 spreadsheet

Unified API Methods:

[List](/datastore/database/List%5Fall%5Fdatabases)[Get](/datastore/database/Retrieve%5Fa%5Fdatabase)

List options:

limit

Readable fields:

[created\_at](/datastore/database/model)[description](/datastore/database/model)[id](/datastore/database/model)[name](/datastore/database/model)[updated\_at](/datastore/database/model)[web\_url](/datastore/database/model)

Writable fields:

[\-none-](/datastore/database/model)

#### DATASTORE TABLE

End-API object:

 sheet

Unified API Methods:

[List](/datastore/table/List%5Fall%5Ftables)[Get](/datastore/table/Retrieve%5Fa%5Ftable)

List options:

database\_idlimitoffset

 required filter 

Readable fields:

[database\_id](/datastore/table/model)[description](/datastore/table/model)[fields](/datastore/table/model)[id](/datastore/table/model)[name](/datastore/table/model)

Writable fields:

[\-none-](/datastore/table/model)

#### DATASTORE RECORD

End-API object:

 row

Unified API Methods:

[List](/datastore/record/List%5Fall%5Frecords)[Get](/datastore/record/Retrieve%5Fa%5Frecord)[Create](/datastore/record/Create%5Fa%5Frecord)[Update](/datastore/record/Update%5Fa%5Frecord)

List options:

database\_idtable\_idlimitoffset

 required filter 

Readable fields:

[database\_id](/datastore/record/model)[fields](/datastore/record/model)[id](/datastore/record/model)[row\_number](/datastore/record/model)[table\_id](/datastore/record/model)

Writable fields:

[fields](/datastore/record/model)[table\_id](/datastore/record/model)[database\_id](/datastore/record/model)

 required fields 

#### DATASTORE QUERY

End-API object:

 query

Unified API Methods:

[Create](/datastore/query/Create%5Fa%5Fquery)

List options:

\-none-

Readable fields:

[database\_id](/datastore/query/model)[query](/datastore/query/model)[response](/datastore/query/model)[table\_id](/datastore/query/model)

Writable fields:

[database\_id](/datastore/query/model)[query](/datastore/query/model)[table\_id](/datastore/query/model)

 required fields 

#### STORAGE FILE

End-API object:

 file root drive

Unified API Methods:

[List](/storage/file/List%5Fall%5Ffiles)[Get](/storage/file/Retrieve%5Fa%5Ffile)[Create](/storage/file/Create%5Fa%5Ffile)[Update](/storage/file/Update%5Fa%5Ffile)[Remove](/storage/file/Remove%5Fa%5Ffile)

Webhooks:

 Virtual

List options:

expandfulltextlimitoffsetorderparent\_idquerysort\_by\_created\_atsort\_by\_namesort\_by\_updated\_attypeupdated\_gte

Readable fields:

[created\_at](/storage/file/model)[description](/storage/file/model)[download\_url](/storage/file/model)[hash](/storage/file/model)[id](/storage/file/model)[mime\_type](/storage/file/model)[name](/storage/file/model)[parent\_id](/storage/file/model)[permissions](/storage/file/model)[size](/storage/file/model)[tags](/storage/file/model)[type](/storage/file/model)[updated\_at](/storage/file/model)[user\_id](/storage/file/model)[version](/storage/file/model)[web\_url](/storage/file/model)

Slow fields:

[name](/storage/file/model)[tags](/storage/file/model)

Writable fields:

[data](/storage/file/model)[download\_url](/storage/file/model)[mime\_type](/storage/file/model)[name](/storage/file/model)[parent\_id](/storage/file/model)[type](/storage/file/model)

#### PASSTHROUGH

Unified API Methods:

[POST](/passthrough/overview)[GET](/passthrough/overview)[PUT](/passthrough/overview)[DELETE](/passthrough/overview)

List options:

\-none-

Readable fields:

[\-none-](/passthrough/undefined/model)

Writable fields:

[\-none-](/passthrough/undefined/model)