Skip to main content
Google Workspace
  • Google Workspace
Home Google Sheets All products
  • Google Workspace apps
  • Admin console
  • Cloud Search
  • Gmail
  • Google Calendar
  • Google Chat
  • Google Classroom
  • Google Docs
  • Google Drive
  •  
  • Google Forms
  • Google Keep
  • Google Meet
  • Google Sheets
  • Google Sites
  • Google Slides
  • Google Tasks
  • Google Vault
  • Extend, automate & share
  • Add-ons
  • Apps Script
  • Chat apps
  • Drive apps
  • Marketplace
Resources
  • Tools
  • Admin console
  • Apps Script dashboard
  • Google Cloud console
  • APIs Explorer
  • Card Builder
  • Training & support
  • How to get started
  • Codelabs
  • Developer support
  • Updates
  • Blog
  • Developer Previews
  • Newsletter
  • X (Twitter)
  • YouTube
/
  • English
  • Deutsch
  • Español
  • Español – América Latina
  • Français
  • Indonesia
  • Italiano
  • Polski
  • Português – Brasil
  • Tiếng Việt
  • Türkçe
  • Русский
  • עברית
  • العربيّة
  • فارسی
  • हिंदी
  • বাংলা
  • ภาษาไทย
  • 中文 – 简体
  • 中文 – 繁體
  • 日本語
  • 한국어
Sign in
  • Google Sheets
Overview Guides Reference Samples Support
Google Workspace
  • Google Workspace
  • Home
  • Google Sheets
    • Overview
    • Guides
    • Reference
    • Samples
    • Support
  • All products
    • More
  • Resources
    • More
  • Sheets API
  • v4
    • 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
  • Client libraries
    • Overview
    • Browser
    • Go
    • Java
      • Core library
      • API library
    • .NET
      • Core library
      • API library
    • Node.js
    • PHP
    • Python
      • Core library
      • API library
    • Ruby
  • Query parameters
  • Usage limits
  • Google Workspace apps
  • Admin console
  • Cloud Search
  • Gmail
  • Google Calendar
  • Google Chat
  • Google Classroom
  • Google Docs
  • Google Drive
  •  
  • Google Forms
  • Google Keep
  • Google Meet
  • Google Sheets
  • Google Sites
  • Google Slides
  • Google Tasks
  • Google Vault
  • Extend, automate & share
  • Add-ons
  • Apps Script
  • Chat apps
  • Drive apps
  • Marketplace
  • Tools
  • Admin console
  • Apps Script dashboard
  • Google Cloud console
  • APIs Explorer
  • Card Builder
  • Training & support
  • How to get started
  • Codelabs
  • Developer support
  • Updates
  • Blog
  • Developer Previews
  • Newsletter
  • X (Twitter)
  • YouTube
  • Home
  • Google Workspace
  • Google Sheets
  • Reference

Standard Query Parameters
Stay organized with collections Save and categorize content based on your preferences.

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 2025-06-04 UTC.

  • Blog Blog
    Read the Google Workspace Developers blog
  • X (Twitter) X (Twitter)
    Follow @workspacedevs on X (Twitter)
  • Code Samples Code Samples
    Explore our sample apps or copy them to build your own
  • Codelabs Codelabs
    Try a guided, hands-on coding experience
  • Videos Videos
    Subscribe to our YouTube channel
  • Google Workspace for Developers

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

    • Admin console
    • Apps Script Dashboard
    • Google Cloud console
    • APIs Explorer
  • Connect

    • Blog
    • Newsletter
    • X (Twitter)
    • YouTube
Google Developers
  • Android
  • Chrome
  • Firebase
  • Google Cloud Platform
  • Google AI
  • All products
  • Terms
  • Privacy
  • Manage cookies
  • Sign up for the Google for Developers newsletter Subscribe
  • English
  • Deutsch
  • Español
  • Español – América Latina
  • Français
  • Indonesia
  • Italiano
  • Polski
  • Português – Brasil
  • Tiếng Việt
  • Türkçe
  • Русский
  • עברית
  • العربيّة
  • فارسی
  • हिंदी
  • বাংলা
  • ภาษาไทย
  • 中文 – 简体
  • 中文 – 繁體
  • 日本語
  • 한국어