Google Sheets

aid: google-sheets
name: Google Sheets
description: API for reading, writing, and formatting data in Google Sheets.
image: https://www.google.com/images/branding/googlelogo/2x/googlelogo_color_272x92dp.png
url: https://developers.google.com/sheets/api
created: '2024-01-01'
modified: '2026-05-19'
specificationVersion: '0.19'
type: Index
apis:
  - name: Google Sheets API v4
    description: The Google Sheets API lets you read, write, and format Google Sheets data.
    image: https://www.gstatic.com/images/branding/product/2x/sheets_2020q4_48dp.png
    humanURL: https://developers.google.com/sheets/api
    baseURL: https://sheets.googleapis.com/v4
    properties:
      - type: Documentation
        url: https://developers.google.com/sheets/api/reference/rest
      - type: OpenAPI
        url: openapi/google-sheets-openapi.yml
      - type: Authentication
        url: https://developers.google.com/sheets/api/guides/authorizing
      - type: Quickstart
        url: https://developers.google.com/sheets/api/quickstart/python
      - type: GettingStarted
        url: https://developers.google.com/workspace/sheets/api/guides/concepts
      - type: APIReference
        url: https://developers.google.com/workspace/sheets/api/reference/rest
      - type: SDK
        url: https://developers.google.com/workspace/sheets/api/guides/libraries
      - type: ChangeLog
        url: https://developers.google.com/workspace/sheets/release-notes
      - type: CodeExamples
        url: https://developers.google.com/workspace/sheets/api/samples
      - type: RateLimits
        url: https://developers.google.com/workspace/sheets/api/limits
      - type: Errors
        url: https://developers.google.com/workspace/sheets/api/troubleshoot-api-errors
      - type: JSONSchema
        url: json-schema/google-sheets-spreadsheet-schema.json
      - type: JSONLD
        url: json-ld/google-sheets-context.jsonld
    contact:
      - type: Support
        url: https://support.google.com/developers/
      - type: StackOverflow
        url: https://stackoverflow.com/questions/tagged/google-sheets-api
    tags:
      - Collaboration
      - Data
      - Google
      - Productivity
      - Spreadsheets
  - name: Google Apps Script Spreadsheet Service
    description: >-
      The built-in Google Apps Script Spreadsheet Service allows creation, access, and modification of Google Sheets
      files directly from Apps Script with performance bundling and numerous classes for formatting, data sources,
      structure, and content.
    image: https://www.gstatic.com/images/branding/product/2x/apps_script_48dp.png
    humanURL: https://developers.google.com/apps-script/reference/spreadsheet
    properties:
      - type: Documentation
        url: https://developers.google.com/apps-script/reference/spreadsheet
      - type: GettingStarted
        url: https://developers.google.com/apps-script
      - type: APIReference
        url: https://developers.google.com/apps-script/reference
      - type: ReleaseNotes
        url: https://developers.google.com/apps-script/release-notes
    contact:
      - type: StackOverflow
        url: https://stackoverflow.com/questions/tagged/google-apps-script
    tags:
      - Apps Script
      - Automation
      - Google
      - Scripting
      - Spreadsheets
maintainers:
  - name: Kin Lane
    email: [email protected]
    url: https://apievangelist.com
