← Back to Marketplace

Google Sheets

Bearer

Read and write spreadsheets. The most accessible database in the world.

https://sheets.googleapis.com
OVERVIEW

The Google Sheets API (v4) lets you read, write, and format spreadsheet data. Use it as a lightweight database, config store, or data pipeline destination. The API supports reading ranges, appending rows, batch updates, and creating new spreadsheets.

Authentication uses OAuth2 access tokens or API keys (for public sheets). For server-to-server access, use a service account. The API uses A1 notation for cell ranges (e.g., Sheet1!A1:D10).

GET YOUR API KEY

Authentication setup

  1. Go to console.cloud.google.com
  2. Create a project or select an existing one
  3. Enable the Google Sheets API
  4. Go to Credentials → Create credentials
  5. For server apps: create a Service Account, download JSON key
  6. Share the spreadsheet with the service account email
Token format ya29.… (OAuth2 access token)
Auth type bearer
QUICK CONNECT

Create a connection in one request.

CONNECT GOOGLE SHEETS
POST /connections Authorization: Bearer $TOKEN Content-Type: application/json { "name": "Google Sheets", "base_url": "https://sheets.googleapis.com", "auth_type": "bearer", "auth_config": {"token": "ya29.access_token_here"} } → {"id": "cn_xxxxxxxx", "name": "Google Sheets"}
KEY ENDPOINTS

What you can call via proxy.

MethodPathDescription
GET /v4/spreadsheets/{id} Get spreadsheet metadata (sheets, named ranges)
GET /v4/spreadsheets/{id}/values/{range} Read cell values from a range
PUT /v4/spreadsheets/{id}/values/{range} Write values to a range
POST /v4/spreadsheets/{id}/values/{range}:append Append rows to a sheet
POST /v4/spreadsheets Create a new spreadsheet
POST /v4/spreadsheets/{id}:batchUpdate Batch update cells and formatting
EXAMPLE

Read Spreadsheet Range

PROXY CALL
GET /proxy/cn_xxxxxxxx/v4/spreadsheets/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/values/Sheet1!A1:C3 Authorization: Bearer $TOKEN { "range": "Sheet1!A1:C3", "majorDimension": "ROWS", "values": [ ["Name", "Email", "Plan"], ["Alice", "alice@example.com", "Pro"], ["Bob", "bob@example.com", "Free"] ] }
USE CASES

What people build with Google Sheets.

Data Pipelines

Write analytics results, crawl data, or API responses to spreadsheets for sharing.

Config Management

Use a spreadsheet as a configuration store that non-developers can edit.

Report Generation

Generate weekly/monthly reports by writing structured data to formatted sheets.

Form Responses

Read Google Forms responses and process them programmatically.

← Back to Marketplace Developer Guide →
# Google Sheets > Read and write spreadsheets. The most accessible database in the world. ## Overview The Google Sheets API (v4) lets you read, write, and format spreadsheet data. Use it as a lightweight database, config store, or data pipeline destination. The API supports reading ranges, appending rows, batch updates, and creating new spreadsheets. Authentication uses OAuth2 access tokens or API keys (for public sheets). For server-to-server access, use a service account. The API uses A1 notation for cell ranges (e.g., <code>Sheet1!A1:D10</code>). - **Base URL:** https://sheets.googleapis.com - **Auth type:** bearer - **Token format:** ya29.… (OAuth2 access token) ## Get Your API Key 1. Go to console.cloud.google.com 2. Create a project or select an existing one 3. Enable the Google Sheets API 4. Go to Credentials → Create credentials 5. For server apps: create a Service Account, download JSON key 6. Share the spreadsheet with the service account email ## Quick Connect bashcurl -X POST https://api.liteio.dev/connections \ -H "Authorization: Bearer $TOKEN" \ -H "Content-Type: application/json" \ -d '{ "name": "Google Sheets", "base_url": "https://sheets.googleapis.com", "auth_type": "bearer", "auth_config": {"token": "ya29.access_token_here"} }' ## Key Endpoints MethodPathDescription GET/v4/spreadsheets/{id}Get spreadsheet metadata (sheets, named ranges) GET/v4/spreadsheets/{id}/values/{range}Read cell values from a range PUT/v4/spreadsheets/{id}/values/{range}Write values to a range POST/v4/spreadsheets/{id}/values/{range}:appendAppend rows to a sheet POST/v4/spreadsheetsCreate a new spreadsheet POST/v4/spreadsheets/{id}:batchUpdateBatch update cells and formatting ## Example: Read Spreadsheet Range bashcurl https://api.liteio.dev/proxy/cn_xxx/v4/spreadsheets/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/values/Sheet1!A1:C3 \ -H "Authorization: Bearer $TOKEN" ## Use Cases - **Data Pipelines**: Write analytics results, crawl data, or API responses to spreadsheets for sharing. - **Config Management**: Use a spreadsheet as a configuration store that non-developers can edit. - **Report Generation**: Generate weekly/monthly reports by writing structured data to formatted sheets. - **Form Responses**: Read Google Forms responses and process them programmatically. ## Links - Back to Marketplace - Developer Guide - Get API Key