Google Sheets for Developers
  • Google Sheets for Developers
  • Sheets API
Sign in
Home Guides Reference Samples Support
Google Sheets for Developers
  • Google Sheets for Developers
  • Sheets API
  • Home
  • Guides
  • Reference
  • Samples
  • Support
  • Overview
  • REST Resources
  • spreadsheets
    • Overview
      • Spreadsheets
      • Sheets
      • Cells
      • Pivot Tables
      • Charts
      • Other
    • batchUpdate
      • Overview
      • Requests
      • Responses
    • create
    • get
    • getByDataFilter
  • spreadsheets.developerMetadata
    • Overview
    • get
    • search
  • spreadsheets.sheets
    • Overview
    • copyTo
  • spreadsheets.values
    • Overview
    • append
    • batchClear
    • batchClearByDataFilter
    • batchGet
    • batchGetByDataFilter
    • batchUpdate
    • batchUpdateByDataFilter
    • clear
    • get
    • update
  • Types
  • DataFilter
  • DateTimeRenderOption
  • Dimension
  • DimensionRange
  • ErrorCode
  • ErrorDetails
  • UpdateValuesResponse
  • ValueInputOption
  • ValueRenderOption
  • Other Reference
  • Query Parameters
  • Usage limits
  • Client Library Reference
  • Browser
  • Go
  • Java
    • Core library
    • API library
  • .NET
    • Core library
    • API library
  • Node.js
  • PHP
  • Python
    • Core library
    • API library
  • Ruby
  • Home
  • Google Workspace for Developers
  • Google Sheets for Developers
  • Sheets API
  • Reference

Standard Query Parameters

Query parameters that apply to all Google Sheets API operations are documented at System Parameters.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2022-03-16 UTC.

  • Blog Blog
    Read the Google Workspace Developers blog
  • Stack Overflow Stack Overflow
    Ask questions with the google-sheets-api tag
  • file_download
    Client libraries
    Download a client library for your preferred language
  • Codelabs Codelabs
    Try a guided, hands-on coding experience
  • Google Workspace for Developers

    • Platform overview
    • Developer products
    • Developer support
    • Terms of Service
  • Tools

    • Admin Console
    • Apps Script Dashboard
    • Google Cloud console
  • Connect

    • Blog
    • Newsletter
    • Twitter
    • YouTube
Google Developers
  • Android
  • Chrome
  • Firebase
  • Google Cloud Platform
  • All products
  • Terms
  • Privacy
  • Sign up for the Google Developers newsletter Subscribe