common:
  - type: PostmanWorkspace
    url: https://www.postman.com/kinlaneapi/google-sheets/overview
  - type: ArazzoWorkflows
    url: arazzo/
    workflows:
      - url: arazzo/google-sheets-append-and-format-header-workflow.yml
        name: Google Sheets Append Rows and Format the Header
        summary: Create a spreadsheet, append rows including a header, then bold the header row via batchUpdate.
      - url: arazzo/google-sheets-archive-and-clear-multiple-ranges-workflow.yml
        name: Google Sheets Archive and Clear Multiple Ranges
        summary: Read several ranges as an archive, clear them all in one batch, then re-read to confirm they are empty.
      - url: arazzo/google-sheets-bulk-load-multiple-ranges-workflow.yml
        name: Google Sheets Bulk Load Multiple Ranges
        summary: Create a spreadsheet, write several ranges in one batch, then read them all back in one batch.
      - url: arazzo/google-sheets-copy-sheet-between-spreadsheets-workflow.yml
        name: Google Sheets Copy a Sheet Between Spreadsheets
        summary: >-
          Read a source spreadsheet, copy one of its sheets into a destination spreadsheet, then confirm the
          destination.
      - url: arazzo/google-sheets-create-and-seed-spreadsheet-workflow.yml
        name: Google Sheets Create and Seed a Spreadsheet
        summary: Create a new spreadsheet, append seed rows to it, then read them back.
      - url: arazzo/google-sheets-create-with-extra-sheet-and-write-workflow.yml
        name: Google Sheets Create With an Extra Sheet and Write
        summary: Create a spreadsheet, add a second named sheet to it, then write values into that sheet.
      - url: arazzo/google-sheets-create-write-and-verify-workflow.yml
        name: Google Sheets Create, Write, and Verify
        summary: Create a spreadsheet, write values into a range, then read the range back to verify the write.
      - url: arazzo/google-sheets-overwrite-or-append-rows-workflow.yml
        name: Google Sheets Overwrite or Append Rows
        summary: Inspect a range and branch — overwrite it in place when it already has data, otherwise append fresh rows.
      - url: arazzo/google-sheets-refresh-range-workflow.yml
        name: Google Sheets Refresh a Range
        summary: Read the current values of a range, clear it, then write a fresh set of values into it.
      - url: arazzo/google-sheets-seed-if-empty-workflow.yml
        name: Google Sheets Seed a Range Only If Empty
        summary: Read a range and branch — write seed values only when the range has no existing data.
      - url: arazzo/google-sheets-tag-and-find-developer-metadata-workflow.yml
        name: Google Sheets Tag and Find a Spreadsheet With Developer Metadata
        summary: Create a spreadsheet, attach a developer metadata tag via batchUpdate, then search for it by key.
      - url: arazzo/google-sheets-update-and-read-by-data-filter-workflow.yml
        name: Google Sheets Update and Read Values by Data Filter
        summary: Resolve a spreadsheet via a data filter, update matching ranges by filter, then read them back by filter.
  - type: Portal
    url: https://developers.google.com/workspace/sheets/api
  - type: Documentation
    url: https://developers.google.com/workspace/sheets/api/reference/rest
  - type: Blog
    url: https://workspace.google.com/blog/developers-practitioners
  - type: GitHubOrganization
    url: https://github.com/googleapis
  - type: Support
    url: https://developers.google.com/sheets/api/support
  - type: StatusPage
    url: https://www.google.com/appsstatus/dashboard/
  - type: TermsOfService
    url: https://developers.google.com/terms
  - type: PrivacyPolicy
    url: https://policies.google.com/privacy
  - type: SignUp
    url: https://console.cloud.google.com/
  - type: Login
    url: https://console.cloud.google.com/
  - type: StackOverflow
    url: https://stackoverflow.com/questions/tagged/google-sheets-api
  - type: YouTube
    url: https://developers.google.com/workspace/sheets/api/videos
  - type: GettingStarted
    url: https://developers.google.com/workspace/sheets/api/guides/concepts
  - type: Authentication
    url: https://developers.google.com/sheets/api/guides/authorizing
  - type: SDK
    url: https://developers.google.com/workspace/sheets/api/guides/libraries
  - type: ReleaseNotes
    url: https://developers.google.com/workspace/sheets/release-notes
  - type: Pricing
    url: https://developers.google.com/workspace/sheets/api/limits
  - type: RateLimits
    url: https://developers.google.com/workspace/sheets/api/limits
  - type: SpectralRules
    url: rules/google-sheets-spectral-rules.yml
  - type: Features
    data:
      - name: Spreadsheet Management
        description: Create, read, update, and delete spreadsheets programmatically with full control over properties and metadata.
      - name: Cell Value Operations
        description: Read and write individual cell values, ranges, and batch operations across multiple ranges.
      - name: Formatting
        description: Apply rich formatting to cells including fonts, colors, borders, alignment, and number formats.
      - name: Sheet Management
        description: Add, remove, copy, and configure individual sheets within a spreadsheet.
      - name: Developer Metadata
        description: Attach custom metadata to spreadsheets, sheets, rows, and columns for application-specific data.
      - name: Data Validation
        description: Set validation rules on cells to enforce data quality and consistency.
      - name: Conditional Formatting
        description: Apply conditional formatting rules based on cell values and formulas.
      - name: Charts and Graphs
        description: Create and manage embedded charts within spreadsheets.
      - name: Named Ranges
        description: Define and manage named ranges for easier formula references.
      - name: Batch Operations
        description: Execute multiple read and write operations in a single API call for efficiency.
  - type: UseCases
    data:
      - name: Data Collection and Reporting
        description: Collect data from various sources and generate automated reports in Google Sheets.
      - name: Database Backend
        description: Use Google Sheets as a lightweight database for web applications and prototypes.
      - name: Workflow Automation
        description: Automate data entry, processing, and distribution workflows using the API.
      - name: Data Integration
        description: Synchronize data between Google Sheets and other business applications.
      - name: Dashboard Creation
        description: Build interactive dashboards and visualizations from spreadsheet data.
  - type: Integrations
    data:
      - name: Google Workspace
        description: Deep integration with Google Docs, Slides, Forms, and other Workspace applications.
      - name: Google Apps Script
        description: Extend Sheets functionality with custom functions, menus, and automation scripts.
      - name: Google Cloud Platform
        description: Connect to BigQuery, Cloud Functions, and other GCP services for advanced data processing.
      - name: Zapier
        description: Connect Google Sheets to thousands of apps through Zapier automation workflows.
      - name: Slack
        description: Send notifications and updates to Slack channels based on spreadsheet changes.
tags:
  - Google Workspace
  - Productivity
  - Spreadsheets