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
  • Release notes
  • Developer Previews
  • YouTube
  • Newsletter
  • X (Twitter)
  • Blog
/
  • 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 MCP server Samples Support
Google Workspace
  • Google Workspace
  • Home
  • Google Sheets
    • Overview
    • Guides
    • Reference
    • MCP server
    • 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
  • Release notes
  • Developer Previews
  • YouTube
  • Newsletter
  • X (Twitter)
  • Blog
  • Home
  • Google Workspace
  • Google Sheets
  • Reference

REST Resource: spreadsheets.values Stay organized with collections Save and categorize content based on your preferences.

  • Resource: ValueRange
    • JSON representation
  • Methods

Resource: ValueRange

Data within a range of the spreadsheet.

JSON representation