REST Resource: spreadsheets | Google Sheets

<!doctype html> <html lang="en" dir="ltr"> <head> <meta name="google-signin-client-id" content="721724668570-nbkv1cfusk7kk4eni4pjvepaus73b13t.apps.googleusercontent.com"> <meta name="google-signin-scope" content="profile email https://www.googleapis.com/auth/developerprofiles https://www.googleapis.com/auth/developerprofiles.award"> <meta property="og:site_name" content="Google for Developers"> <meta property="og:type" content="website"><meta name="theme-color" content="#fff"><meta charset="utf-8"> <meta content="IE=Edge" http-equiv="X-UA-Compatible"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="manifest" href="/_pwa/developers/manifest.json" crossorigin="use-credentials"> <link rel="preconnect" href="//www.gstatic.com" crossorigin> <link rel="preconnect" href="//fonts.gstatic.com" crossorigin> <link rel="preconnect" href="//fonts.googleapis.com" crossorigin> <link rel="preconnect" href="//apis.google.com" crossorigin> <link rel="preconnect" href="//www.google-analytics.com" crossorigin><link rel="stylesheet" href="//fonts.googleapis.com/css?family=Google+Sans:400,500|Roboto:400,400italic,500,500italic,700,700italic|Roboto+Mono:400,500,700&display=swap"> <link rel="stylesheet" href="//fonts.googleapis.com/css2?family=Material+Icons&family=Material+Symbols+Outlined&display=block"><link rel="stylesheet" href="https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/css/app.css"> <link rel="shortcut icon" href="https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/images/favicon-new.png"> <link rel="apple-touch-icon" href="https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/images/touchicon-180-new.png"><link rel="canonical" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets"><link rel="search" type="application/opensearchdescription+xml" title="Google for Developers" href="https://developers.google.com/s/opensearch.xml"> <link rel="alternate" hreflang="en" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets" /><link rel="alternate" hreflang="x-default" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets" /><link rel="alternate" hreflang="ar" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=ar" /><link rel="alternate" hreflang="bn" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=bn" /><link rel="alternate" hreflang="zh-Hans" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=zh-cn" /><link rel="alternate" hreflang="zh-Hant" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=zh-tw" /><link rel="alternate" hreflang="fa" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=fa" /><link rel="alternate" hreflang="fr" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=fr" /><link rel="alternate" hreflang="de" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=de" /><link rel="alternate" hreflang="he" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=he" /><link rel="alternate" hreflang="hi" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=hi" /><link rel="alternate" hreflang="id" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=id" /><link rel="alternate" hreflang="it" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=it" /><link rel="alternate" hreflang="ja" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=ja" /><link rel="alternate" hreflang="ko" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=ko" /><link rel="alternate" hreflang="pl" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=pl" /><link rel="alternate" hreflang="pt-BR" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=pt-br" /><link rel="alternate" hreflang="ru" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=ru" /><link rel="alternate" hreflang="es-419" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=es-419" /><link rel="alternate" hreflang="th" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=th" /><link rel="alternate" hreflang="tr" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=tr" /><link rel="alternate" hreflang="vi" href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets?hl=vi" /><title>REST Resource: spreadsheets  |  Google Sheets  |  Google for Developers</title> <meta property="og:title" content="REST Resource: spreadsheets  |  Google Sheets  |  Google for Developers"><meta property="og:url" content="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets"><meta property="og:image" content="https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/images/opengraph/white.png"> <meta property="og:image:width" content="1200"> <meta property="og:image:height" content="675"><meta property="og:locale" content="en"><meta name="twitter:card" content="summary_large_image"><script type="application/ld+json"> { "@context": "https://schema.org", "@type": "BreadcrumbList", "itemListElement": [{ "@type": "ListItem", "position": 1, "name": "Google Workspace", "item": "https://developers.google.com/workspace" },{ "@type": "ListItem", "position": 2, "name": "Google Sheets", "item": "https://developers.google.com/sheets" },{ "@type": "ListItem", "position": 3, "name": "REST Resource: spreadsheets", "item": "https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets" }] } </script> <link rel="stylesheet" href="/extras.css"></head> <body class="docs" template="page" theme="white" type="reference" itemscope itemtype="http://developers.google.com/ReferenceObject" layout="docs" concierge='closed' display-toc pending> <devsite-progress type="indeterminate" id="app-progress"></devsite-progress> <a href="#main-content" class="skip-link button"> Skip to main content </a> <section class="devsite-wrapper"> <devsite-cookie-notification-bar></devsite-cookie-notification-bar><devsite-header role="banner"> <div class="devsite-header--inner" data-nosnippet> <div class="devsite-top-logo-row-wrapper-wrapper"> <div class="devsite-top-logo-row-wrapper"> <div class="devsite-top-logo-row"> <button type="button" id="devsite-hamburger-menu" class="devsite-header-icon-button button-flat material-icons gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Navigation menu button" visually-hidden aria-label="Open menu"> </button> <div class="devsite-product-name-wrapper"> <a href="https://developers.google.com/workspace"> <div class="devsite-product-logo-container" size="medium" > <picture> <img class="devsite-product-logo" alt="Google Workspace" src="https://fonts.gstatic.com/s/i/productlogos/googleg/v6/16px.svg" srcset=" https://fonts.gstatic.com/s/i/productlogos/googleg/v6/16px.svg" sizes="64px" loading="lazy" > </picture> </div> </a> <span class="devsite-product-name"> <ul class="devsite-breadcrumb-list" > <li class="devsite-breadcrumb-item devsite-has-google-wordmark"> <a href="https://developers.google.com/workspace" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Upper Header" data-value="1" track-type="globalNav" track-name="breadcrumb" track-metadata-position="1" track-metadata-eventdetail="Google Workspace" > <svg class="devsite-google-wordmark" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 148 48"> <title>Google</title> <path class="devsite-google-wordmark-svg-path" d="M19.58,37.65c-9.87,0-18.17-8.04-18.17-17.91c0-9.87,8.3-17.91,18.17-17.91c5.46,0,9.35,2.14,12.27,4.94l-3.45,3.45c-2.1-1.97-4.93-3.49-8.82-3.49c-7.21,0-12.84,5.81-12.84,13.02c0,7.21,5.64,13.02,12.84,13.02c4.67,0,7.34-1.88,9.04-3.58c1.4-1.4,2.32-3.41,2.66-6.16H19.58v-4.89h16.47c0.18,0.87,0.26,1.92,0.26,3.06c0,3.67-1.01,8.21-4.24,11.44C28.93,35.9,24.91,37.65,19.58,37.65z M61.78,26.12c0,6.64-5.1,11.53-11.36,11.53s-11.36-4.89-11.36-11.53c0-6.68,5.1-11.53,11.36-11.53S61.78,19.43,61.78,26.12z M56.8,26.12c0-4.15-2.96-6.99-6.39-6.99c-3.43,0-6.39,2.84-6.39,6.99c0,4.11,2.96,6.99,6.39,6.99C53.84,33.11,56.8,30.22,56.8,26.12z M87.25,26.12c0,6.64-5.1,11.53-11.36,11.53c-6.26,0-11.36-4.89-11.36-11.53c0-6.68,5.1-11.53,11.36-11.53C82.15,14.59,87.25,19.43,87.25,26.12zM82.28,26.12c0-4.15-2.96-6.99-6.39-6.99c-3.43,0-6.39,2.84-6.39,6.99c0,4.11,2.96,6.99,6.39,6.99C79.32,33.11,82.28,30.22,82.28,26.12z M112.09,15.29v20.7c0,8.52-5.02,12.01-10.96,12.01c-5.59,0-8.95-3.76-10.22-6.81l4.41-1.83c0.79,1.88,2.71,4.1,5.81,4.1c3.8,0,6.16-2.36,6.16-6.77v-1.66h-0.18c-1.14,1.4-3.32,2.62-6.07,2.62c-5.76,0-11.05-5.02-11.05-11.49c0-6.51,5.28-11.57,11.05-11.57c2.75,0,4.93,1.22,6.07,2.58h0.18v-1.88H112.09z M107.64,26.16c0-4.06-2.71-7.03-6.16-7.03c-3.49,0-6.42,2.97-6.42,7.03c0,4.02,2.93,6.94,6.42,6.94C104.93,33.11,107.64,30.18,107.64,26.16z M120.97,3.06v33.89h-5.07V3.06H120.97z M140.89,29.92l3.93,2.62c-1.27,1.88-4.32,5.11-9.61,5.11c-6.55,0-11.28-5.07-11.28-11.53c0-6.86,4.77-11.53,10.71-11.53c5.98,0,8.91,4.76,9.87,7.34l0.52,1.31l-15.42,6.38c1.18,2.31,3.01,3.49,5.59,3.49C137.79,33.11,139.58,31.84,140.89,29.92zM128.79,25.77l10.31-4.28c-0.57-1.44-2.27-2.45-4.28-2.45C132.24,19.04,128.66,21.31,128.79,25.77z"/> </svg>Workspace </a> </li> </ul> </span> </div> <div class="devsite-top-logo-row-middle"> <div class="devsite-header-upper-tabs"> <devsite-tabs class="upper-tabs"> <nav class="devsite-tabs-wrapper" aria-label="Upper tabs"> <tab > <a href="https://developers.google.com/workspace" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/workspace" track-type="nav" track-metadata-position="nav - home" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Home" track-name="home" > Home </a> </tab> <tab class="devsite-active"> <a href="https://developers.google.com/sheets" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/sheets" track-type="nav" track-metadata-position="nav - google sheets" track-metadata-module="primary nav" aria-label="Google Sheets, selected" data-category="Site-Wide Custom Events" data-label="Tab: Google Sheets" track-name="google sheets" > Google Sheets </a> </tab> <tab class="devsite-dropdown "> <a href="https://developers.google.com/workspace/products-menu" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/workspace/products-menu" track-type="nav" track-metadata-position="nav - all products" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: All products" track-name="all products" > All products </a> <button aria-haspopup="menu" aria-expanded="false" aria-label="Dropdown menu for All products" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/products-menu" track-metadata-position="nav - all products" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: All products" track-name="all products" class="devsite-tabs-dropdown-toggle devsite-icon devsite-icon-arrow-drop-down"></button> <div class="devsite-tabs-dropdown" role="menu" aria-label="submenu" hidden> <div class="devsite-tabs-dropdown-content"> <div class="devsite-tabs-dropdown-column "> <ul class="devsite-tabs-dropdown-section "> <li class="devsite-nav-title" role="heading" tooltip>Google Workspace apps</li> <li class="devsite-nav-item"> <a href="https://developers.google.com/admin-sdk" track-type="nav" track-metadata-eventdetail="https://developers.google.com/admin-sdk" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-label="Tab menu: All products - Admin console" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Admin console </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/cloud-search" track-type="nav" track-metadata-eventdetail="https://developers.google.com/cloud-search" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-label="Tab menu: All products - Cloud Search" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Cloud Search </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/gmail" track-type="nav" track-metadata-eventdetail="https://developers.google.com/gmail" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-label="Tab menu: All products - Gmail" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Gmail </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/calendar" track-type="nav" track-metadata-eventdetail="https://developers.google.com/calendar" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-label="Tab menu: All products - Google Calendar" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Calendar </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/chat" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/chat" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-category="Workspace top menu navigation" data-label="Tab menu: All products - Google Chat" > <div class="devsite-nav-item-title"> Google Chat </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/classroom" track-type="nav" track-metadata-eventdetail="https://developers.google.com/classroom" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-label="Tab menu: All products - Google Classroom" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Classroom </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/docs" track-type="nav" track-metadata-eventdetail="https://developers.google.com/docs" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-label="Tab menu: All products - Google Docs" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Docs </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/drive" track-type="nav" track-metadata-eventdetail="https://developers.google.com/drive" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="google workspace apps" tooltip data-category="Workspace top menu navigation" data-label="Tab menu: All products - Google Drive" > <div class="devsite-nav-item-title"> Google Drive </div> </a> </li> </ul> </div> <div class="devsite-tabs-dropdown-column "> <ul class="devsite-tabs-dropdown-section "> <li class="devsite-nav-title" role="heading" tooltip> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/forms" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/forms" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-category="Workspace top menu navigation" data-label="Tab menu: All products - Google Forms" > <div class="devsite-nav-item-title"> Google Forms </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/keep" track-type="nav" track-metadata-eventdetail="https://developers.google.com/keep" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Keep" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Keep </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/meet" track-type="nav" track-metadata-eventdetail="https://developers.google.com/meet" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Meet" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Meet </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/sheets" track-type="nav" track-metadata-eventdetail="https://developers.google.com/sheets" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Sheets" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Sheets </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/sites" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/sites" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Sites" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Sites </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/slides" track-type="nav" track-metadata-eventdetail="https://developers.google.com/slides" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Slides" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Slides </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/tasks" track-type="nav" track-metadata-eventdetail="https://developers.google.com/tasks" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Tasks" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Tasks </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/vault" track-type="nav" track-metadata-eventdetail="https://developers.google.com/vault" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline=" " tooltip data-label="Tab menu: All products - Google Vault" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Vault </div> </a> </li> </ul> </div> <div class="devsite-tabs-dropdown-column "> <ul class="devsite-tabs-dropdown-section "> <li class="devsite-nav-title" role="heading" tooltip>Extend, automate & share</li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/add-ons" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/add-ons" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="extend, automate & share" tooltip data-label="Tab menu: All products - Add-ons" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Add-ons </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/apps-script" track-type="nav" track-metadata-eventdetail="https://developers.google.com/apps-script" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="extend, automate & share" tooltip data-category="Workspace top menu navigation" data-label="Tab menu: All products - Apps Script" > <div class="devsite-nav-item-title"> Apps Script </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/chat/overview" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/chat/overview" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="extend, automate & share" tooltip data-label="Tab menu: All products - Chat apps" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Chat apps </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/drive/api/guides/about-apps" track-type="nav" track-metadata-eventdetail="https://developers.google.com/drive/api/guides/about-apps" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="extend, automate & share" tooltip data-label="Tab menu: All products - Drive apps" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Drive apps </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/marketplace" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/marketplace" track-metadata-position="nav - all products" track-metadata-module="tertiary nav" track-metadata-module_headline="extend, automate & share" tooltip data-label="Tab menu: All products - Marketplace" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Marketplace </div> </a> </li> </ul> </div> </div> </div> </tab> <tab class="devsite-dropdown "> <a href="https://developers.google.com/workspace/resources-menu" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/workspace/resources-menu" track-type="nav" track-metadata-position="nav - resources" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Resources" track-name="resources" > Resources </a> <button aria-haspopup="menu" aria-expanded="false" aria-label="Dropdown menu for Resources" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/resources-menu" track-metadata-position="nav - resources" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Resources" track-name="resources" class="devsite-tabs-dropdown-toggle devsite-icon devsite-icon-arrow-drop-down"></button> <div class="devsite-tabs-dropdown" role="menu" aria-label="submenu" hidden> <div class="devsite-tabs-dropdown-content"> <div class="devsite-tabs-dropdown-column "> <ul class="devsite-tabs-dropdown-section "> <li class="devsite-nav-title" role="heading" tooltip>Tools</li> <li class="devsite-nav-item"> <a href="https://admin.google.com/" track-type="nav" track-metadata-eventdetail="https://admin.google.com/" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="tools" tooltip target="admin-console" data-label="Tab menu: Resources - Admin console" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Admin console </div> </a> </li> <li class="devsite-nav-item"> <a href="https://script.google.com/" track-type="nav" track-metadata-eventdetail="https://script.google.com/" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="tools" tooltip data-category="Workspace top menu navigation" data-label="Tab menu: Resources - Apps Script dashboard" target="_blank" > <div class="devsite-nav-item-title"> Apps Script dashboard </div> </a> </li> <li class="devsite-nav-item"> <a href="https://console.cloud.google.com/workspace-api" track-type="nav" track-metadata-eventdetail="https://console.cloud.google.com/workspace-api" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="tools" tooltip data-label="Tab menu: Resources - Google Cloud console" target="console" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Google Cloud console </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/explore" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/explore" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="tools" tooltip data-category="Workspace top menu navigation" data-label="Tab menu: Resources - APIs Explorer" > <div class="devsite-nav-item-title"> APIs Explorer </div> </a> </li> <li class="devsite-nav-item"> <a href="https://addons.gsuite.google.com/uikit/builder" track-type="nav" track-metadata-eventdetail="https://addons.gsuite.google.com/uikit/builder" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="tools" tooltip data-category="Workspace top menu navigation" target="_blank" data-label="Tab menu: Resources - Card Builder" > <div class="devsite-nav-item-title"> Card Builder </div> </a> </li> </ul> </div> <div class="devsite-tabs-dropdown-column "> <ul class="devsite-tabs-dropdown-section "> <li class="devsite-nav-title" role="heading" tooltip>Training & support</li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/guides/get-started" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/guides/get-started" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="training & support" tooltip data-label="Tab menu: Resources - How to get started" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> How to get started </div> </a> </li> <li class="devsite-nav-item"> <a href="https://codelabs.developers.google.com/?product=googleworkspace" track-type="nav" track-metadata-eventdetail="https://codelabs.developers.google.com/?product=googleworkspace" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="training & support" tooltip data-label="Tab menu: Resources - Codelabs" target="_blank" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Codelabs </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/support" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/support" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="training & support" tooltip data-label="Tab menu: Resources - Developer support" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Developer support </div> </a> </li> </ul> </div> <div class="devsite-tabs-dropdown-column "> <ul class="devsite-tabs-dropdown-section "> <li class="devsite-nav-title" role="heading" tooltip>Updates</li> <li class="devsite-nav-item"> <a href="https://developers.googleblog.com/search/?query=Google+Workspace" track-type="nav" track-metadata-eventdetail="https://developers.googleblog.com/search/?query=Google+Workspace" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="updates" tooltip data-label="Tab menu: Resources - Blog" data-category="Workspace top menu navigation" target="_blank" > <div class="devsite-nav-item-title"> Blog </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/preview" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/preview" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="updates" tooltip data-category="Workspace top menu navigation" data-label="Tab menu: Resources - Developer previews" > <div class="devsite-nav-item-title"> Developer Previews </div> </a> </li> <li class="devsite-nav-item"> <a href="https://developers.google.com/workspace/newsletters" track-type="nav" track-metadata-eventdetail="https://developers.google.com/workspace/newsletters" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="updates" tooltip data-label="Tab menu: Resources - Newsletter" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> Newsletter </div> </a> </li> <li class="devsite-nav-item"> <a href="https://twitter.com/workspacedevs" track-type="nav" track-metadata-eventdetail="https://twitter.com/workspacedevs" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="updates" tooltip target="_blank" data-label="Tab menu: Resources - X (Twitter)" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> X (Twitter) </div> </a> </li> <li class="devsite-nav-item"> <a href="https://www.youtube.com/channel/UCUcg6az6etU_gRtZVAhBXaw" track-type="nav" track-metadata-eventdetail="https://www.youtube.com/channel/UCUcg6az6etU_gRtZVAhBXaw" track-metadata-position="nav - resources" track-metadata-module="tertiary nav" track-metadata-module_headline="updates" tooltip target="_blank" data-label="Tab menu: Resources - YouTube" data-category="Workspace top menu navigation" > <div class="devsite-nav-item-title"> YouTube </div> </a> </li> </ul> </div> </div> </div> </tab> </nav> </devsite-tabs> </div> <devsite-search enable-signin enable-search enable-suggestions enable-query-completion project-name="Google Sheets" tenant-name="Google for Developers" project-scope="/sheets" url-scoped="https://developers.google.com/s/results/sheets" > <form class="devsite-search-form" action="https://developers.google.com/s/results" method="GET"> <div class="devsite-search-container"> <button type="button" search-open class="devsite-search-button devsite-header-icon-button button-flat material-icons" aria-label="Open search"></button> <div class="devsite-searchbox"> <input aria-activedescendant="" aria-autocomplete="list" aria-label="Search" aria-expanded="false" aria-haspopup="listbox" autocomplete="off" class="devsite-search-field devsite-search-query" name="q" placeholder="Search" role="combobox" type="text" value="" > <div class="devsite-search-image material-icons" aria-hidden="true"> </div> <div class="devsite-search-shortcut-icon-container" aria-hidden="true"> <kbd class="devsite-search-shortcut-icon">/</kbd> </div> </div> </div> </form> <button type="button" search-close class="devsite-search-button devsite-header-icon-button button-flat material-icons" aria-label="Close search"></button> </devsite-search> </div> <devsite-language-selector> <ul role="presentation"> <li role="presentation"> <a role="menuitem" lang="en" >English</a> </li> <li role="presentation"> <a role="menuitem" lang="de" >Deutsch</a> </li> <li role="presentation"> <a role="menuitem" lang="es" >Español</a> </li> <li role="presentation"> <a role="menuitem" lang="es_419" >Español – América Latina</a> </li> <li role="presentation"> <a role="menuitem" lang="fr" >Français</a> </li> <li role="presentation"> <a role="menuitem" lang="id" >Indonesia</a> </li> <li role="presentation"> <a role="menuitem" lang="it" >Italiano</a> </li> <li role="presentation"> <a role="menuitem" lang="pl" >Polski</a> </li> <li role="presentation"> <a role="menuitem" lang="pt_br" >Português – Brasil</a> </li> <li role="presentation"> <a role="menuitem" lang="vi" >Tiếng Việt</a> </li> <li role="presentation"> <a role="menuitem" lang="tr" >Türkçe</a> </li> <li role="presentation"> <a role="menuitem" lang="ru" >Русский</a> </li> <li role="presentation"> <a role="menuitem" lang="he" >עברית</a> </li> <li role="presentation"> <a role="menuitem" lang="ar" >العربيّة</a> </li> <li role="presentation"> <a role="menuitem" lang="fa" >فارسی</a> </li> <li role="presentation"> <a role="menuitem" lang="hi" >हिंदी</a> </li> <li role="presentation"> <a role="menuitem" lang="bn" >বাংলা</a> </li> <li role="presentation"> <a role="menuitem" lang="th" >ภาษาไทย</a> </li> <li role="presentation"> <a role="menuitem" lang="zh_cn" >中文 – 简体</a> </li> <li role="presentation"> <a role="menuitem" lang="zh_tw" >中文 – 繁體</a> </li> <li role="presentation"> <a role="menuitem" lang="ja" >日本語</a> </li> <li role="presentation"> <a role="menuitem" lang="ko" >한국어</a> </li> </ul> </devsite-language-selector> <devsite-user enable-profiles fp-auth id="devsite-user"> <span class="button devsite-top-button" aria-hidden="true" visually-hidden>Sign in</span> </devsite-user> </div> </div> </div> <div class="devsite-collapsible-section "> <div class="devsite-header-background"> <div class="devsite-product-id-row" > <div class="devsite-product-description-row"> <ul class="devsite-breadcrumb-list" > <li class="devsite-breadcrumb-item "> <a href="https://developers.google.com/sheets" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Lower Header" data-value="1" track-type="globalNav" track-name="breadcrumb" track-metadata-position="1" track-metadata-eventdetail="Google Sheets" > Google Sheets </a> </li> </ul> </div> </div> <div class="devsite-doc-set-nav-row"> <devsite-tabs class="lower-tabs"> <nav class="devsite-tabs-wrapper" aria-label="Lower tabs"> <tab > <a href="https://developers.google.com/sheets" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/sheets" track-type="nav" track-metadata-position="nav - overview" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Overview" track-name="overview" > Overview </a> </tab> <tab > <a href="https://developers.google.com/sheets/api/guides/concepts" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/sheets/api/guides/concepts" track-type="nav" track-metadata-position="nav - guides" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Guides" track-name="guides" > Guides </a> </tab> <tab class="devsite-active"> <a href="https://developers.google.com/sheets/api/reference/rest" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/sheets/api/reference/rest" track-type="nav" track-metadata-position="nav - reference" track-metadata-module="primary nav" aria-label="Reference, selected" data-category="Site-Wide Custom Events" data-label="Tab: Reference" track-name="reference" > Reference </a> </tab> <tab > <a href="https://developers.google.com/sheets/api/samples" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/sheets/api/samples" track-type="nav" track-metadata-position="nav - samples" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Samples" track-name="samples" > Samples </a> </tab> <tab > <a href="https://developers.google.com/sheets/api/support" class="devsite-tabs-content gc-analytics-event " track-metadata-eventdetail="https://developers.google.com/sheets/api/support" track-type="nav" track-metadata-position="nav - support" track-metadata-module="primary nav" data-category="Site-Wide Custom Events" data-label="Tab: Support" track-name="support" > Support </a> </tab> </nav> </devsite-tabs> </div> </div> </div> </div> </devsite-header> <devsite-book-nav scrollbars > <div class="devsite-book-nav-filter" > <span class="filter-list-icon material-icons" aria-hidden="true"></span> <input type="text" placeholder="Filter" aria-label="Type to filter" role="searchbox"> <span class="filter-clear-button hidden" data-title="Clear filter" aria-label="Clear filter" role="button" tabindex="0"></span> </div> <nav class="devsite-book-nav devsite-nav nocontent" aria-label="Side menu"> <div class="devsite-mobile-header"> <button type="button" id="devsite-close-nav" class="devsite-header-icon-button button-flat material-icons gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Close navigation" aria-label="Close navigation"> </button> <div class="devsite-product-name-wrapper"> <a href="https://developers.google.com/workspace"> <div class="devsite-product-logo-container" size="medium" > <picture> <img class="devsite-product-logo" alt="Google Workspace" src="https://fonts.gstatic.com/s/i/productlogos/googleg/v6/16px.svg" srcset=" https://fonts.gstatic.com/s/i/productlogos/googleg/v6/16px.svg" sizes="64px" loading="lazy" > </picture> </div> </a> <span class="devsite-product-name"> <ul class="devsite-breadcrumb-list" > <li class="devsite-breadcrumb-item devsite-has-google-wordmark"> <a href="https://developers.google.com/workspace" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Upper Header" data-value="1" track-type="globalNav" track-name="breadcrumb" track-metadata-position="1" track-metadata-eventdetail="Google Workspace" > <svg class="devsite-google-wordmark" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 148 48"> <title>Google</title> <path class="devsite-google-wordmark-svg-path" d="M19.58,37.65c-9.87,0-18.17-8.04-18.17-17.91c0-9.87,8.3-17.91,18.17-17.91c5.46,0,9.35,2.14,12.27,4.94l-3.45,3.45c-2.1-1.97-4.93-3.49-8.82-3.49c-7.21,0-12.84,5.81-12.84,13.02c0,7.21,5.64,13.02,12.84,13.02c4.67,0,7.34-1.88,9.04-3.58c1.4-1.4,2.32-3.41,2.66-6.16H19.58v-4.89h16.47c0.18,0.87,0.26,1.92,0.26,3.06c0,3.67-1.01,8.21-4.24,11.44C28.93,35.9,24.91,37.65,19.58,37.65z M61.78,26.12c0,6.64-5.1,11.53-11.36,11.53s-11.36-4.89-11.36-11.53c0-6.68,5.1-11.53,11.36-11.53S61.78,19.43,61.78,26.12z M56.8,26.12c0-4.15-2.96-6.99-6.39-6.99c-3.43,0-6.39,2.84-6.39,6.99c0,4.11,2.96,6.99,6.39,6.99C53.84,33.11,56.8,30.22,56.8,26.12z M87.25,26.12c0,6.64-5.1,11.53-11.36,11.53c-6.26,0-11.36-4.89-11.36-11.53c0-6.68,5.1-11.53,11.36-11.53C82.15,14.59,87.25,19.43,87.25,26.12zM82.28,26.12c0-4.15-2.96-6.99-6.39-6.99c-3.43,0-6.39,2.84-6.39,6.99c0,4.11,2.96,6.99,6.39,6.99C79.32,33.11,82.28,30.22,82.28,26.12z M112.09,15.29v20.7c0,8.52-5.02,12.01-10.96,12.01c-5.59,0-8.95-3.76-10.22-6.81l4.41-1.83c0.79,1.88,2.71,4.1,5.81,4.1c3.8,0,6.16-2.36,6.16-6.77v-1.66h-0.18c-1.14,1.4-3.32,2.62-6.07,2.62c-5.76,0-11.05-5.02-11.05-11.49c0-6.51,5.28-11.57,11.05-11.57c2.75,0,4.93,1.22,6.07,2.58h0.18v-1.88H112.09z M107.64,26.16c0-4.06-2.71-7.03-6.16-7.03c-3.49,0-6.42,2.97-6.42,7.03c0,4.02,2.93,6.94,6.42,6.94C104.93,33.11,107.64,30.18,107.64,26.16z M120.97,3.06v33.89h-5.07V3.06H120.97z M140.89,29.92l3.93,2.62c-1.27,1.88-4.32,5.11-9.61,5.11c-6.55,0-11.28-5.07-11.28-11.53c0-6.86,4.77-11.53,10.71-11.53c5.98,0,8.91,4.76,9.87,7.34l0.52,1.31l-15.42,6.38c1.18,2.31,3.01,3.49,5.59,3.49C137.79,33.11,139.58,31.84,140.89,29.92zM128.79,25.77l10.31-4.28c-0.57-1.44-2.27-2.45-4.28-2.45C132.24,19.04,128.66,21.31,128.79,25.77z"/> </svg>Workspace </a> </li> </ul> </span> </div> </div> <div class="devsite-book-nav-wrapper"> <div class="devsite-mobile-nav-top"> <ul class="devsite-nav-list"> <li class="devsite-nav-item"> <a href="/workspace" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Tab: Home" track-name="home" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Home" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Home </span> </a> </li> <li class="devsite-nav-item"> <a href="/sheets" class="devsite-nav-title gc-analytics-event devsite-nav-active" data-category="Site-Wide Custom Events" data-label="Tab: Google Sheets" track-name="google sheets" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Sheets" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Sheets </span> </a> <ul class="devsite-nav-responsive-tabs"> <li class="devsite-nav-item"> <a href="/sheets" class="devsite-nav-title gc-analytics-event devsite-nav-has-children " data-category="Site-Wide Custom Events" data-label="Tab: Overview" track-name="overview" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Overview" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Overview </span> <span class="devsite-nav-icon material-icons" data-icon="forward" > </span> </a> </li> <li class="devsite-nav-item"> <a href="/sheets/api/guides/concepts" class="devsite-nav-title gc-analytics-event devsite-nav-has-children " data-category="Site-Wide Custom Events" data-label="Tab: Guides" track-name="guides" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Guides" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Guides </span> <span class="devsite-nav-icon material-icons" data-icon="forward" > </span> </a> </li> <li class="devsite-nav-item"> <a href="/sheets/api/reference/rest" class="devsite-nav-title gc-analytics-event devsite-nav-has-children devsite-nav-active" data-category="Site-Wide Custom Events" data-label="Tab: Reference" track-name="reference" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Reference" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip menu="_book"> Reference </span> <span class="devsite-nav-icon material-icons" data-icon="forward" menu="_book"> </span> </a> </li> <li class="devsite-nav-item"> <a href="/sheets/api/samples" class="devsite-nav-title gc-analytics-event devsite-nav-has-children " data-category="Site-Wide Custom Events" data-label="Tab: Samples" track-name="samples" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Samples" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Samples </span> <span class="devsite-nav-icon material-icons" data-icon="forward" > </span> </a> </li> <li class="devsite-nav-item"> <a href="/sheets/api/support" class="devsite-nav-title gc-analytics-event devsite-nav-has-children " data-category="Site-Wide Custom Events" data-label="Tab: Support" track-name="support" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Support" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Support </span> <span class="devsite-nav-icon material-icons" data-icon="forward" > </span> </a> </li> </ul> </li> <li class="devsite-nav-item"> <a href="/workspace/products-menu" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Tab: All products" track-name="all products" data-category="Site-Wide Custom Events" data-label="Responsive Tab: All products" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > All products </span> </a> <ul class="devsite-nav-responsive-tabs devsite-nav-has-menu "> <li class="devsite-nav-item"> <span class="devsite-nav-title" tooltip data-category="Site-Wide Custom Events" data-label="Tab: All products" track-name="all products" > <span class="devsite-nav-text" tooltip menu="All products"> More </span> <span class="devsite-nav-icon material-icons" data-icon="forward" menu="All products"> </span> </span> </li> </ul> </li> <li class="devsite-nav-item"> <a href="/workspace/resources-menu" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Tab: Resources" track-name="resources" data-category="Site-Wide Custom Events" data-label="Responsive Tab: Resources" track-type="globalNav" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Resources </span> </a> <ul class="devsite-nav-responsive-tabs devsite-nav-has-menu "> <li class="devsite-nav-item"> <span class="devsite-nav-title" tooltip data-category="Site-Wide Custom Events" data-label="Tab: Resources" track-name="resources" > <span class="devsite-nav-text" tooltip menu="Resources"> More </span> <span class="devsite-nav-icon material-icons" data-icon="forward" menu="Resources"> </span> </span> </li> </ul> </li> </ul> </div> <div class="devsite-mobile-nav-bottom"> <ul class="devsite-nav-list" menu="_book"> <li class="devsite-nav-item devsite-nav-heading"><div class="devsite-nav-title devsite-nav-title-no-path"> <span class="devsite-nav-text" tooltip>Sheets API</span> </div></li> <li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>v4</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/reference/rest" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest" ><span class="devsite-nav-text" tooltip>Overview</span></a></li><li class="devsite-nav-item devsite-nav-heading"><div class="devsite-nav-title devsite-nav-title-no-path"> <span class="devsite-nav-text" tooltip>REST Resources</span> </div></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>spreadsheets</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>Overview</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets" ><span class="devsite-nav-text" tooltip>Spreadsheets</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/sheets" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/sheets" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/sheets" ><span class="devsite-nav-text" tooltip>Sheets</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/cells" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/cells" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/cells" ><span class="devsite-nav-text" tooltip>Cells</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/pivot-tables" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/pivot-tables" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/pivot-tables" ><span class="devsite-nav-text" tooltip>Pivot Tables</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/charts" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/charts" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/charts" ><span class="devsite-nav-text" tooltip>Charts</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/other" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/other" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/other" ><span class="devsite-nav-text" tooltip>Other</span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>batchUpdate</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/batchUpdate" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/batchUpdate" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/batchUpdate" ><span class="devsite-nav-text" tooltip>Overview</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/request" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/request" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/request" ><span class="devsite-nav-text" tooltip>Requests</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/response" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/response" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/response" ><span class="devsite-nav-text" tooltip>Responses</span></a></li></ul></div></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/create" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/create" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/create" ><span class="devsite-nav-text" tooltip>create</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/get" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/get" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/get" ><span class="devsite-nav-text" tooltip>get</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets/getByDataFilter" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets/getByDataFilter" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets/getByDataFilter" ><span class="devsite-nav-text" tooltip>getByDataFilter</span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>spreadsheets.developerMetadata</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.developerMetadata" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata" ><span class="devsite-nav-text" tooltip>Overview</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/get" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.developerMetadata/get" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/get" ><span class="devsite-nav-text" tooltip>get</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/search" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.developerMetadata/search" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata/search" ><span class="devsite-nav-text" tooltip>search</span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>spreadsheets.sheets</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.sheets" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.sheets" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.sheets" ><span class="devsite-nav-text" tooltip>Overview</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo" ><span class="devsite-nav-text" tooltip>copyTo</span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>spreadsheets.values</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values" ><span class="devsite-nav-text" tooltip>Overview</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/append" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/append" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/append" ><span class="devsite-nav-text" tooltip>append</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/batchClear" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/batchClear" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/batchClear" ><span class="devsite-nav-text" tooltip>batchClear</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/batchClearByDataFilter" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/batchClearByDataFilter" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/batchClearByDataFilter" ><span class="devsite-nav-text" tooltip>batchClearByDataFilter</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/batchGet" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/batchGet" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/batchGet" ><span class="devsite-nav-text" tooltip>batchGet</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/batchGetByDataFilter" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/batchGetByDataFilter" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/batchGetByDataFilter" ><span class="devsite-nav-text" tooltip>batchGetByDataFilter</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate" ><span class="devsite-nav-text" tooltip>batchUpdate</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdateByDataFilter" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/batchUpdateByDataFilter" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdateByDataFilter" ><span class="devsite-nav-text" tooltip>batchUpdateByDataFilter</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/clear" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/clear" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/clear" ><span class="devsite-nav-text" tooltip>clear</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/get" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/get" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/get" ><span class="devsite-nav-text" tooltip>get</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/spreadsheets.values/update" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/spreadsheets.values/update" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/spreadsheets.values/update" ><span class="devsite-nav-text" tooltip>update</span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-heading"><div class="devsite-nav-title devsite-nav-title-no-path"> <span class="devsite-nav-text" tooltip>Types</span> </div></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/DataFilter" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/DataFilter" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/DataFilter" ><span class="devsite-nav-text" tooltip>DataFilter</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/DateTimeRenderOption" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/DateTimeRenderOption" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/DateTimeRenderOption" ><span class="devsite-nav-text" tooltip>DateTimeRenderOption</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/Dimension" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/Dimension" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/Dimension" ><span class="devsite-nav-text" tooltip>Dimension</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/DimensionRange" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/DimensionRange" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/DimensionRange" ><span class="devsite-nav-text" tooltip>DimensionRange</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/ErrorCode" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/ErrorCode" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/ErrorCode" ><span class="devsite-nav-text" tooltip>ErrorCode</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/ErrorDetails" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/ErrorDetails" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/ErrorDetails" ><span class="devsite-nav-text" tooltip>ErrorDetails</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/UpdateValuesResponse" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/UpdateValuesResponse" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/UpdateValuesResponse" ><span class="devsite-nav-text" tooltip>UpdateValuesResponse</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/ValueInputOption" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/ValueInputOption" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/ValueInputOption" ><span class="devsite-nav-text" tooltip>ValueInputOption</span></a></li><li class="devsite-nav-item"><a href="/sheets/api/reference/rest/v4/ValueRenderOption" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/rest/v4/ValueRenderOption" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/rest/v4/ValueRenderOption" ><span class="devsite-nav-text" tooltip>ValueRenderOption</span></a></li></ul></div></li> <li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>Client libraries</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item"><a href="/sheets/api/guides/libraries" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/guides/libraries" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/guides/libraries" ><span class="devsite-nav-text" tooltip>Overview</span></a></li><li class="devsite-nav-item devsite-nav-external"><a href="https://github.com/google/google-api-javascript-client/blob/master/docs/reference.md" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://github.com/google/google-api-javascript-client/blob/master/docs/reference.md" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://github.com/google/google-api-javascript-client/blob/master/docs/reference.md" ><span class="devsite-nav-text" tooltip>Browser</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-external"><a href="https://pkg.go.dev/google.golang.org/api/sheets/v4" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://pkg.go.dev/google.golang.org/api/sheets/v4" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://pkg.go.dev/google.golang.org/api/sheets/v4" ><span class="devsite-nav-text" tooltip>Go</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>Java</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item devsite-nav-external"><a href="https://googleapis.dev/java/google-api-client/latest/" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://googleapis.dev/java/google-api-client/latest/" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://googleapis.dev/java/google-api-client/latest/" ><span class="devsite-nav-text" tooltip>Core library</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-external"><a href="https://developers.google.com/resources/api-libraries/documentation/sheets/v4/java/latest/" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://developers.google.com/resources/api-libraries/documentation/sheets/v4/java/latest/" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://developers.google.com/resources/api-libraries/documentation/sheets/v4/java/latest/" ><span class="devsite-nav-text" tooltip>API library</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>.NET</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item devsite-nav-external"><a href="https://developers.google.com/api-client-library/dotnet/reference/1.10.0/annotated" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://developers.google.com/api-client-library/dotnet/reference/1.10.0/annotated" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://developers.google.com/api-client-library/dotnet/reference/1.10.0/annotated" ><span class="devsite-nav-text" tooltip>Core library</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-external"><a href="https://developers.google.com/resources/api-libraries/documentation/sheets/v4/csharp/latest/" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://developers.google.com/resources/api-libraries/documentation/sheets/v4/csharp/latest/" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://developers.google.com/resources/api-libraries/documentation/sheets/v4/csharp/latest/" ><span class="devsite-nav-text" tooltip>API library</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-external"><a href="https://googleapis.dev/nodejs/googleapis/latest/sheets/classes/Sheets.html" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://googleapis.dev/nodejs/googleapis/latest/sheets/classes/Sheets.html" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://googleapis.dev/nodejs/googleapis/latest/sheets/classes/Sheets.html" ><span class="devsite-nav-text" tooltip>Node.js</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-external"><a href="https://developers.google.com/resources/api-libraries/documentation/sheets/v4/php/latest/" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://developers.google.com/resources/api-libraries/documentation/sheets/v4/php/latest/" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://developers.google.com/resources/api-libraries/documentation/sheets/v4/php/latest/" ><span class="devsite-nav-text" tooltip>PHP</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-expandable"><div class="devsite-expandable-nav"> <a class="devsite-nav-toggle" aria-hidden="true"></a><div class="devsite-nav-title devsite-nav-title-no-path" tabindex="0" role="button"> <span class="devsite-nav-text" tooltip>Python</span> </div><ul class="devsite-nav-section"><li class="devsite-nav-item devsite-nav-external"><a href="http://googleapis.github.io/google-api-python-client/docs/epy/index.html" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: http://googleapis.github.io/google-api-python-client/docs/epy/index.html" track-type="bookNav" track-name="click" track-metadata-eventdetail="http://googleapis.github.io/google-api-python-client/docs/epy/index.html" ><span class="devsite-nav-text" tooltip>Core library</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li><li class="devsite-nav-item devsite-nav-external"><a href="http://googleapis.github.io/google-api-python-client/docs/dyn/sheets_v4.html" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: http://googleapis.github.io/google-api-python-client/docs/dyn/sheets_v4.html" track-type="bookNav" track-name="click" track-metadata-eventdetail="http://googleapis.github.io/google-api-python-client/docs/dyn/sheets_v4.html" ><span class="devsite-nav-text" tooltip>API library</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li></ul></div></li><li class="devsite-nav-item devsite-nav-external"><a href="https://googleapis.dev/ruby/google-api-client/latest/Google/Apis/SheetsV4.html" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: https://googleapis.dev/ruby/google-api-client/latest/Google/Apis/SheetsV4.html" track-type="bookNav" track-name="click" track-metadata-eventdetail="https://googleapis.dev/ruby/google-api-client/latest/Google/Apis/SheetsV4.html" ><span class="devsite-nav-text" tooltip>Ruby</span><span class="devsite-nav-icon material-icons" data-icon="external" data-title="External" aria-hidden="true"></span></a></li></ul></div></li> <li class="devsite-nav-item"><a href="/sheets/api/reference/query-parameters" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/reference/query-parameters" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/reference/query-parameters" ><span class="devsite-nav-text" tooltip>Query parameters</span></a></li> <li class="devsite-nav-item"><a href="/sheets/api/limits" class="devsite-nav-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Book nav link, pathname: /sheets/api/limits" track-type="bookNav" track-name="click" track-metadata-eventdetail="/sheets/api/limits" ><span class="devsite-nav-text" tooltip>Usage limits</span></a></li> </ul> <ul class="devsite-nav-list" menu="All products" aria-label="Side menu" hidden> <li class="devsite-nav-item devsite-nav-heading"> <span class="devsite-nav-title" tooltip > <span class="devsite-nav-text" tooltip > Google Workspace apps </span> </span> </li> <li class="devsite-nav-item"> <a href="/admin-sdk" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Admin console" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Admin console </span> </a> </li> <li class="devsite-nav-item"> <a href="/cloud-search" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Cloud Search" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Cloud Search </span> </a> </li> <li class="devsite-nav-item"> <a href="/gmail" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Gmail" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Gmail </span> </a> </li> <li class="devsite-nav-item"> <a href="/calendar" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Calendar" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Calendar </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/chat" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Chat" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Chat </span> </a> </li> <li class="devsite-nav-item"> <a href="/classroom" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Classroom" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Classroom </span> </a> </li> <li class="devsite-nav-item"> <a href="/docs" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Docs" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Docs </span> </a> </li> <li class="devsite-nav-item"> <a href="/drive" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Drive" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Drive </span> </a> </li> <li class="devsite-nav-item devsite-nav-heading"> <span class="devsite-nav-title" tooltip > <span class="devsite-nav-text" tooltip > </span> </span> </li> <li class="devsite-nav-item"> <a href="/workspace/forms" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Forms" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Forms </span> </a> </li> <li class="devsite-nav-item"> <a href="/keep" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Keep" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Keep </span> </a> </li> <li class="devsite-nav-item"> <a href="/meet" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Meet" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Meet </span> </a> </li> <li class="devsite-nav-item"> <a href="/sheets" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Sheets" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Sheets </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/sites" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Sites" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Sites </span> </a> </li> <li class="devsite-nav-item"> <a href="/slides" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Slides" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Slides </span> </a> </li> <li class="devsite-nav-item"> <a href="/tasks" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Tasks" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Tasks </span> </a> </li> <li class="devsite-nav-item"> <a href="/vault" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Vault" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Vault </span> </a> </li> <li class="devsite-nav-item devsite-nav-heading"> <span class="devsite-nav-title" tooltip > <span class="devsite-nav-text" tooltip > Extend, automate & share </span> </span> </li> <li class="devsite-nav-item"> <a href="/workspace/add-ons" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Add-ons" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Add-ons </span> </a> </li> <li class="devsite-nav-item"> <a href="/apps-script" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Apps Script" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Apps Script </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/chat/overview" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Chat apps" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Chat apps </span> </a> </li> <li class="devsite-nav-item"> <a href="/drive/api/guides/about-apps" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Drive apps" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Drive apps </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/marketplace" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Marketplace" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Marketplace </span> </a> </li> </ul> <ul class="devsite-nav-list" menu="Resources" aria-label="Side menu" hidden> <li class="devsite-nav-item devsite-nav-heading"> <span class="devsite-nav-title" tooltip > <span class="devsite-nav-text" tooltip > Tools </span> </span> </li> <li class="devsite-nav-item"> <a href="https://admin.google.com/" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Admin console" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Admin console </span> </a> </li> <li class="devsite-nav-item"> <a href="https://script.google.com/" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Apps Script dashboard" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Apps Script dashboard </span> </a> </li> <li class="devsite-nav-item"> <a href="https://console.cloud.google.com/workspace-api" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Google Cloud console" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Google Cloud console </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/explore" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: APIs Explorer" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > APIs Explorer </span> </a> </li> <li class="devsite-nav-item"> <a href="https://addons.gsuite.google.com/uikit/builder" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Card Builder" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Card Builder </span> </a> </li> <li class="devsite-nav-item devsite-nav-heading"> <span class="devsite-nav-title" tooltip > <span class="devsite-nav-text" tooltip > Training & support </span> </span> </li> <li class="devsite-nav-item"> <a href="/workspace/guides/get-started" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: How to get started" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > How to get started </span> </a> </li> <li class="devsite-nav-item"> <a href="https://codelabs.developers.google.com/?product=googleworkspace" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Codelabs" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Codelabs </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/support" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Developer support" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Developer support </span> </a> </li> <li class="devsite-nav-item devsite-nav-heading"> <span class="devsite-nav-title" tooltip > <span class="devsite-nav-text" tooltip > Updates </span> </span> </li> <li class="devsite-nav-item"> <a href="https://developers.googleblog.com/search/?query=Google+Workspace" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Blog" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Blog </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/preview" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Developer Previews" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Developer Previews </span> </a> </li> <li class="devsite-nav-item"> <a href="/workspace/newsletters" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: Newsletter" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > Newsletter </span> </a> </li> <li class="devsite-nav-item"> <a href="https://twitter.com/workspacedevs" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: X (Twitter)" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > X (Twitter) </span> </a> </li> <li class="devsite-nav-item"> <a href="https://www.youtube.com/channel/UCUcg6az6etU_gRtZVAhBXaw" class="devsite-nav-title gc-analytics-event " data-category="Site-Wide Custom Events" data-label="Responsive Tab: YouTube" track-type="navMenu" track-metadata-eventDetail="globalMenu" track-metadata-position="nav"> <span class="devsite-nav-text" tooltip > YouTube </span> </a> </li> </ul> </div> </div> </nav> </devsite-book-nav> <section id="gc-wrapper"> <main role="main" id="main-content" class="devsite-main-content" has-book-nav > <devsite-content> <article class="devsite-article"> <div class="devsite-article-meta nocontent" role="navigation"> <ul class="devsite-breadcrumb-list" aria-label="Breadcrumb"> <li class="devsite-breadcrumb-item "> <a href="https://developers.google.com/" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Breadcrumbs" data-value="1" track-type="globalNav" track-name="breadcrumb" track-metadata-position="1" track-metadata-eventdetail="" > Home </a> </li> <li class="devsite-breadcrumb-item "> <div class="devsite-breadcrumb-guillemet material-icons" aria-hidden="true"></div> <a href="https://developers.google.com/workspace" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Breadcrumbs" data-value="2" track-type="globalNav" track-name="breadcrumb" track-metadata-position="2" track-metadata-eventdetail="Google Workspace" > Google Workspace </a> </li> <li class="devsite-breadcrumb-item "> <div class="devsite-breadcrumb-guillemet material-icons" aria-hidden="true"></div> <a href="https://developers.google.com/sheets" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Breadcrumbs" data-value="3" track-type="globalNav" track-name="breadcrumb" track-metadata-position="3" track-metadata-eventdetail="Google Sheets" > Google Sheets </a> </li> <li class="devsite-breadcrumb-item "> <div class="devsite-breadcrumb-guillemet material-icons" aria-hidden="true"></div> <a href="https://developers.google.com/sheets/api/reference/rest" class="devsite-breadcrumb-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Breadcrumbs" data-value="4" track-type="globalNav" track-name="breadcrumb" track-metadata-position="4" track-metadata-eventdetail="" > Reference </a> </li> </ul> <devsite-thumb-rating position="header"> </devsite-thumb-rating> </div> <devsite-feedback position="header" project-name="Google Sheets" product-id="717201" bucket="sheets" context="" version="t-devsite-webserver-20250304-r00-rc00.467441639078149051" data-label="Send Feedback Button" track-type="feedback" track-name="sendFeedbackLink" track-metadata-position="header" class="nocontent" project-feedback-url="https://issuetracker.google.com/issues/new?component=191608&template=823917" project-icon="https://fonts.gstatic.com/s/i/productlogos/sheets_2020q4/v5/web-64dp/logo_sheets_2020q4_color_1x_web_64dp.png" project-support-url="https://developers.google.com/sheets/api/support" > <button> Send feedback </button> </devsite-feedback> <h1 class="devsite-page-title" tabindex="-1"> REST Resource: spreadsheets </h1> <devsite-feature-tooltip ack-key="AckCollectionsBookmarkTooltipDismiss" analytics-category="Site-Wide Custom Events" analytics-action-show="Callout Profile displayed" analytics-action-close="Callout Profile dismissed" analytics-label="Create Collection Callout" class="devsite-page-bookmark-tooltip nocontent" dismiss-button="true" id="devsite-collections-dropdown" dismiss-button-text="Dismiss" close-button-text="Got it"> <devsite-bookmark></devsite-bookmark> <span slot="popout-heading"> Stay organized with collections </span> <span slot="popout-contents"> Save and categorize content based on your preferences. </span> </devsite-feature-tooltip> <devsite-key-takeaways></devsite-key-takeaways> <div class="devsite-page-title-meta"><devsite-view-release-notes></devsite-view-release-notes></div> <devsite-toc class="devsite-nav" depth="2" devsite-toc-embedded > </devsite-toc> <div class="devsite-article-body clearfix "> <meta content="spreadsheets" itemprop="name"/> <meta content="/sheets/api/reference/rest/v4/spreadsheets" itemprop="path"/> <section id="/sheets/api/reference/rest/v4/spreadsheets"> <ul class="toc"> <li><a href="#Spreadsheet">Resource: Spreadsheet</a> <ul> <li><a href="#Spreadsheet.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SpreadsheetProperties">SpreadsheetProperties</a> <ul> <li><a href="#SpreadsheetProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#RecalculationInterval">RecalculationInterval</a></li> <li><a href="#CellFormat">CellFormat</a> <ul> <li><a href="#CellFormat.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#NumberFormat">NumberFormat</a> <ul> <li><a href="#NumberFormat.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#NumberFormatType">NumberFormatType</a></li> <li><a href="#Color">Color</a> <ul> <li><a href="#Color.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ColorStyle">ColorStyle</a> <ul> <li><a href="#ColorStyle.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ThemeColorType">ThemeColorType</a></li> <li><a href="#Borders">Borders</a> <ul> <li><a href="#Borders.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Border">Border</a> <ul> <li><a href="#Border.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Style">Style</a></li> <li><a href="#Padding">Padding</a> <ul> <li><a href="#Padding.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#HorizontalAlign">HorizontalAlign</a></li> <li><a href="#VerticalAlign">VerticalAlign</a></li> <li><a href="#WrapStrategy">WrapStrategy</a></li> <li><a href="#TextDirection">TextDirection</a></li> <li><a href="#TextFormat">TextFormat</a> <ul> <li><a href="#TextFormat.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Link">Link</a> <ul> <li><a href="#Link.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#HyperlinkDisplayType">HyperlinkDisplayType</a></li> <li><a href="#TextRotation">TextRotation</a> <ul> <li><a href="#TextRotation.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#IterativeCalculationSettings">IterativeCalculationSettings</a> <ul> <li><a href="#IterativeCalculationSettings.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SpreadsheetTheme">SpreadsheetTheme</a> <ul> <li><a href="#SpreadsheetTheme.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ThemeColorPair">ThemeColorPair</a> <ul> <li><a href="#ThemeColorPair.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Sheet">Sheet</a> <ul> <li><a href="#Sheet.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SheetProperties">SheetProperties</a> <ul> <li><a href="#SheetProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SheetType">SheetType</a></li> <li><a href="#GridProperties">GridProperties</a> <ul> <li><a href="#GridProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceSheetProperties">DataSourceSheetProperties</a> <ul> <li><a href="#DataSourceSheetProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceColumn">DataSourceColumn</a> <ul> <li><a href="#DataSourceColumn.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceColumnReference">DataSourceColumnReference</a> <ul> <li><a href="#DataSourceColumnReference.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataExecutionStatus">DataExecutionStatus</a> <ul> <li><a href="#DataExecutionStatus.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataExecutionState">DataExecutionState</a></li> <li><a href="#DataExecutionErrorCode">DataExecutionErrorCode</a></li> <li><a href="#GridData">GridData</a> <ul> <li><a href="#GridData.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#RowData">RowData</a> <ul> <li><a href="#RowData.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#CellData">CellData</a> <ul> <li><a href="#CellData.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ExtendedValue">ExtendedValue</a> <ul> <li><a href="#ExtendedValue.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ErrorValue">ErrorValue</a> <ul> <li><a href="#ErrorValue.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ErrorType">ErrorType</a></li> <li><a href="#TextFormatRun">TextFormatRun</a> <ul> <li><a href="#TextFormatRun.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataValidationRule">DataValidationRule</a> <ul> <li><a href="#DataValidationRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BooleanCondition">BooleanCondition</a> <ul> <li><a href="#BooleanCondition.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ConditionType">ConditionType</a></li> <li><a href="#ConditionValue">ConditionValue</a> <ul> <li><a href="#ConditionValue.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#RelativeDate">RelativeDate</a></li> <li><a href="#PivotTable">PivotTable</a> <ul> <li><a href="#PivotTable.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#GridRange">GridRange</a> <ul> <li><a href="#GridRange.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotGroup">PivotGroup</a> <ul> <li><a href="#PivotGroup.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotGroupValueMetadata">PivotGroupValueMetadata</a> <ul> <li><a href="#PivotGroupValueMetadata.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SortOrder">SortOrder</a></li> <li><a href="#PivotGroupSortValueBucket">PivotGroupSortValueBucket</a> <ul> <li><a href="#PivotGroupSortValueBucket.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotGroupRule">PivotGroupRule</a> <ul> <li><a href="#PivotGroupRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ManualRule">ManualRule</a> <ul> <li><a href="#ManualRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ManualRuleGroup">ManualRuleGroup</a> <ul> <li><a href="#ManualRuleGroup.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#HistogramRule">HistogramRule</a> <ul> <li><a href="#HistogramRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DateTimeRule">DateTimeRule</a> <ul> <li><a href="#DateTimeRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DateTimeRuleType">DateTimeRuleType</a></li> <li><a href="#PivotGroupLimit">PivotGroupLimit</a> <ul> <li><a href="#PivotGroupLimit.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotFilterCriteria">PivotFilterCriteria</a> <ul> <li><a href="#PivotFilterCriteria.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotFilterSpec">PivotFilterSpec</a> <ul> <li><a href="#PivotFilterSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotValue">PivotValue</a> <ul> <li><a href="#PivotValue.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PivotValueSummarizeFunction">PivotValueSummarizeFunction</a></li> <li><a href="#PivotValueCalculatedDisplayType">PivotValueCalculatedDisplayType</a></li> <li><a href="#PivotValueLayout">PivotValueLayout</a></li> <li><a href="#DataSourceTable">DataSourceTable</a> <ul> <li><a href="#DataSourceTable.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceTableColumnSelectionType">DataSourceTableColumnSelectionType</a></li> <li><a href="#FilterSpec">FilterSpec</a> <ul> <li><a href="#FilterSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#FilterCriteria">FilterCriteria</a> <ul> <li><a href="#FilterCriteria.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SortSpec">SortSpec</a> <ul> <li><a href="#SortSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceFormula">DataSourceFormula</a> <ul> <li><a href="#DataSourceFormula.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DimensionProperties">DimensionProperties</a> <ul> <li><a href="#DimensionProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ConditionalFormatRule">ConditionalFormatRule</a> <ul> <li><a href="#ConditionalFormatRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BooleanRule">BooleanRule</a> <ul> <li><a href="#BooleanRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#GradientRule">GradientRule</a> <ul> <li><a href="#GradientRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#InterpolationPoint">InterpolationPoint</a> <ul> <li><a href="#InterpolationPoint.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#InterpolationPointType">InterpolationPointType</a></li> <li><a href="#FilterView">FilterView</a> <ul> <li><a href="#FilterView.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ProtectedRange">ProtectedRange</a> <ul> <li><a href="#ProtectedRange.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Editors">Editors</a> <ul> <li><a href="#Editors.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BasicFilter">BasicFilter</a> <ul> <li><a href="#BasicFilter.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#EmbeddedChart">EmbeddedChart</a> <ul> <li><a href="#EmbeddedChart.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartSpec">ChartSpec</a> <ul> <li><a href="#ChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#TextPosition">TextPosition</a> <ul> <li><a href="#TextPosition.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceChartProperties">DataSourceChartProperties</a> <ul> <li><a href="#DataSourceChartProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BasicChartSpec">BasicChartSpec</a> <ul> <li><a href="#BasicChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BasicChartType">BasicChartType</a></li> <li><a href="#BasicChartLegendPosition">BasicChartLegendPosition</a></li> <li><a href="#BasicChartAxis">BasicChartAxis</a> <ul> <li><a href="#BasicChartAxis.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BasicChartAxisPosition">BasicChartAxisPosition</a></li> <li><a href="#ChartAxisViewWindowOptions">ChartAxisViewWindowOptions</a> <ul> <li><a href="#ChartAxisViewWindowOptions.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ViewWindowMode">ViewWindowMode</a></li> <li><a href="#BasicChartDomain">BasicChartDomain</a> <ul> <li><a href="#BasicChartDomain.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartData">ChartData</a> <ul> <li><a href="#ChartData.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartSourceRange">ChartSourceRange</a> <ul> <li><a href="#ChartSourceRange.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartGroupRule">ChartGroupRule</a> <ul> <li><a href="#ChartGroupRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartDateTimeRule">ChartDateTimeRule</a> <ul> <li><a href="#ChartDateTimeRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartDateTimeRuleType">ChartDateTimeRuleType</a></li> <li><a href="#ChartHistogramRule">ChartHistogramRule</a> <ul> <li><a href="#ChartHistogramRule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartAggregateType">ChartAggregateType</a></li> <li><a href="#BasicChartSeries">BasicChartSeries</a> <ul> <li><a href="#BasicChartSeries.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#LineStyle">LineStyle</a> <ul> <li><a href="#LineStyle.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#LineDashType">LineDashType</a></li> <li><a href="#DataLabel">DataLabel</a> <ul> <li><a href="#DataLabel.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataLabelType">DataLabelType</a></li> <li><a href="#DataLabelPlacement">DataLabelPlacement</a></li> <li><a href="#PointStyle">PointStyle</a> <ul> <li><a href="#PointStyle.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PointShape">PointShape</a></li> <li><a href="#BasicSeriesDataPointStyleOverride">BasicSeriesDataPointStyleOverride</a> <ul> <li><a href="#BasicSeriesDataPointStyleOverride.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BasicChartStackedType">BasicChartStackedType</a></li> <li><a href="#BasicChartCompareMode">BasicChartCompareMode</a></li> <li><a href="#PieChartSpec">PieChartSpec</a> <ul> <li><a href="#PieChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#PieChartLegendPosition">PieChartLegendPosition</a></li> <li><a href="#BubbleChartSpec">BubbleChartSpec</a> <ul> <li><a href="#BubbleChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BubbleChartLegendPosition">BubbleChartLegendPosition</a></li> <li><a href="#CandlestickChartSpec">CandlestickChartSpec</a> <ul> <li><a href="#CandlestickChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#CandlestickDomain">CandlestickDomain</a> <ul> <li><a href="#CandlestickDomain.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#CandlestickData">CandlestickData</a> <ul> <li><a href="#CandlestickData.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#CandlestickSeries">CandlestickSeries</a> <ul> <li><a href="#CandlestickSeries.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#OrgChartSpec">OrgChartSpec</a> <ul> <li><a href="#OrgChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#OrgChartNodeSize">OrgChartNodeSize</a></li> <li><a href="#HistogramChartSpec">HistogramChartSpec</a> <ul> <li><a href="#HistogramChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#HistogramSeries">HistogramSeries</a> <ul> <li><a href="#HistogramSeries.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#HistogramChartLegendPosition">HistogramChartLegendPosition</a></li> <li><a href="#WaterfallChartSpec">WaterfallChartSpec</a> <ul> <li><a href="#WaterfallChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#WaterfallChartDomain">WaterfallChartDomain</a> <ul> <li><a href="#WaterfallChartDomain.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#WaterfallChartSeries">WaterfallChartSeries</a> <ul> <li><a href="#WaterfallChartSeries.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#WaterfallChartColumnStyle">WaterfallChartColumnStyle</a> <ul> <li><a href="#WaterfallChartColumnStyle.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#WaterfallChartCustomSubtotal">WaterfallChartCustomSubtotal</a> <ul> <li><a href="#WaterfallChartCustomSubtotal.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#WaterfallChartStackedType">WaterfallChartStackedType</a></li> <li><a href="#TreemapChartSpec">TreemapChartSpec</a> <ul> <li><a href="#TreemapChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#TreemapChartColorScale">TreemapChartColorScale</a> <ul> <li><a href="#TreemapChartColorScale.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ScorecardChartSpec">ScorecardChartSpec</a> <ul> <li><a href="#ScorecardChartSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#KeyValueFormat">KeyValueFormat</a> <ul> <li><a href="#KeyValueFormat.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BaselineValueFormat">BaselineValueFormat</a> <ul> <li><a href="#BaselineValueFormat.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ComparisonType">ComparisonType</a></li> <li><a href="#ChartNumberFormatSource">ChartNumberFormatSource</a></li> <li><a href="#ChartCustomNumberFormatOptions">ChartCustomNumberFormatOptions</a> <ul> <li><a href="#ChartCustomNumberFormatOptions.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#ChartHiddenDimensionStrategy">ChartHiddenDimensionStrategy</a></li> <li><a href="#EmbeddedObjectPosition">EmbeddedObjectPosition</a> <ul> <li><a href="#EmbeddedObjectPosition.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#OverlayPosition">OverlayPosition</a> <ul> <li><a href="#OverlayPosition.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#GridCoordinate">GridCoordinate</a> <ul> <li><a href="#GridCoordinate.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#EmbeddedObjectBorder">EmbeddedObjectBorder</a> <ul> <li><a href="#EmbeddedObjectBorder.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BandedRange">BandedRange</a> <ul> <li><a href="#BandedRange.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BandingProperties">BandingProperties</a> <ul> <li><a href="#BandingProperties.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DimensionGroup">DimensionGroup</a> <ul> <li><a href="#DimensionGroup.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Slicer">Slicer</a> <ul> <li><a href="#Slicer.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#SlicerSpec">SlicerSpec</a> <ul> <li><a href="#SlicerSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#NamedRange">NamedRange</a> <ul> <li><a href="#NamedRange.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSource">DataSource</a> <ul> <li><a href="#DataSource.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceSpec">DataSourceSpec</a> <ul> <li><a href="#DataSourceSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BigQueryDataSourceSpec">BigQueryDataSourceSpec</a> <ul> <li><a href="#BigQueryDataSourceSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BigQueryQuerySpec">BigQueryQuerySpec</a> <ul> <li><a href="#BigQueryQuerySpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#BigQueryTableSpec">BigQueryTableSpec</a> <ul> <li><a href="#BigQueryTableSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#LookerDataSourceSpec">LookerDataSourceSpec</a> <ul> <li><a href="#LookerDataSourceSpec.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceParameter">DataSourceParameter</a> <ul> <li><a href="#DataSourceParameter.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceRefreshSchedule">DataSourceRefreshSchedule</a> <ul> <li><a href="#DataSourceRefreshSchedule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceRefreshScope">DataSourceRefreshScope</a></li> <li><a href="#DataSourceRefreshDailySchedule">DataSourceRefreshDailySchedule</a> <ul> <li><a href="#DataSourceRefreshDailySchedule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#TimeOfDay">TimeOfDay</a> <ul> <li><a href="#TimeOfDay.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DataSourceRefreshWeeklySchedule">DataSourceRefreshWeeklySchedule</a> <ul> <li><a href="#DataSourceRefreshWeeklySchedule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#DayOfWeek">DayOfWeek</a></li> <li><a href="#DataSourceRefreshMonthlySchedule">DataSourceRefreshMonthlySchedule</a> <ul> <li><a href="#DataSourceRefreshMonthlySchedule.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#Interval">Interval</a> <ul> <li><a href="#Interval.SCHEMA_REPRESENTATION">JSON representation</a></li> </ul> </li> <li><a href="#METHODS_SUMMARY">Methods</a></li> </ul> <section id="Spreadsheet"> <h2 id="resource:-spreadsheet" data-text="Resource: Spreadsheet" tabindex="-1">Resource: Spreadsheet</h2> <section id="Spreadsheet.description"> <p>Resource that represents a spreadsheet.</p> </section> <section id="Spreadsheet.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"spreadsheetId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"properties"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#SpreadsheetProperties">SpreadsheetProperties</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"sheets"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/sheets#Sheet">Sheet</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span><span class="pun">,</span> <span class="str">"namedRanges"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#NamedRange">NamedRange</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span><span class="pun">,</span> <span class="str">"spreadsheetUrl"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"developerMetadata"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata">DeveloperMetadata</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span><span class="pun">,</span> <span class="str">"dataSources"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSource">DataSource</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span><span class="pun">,</span> <span class="str">"dataSourceSchedules"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshSchedule">DataSourceRefreshSchedule</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="Spreadsheet.FIELDS"> <table class="properties responsive fixed" id="Spreadsheet.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="Spreadsheet.FIELDS.spreadsheet_id"> <td><code translate="no" dir="ltr">spreadsheetId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The ID of the spreadsheet. This field is read-only.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.properties"> <td><code translate="no" dir="ltr">properties</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#SpreadsheetProperties">SpreadsheetProperties</a></code>)</code></p> <p>Overall properties of a spreadsheet.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.sheets"> <td><code translate="no" dir="ltr">sheets[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/sheets#Sheet">Sheet</a></code>)</code></p> <p>The sheets that are part of a spreadsheet.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.named_ranges"> <td><code translate="no" dir="ltr">namedRanges[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#NamedRange">NamedRange</a></code>)</code></p> <p>The named ranges defined in a spreadsheet.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.spreadsheet_url"> <td><code translate="no" dir="ltr">spreadsheetUrl</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The url of the spreadsheet. This field is read-only.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.developer_metadata"> <td><code translate="no" dir="ltr">developerMetadata[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets.developerMetadata#DeveloperMetadata">DeveloperMetadata</a></code>)</code></p> <p>The developer metadata associated with a spreadsheet.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.data_sources"> <td><code translate="no" dir="ltr">dataSources[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSource">DataSource</a></code>)</code></p> <p>A list of external data sources connected with the spreadsheet.</p> </td> </tr> <tr id="Spreadsheet.FIELDS.data_source_schedules"> <td><code translate="no" dir="ltr">dataSourceSchedules[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshSchedule">DataSourceRefreshSchedule</a></code>)</code></p> <p>Output only. A list of data source refresh schedules.</p> </td> </tr> </tbody> </table> </section> </section> <section id="SpreadsheetProperties"> <h2 id="spreadsheetproperties" data-text="SpreadsheetProperties" tabindex="-1">SpreadsheetProperties</h2> <section id="SpreadsheetProperties.description"> <p>Properties of a spreadsheet.</p> </section> <section id="SpreadsheetProperties.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"title"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"locale"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"autoRecalc"</span><span class="pun">: </span><span class="kwd">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#RecalculationInterval">RecalculationInterval</a></code>)</span><span class="pun">,</span> <span class="str">"timeZone"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"defaultFormat"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/cells#CellFormat">CellFormat</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"iterativeCalculationSettings"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#IterativeCalculationSettings">IterativeCalculationSettings</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"spreadsheetTheme"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#SpreadsheetTheme">SpreadsheetTheme</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"importFunctionsExternalUrlAccessAllowed"</span><span class="pun">: </span><span class="kwd">boolean</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="SpreadsheetProperties.FIELDS"> <table class="properties responsive fixed" id="SpreadsheetProperties.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="SpreadsheetProperties.FIELDS.title"> <td><code translate="no" dir="ltr">title</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The title of the spreadsheet.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.locale"> <td><code translate="no" dir="ltr">locale</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The locale of the spreadsheet in one of the following formats:</p> <ul> <li><p>an ISO 639-1 language code such as <code translate="no" dir="ltr">en</code></p></li> <li><p>an ISO 639-2 language code such as <code translate="no" dir="ltr">fil</code>, if no 639-1 code exists</p></li> <li><p>a combination of the ISO language code and country code, such as <code translate="no" dir="ltr">en_US</code></p></li> </ul><p>Note: when updating this field, not all locales/languages are supported.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.auto_recalc"> <td><code translate="no" dir="ltr">autoRecalc</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#RecalculationInterval">RecalculationInterval</a></code>)</code></p> <p>The amount of time to wait before volatile functions are recalculated.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.time_zone"> <td><code translate="no" dir="ltr">timeZone</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The time zone of the spreadsheet, in CLDR format such as <code translate="no" dir="ltr">America/New_York</code>. If the time zone isn't recognized, this may be a custom time zone such as <code translate="no" dir="ltr">GMT-07:00</code>.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.default_format"> <td><code translate="no" dir="ltr">defaultFormat</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/cells#CellFormat">CellFormat</a></code>)</code></p> <p>The default format of all cells in the spreadsheet. <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/cells#CellData.FIELDS.effective_format">CellData.effectiveFormat</a></code> will not be set if the cell's format is equal to this default format. This field is read-only.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.iterative_calculation_settings"> <td><code translate="no" dir="ltr">iterativeCalculationSettings</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#IterativeCalculationSettings">IterativeCalculationSettings</a></code>)</code></p> <p>Determines whether and how circular references are resolved with iterative calculation. Absence of this field means that circular references result in calculation errors.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.spreadsheet_theme"> <td><code translate="no" dir="ltr">spreadsheetTheme</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#SpreadsheetTheme">SpreadsheetTheme</a></code>)</code></p> <p>Theme applied to the spreadsheet.</p> </td> </tr> <tr id="SpreadsheetProperties.FIELDS.import_functions_external_url_access_allowed"> <td><code translate="no" dir="ltr">importFunctionsExternalUrlAccessAllowed</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">boolean</code></p> <p>Whether to allow external URL access for image and import functions. Read only when true. When false, you can set to true. This value will be bypassed and always return true if the admin has enabled the allowlisting feature.</p> </td> </tr> </tbody> </table> </section> </section> <section id="RecalculationInterval"> <h2 id="recalculationinterval" data-text="RecalculationInterval" tabindex="-1">RecalculationInterval</h2> <section id="RecalculationInterval.description"> <p>An enumeration of the possible recalculation interval options.</p> </section> <section id="RecalculationInterval.ENUM_VALUES"> <table class="constants responsive fixed" id="RecalculationInterval.ENUM_VALUES-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Enums</th> </tr> </thead> <tbody> <tr id="RecalculationInterval.ENUM_VALUES.RECALCULATION_INTERVAL_UNSPECIFIED"> <td><code class="apitype" translate="no" dir="ltr">RECALCULATION_INTERVAL_UNSPECIFIED</code></td> <td>Default value. This value must not be used.</td> </tr> <tr id="RecalculationInterval.ENUM_VALUES.ON_CHANGE"> <td><code class="apitype" translate="no" dir="ltr">ON_CHANGE</code></td> <td>Volatile functions are updated on every change.</td> </tr> <tr id="RecalculationInterval.ENUM_VALUES.MINUTE"> <td><code class="apitype" translate="no" dir="ltr">MINUTE</code></td> <td>Volatile functions are updated on every change and every minute.</td> </tr> <tr id="RecalculationInterval.ENUM_VALUES.HOUR"> <td><code class="apitype" translate="no" dir="ltr">HOUR</code></td> <td>Volatile functions are updated on every change and hourly.</td> </tr> </tbody> </table> </section> </section> <section id="IterativeCalculationSettings"> <h2 id="iterativecalculationsettings" data-text="IterativeCalculationSettings" tabindex="-1">IterativeCalculationSettings</h2> <section id="IterativeCalculationSettings.description"> <p>Settings to control how circular dependencies are resolved with iterative calculation.</p> </section> <section id="IterativeCalculationSettings.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"maxIterations"</span><span class="pun">: </span><span class="kwd">integer</span><span class="pun">,</span> <span class="str">"convergenceThreshold"</span><span class="pun">: </span><span class="kwd">number</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="IterativeCalculationSettings.FIELDS"> <table class="properties responsive fixed" id="IterativeCalculationSettings.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="IterativeCalculationSettings.FIELDS.max_iterations"> <td><code translate="no" dir="ltr">maxIterations</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>When iterative calculation is enabled, the maximum number of calculation rounds to perform.</p> </td> </tr> <tr id="IterativeCalculationSettings.FIELDS.convergence_threshold"> <td><code translate="no" dir="ltr">convergenceThreshold</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">number</code></p> <p>When iterative calculation is enabled and successive results differ by less than this threshold value, the calculation rounds stop.</p> </td> </tr> </tbody> </table> </section> </section> <section id="SpreadsheetTheme"> <h2 id="spreadsheettheme" data-text="SpreadsheetTheme" tabindex="-1">SpreadsheetTheme</h2> <section id="SpreadsheetTheme.description"> <p>Represents spreadsheet theme</p> </section> <section id="SpreadsheetTheme.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"primaryFontFamily"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"themeColors"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#ThemeColorPair">ThemeColorPair</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="SpreadsheetTheme.FIELDS"> <table class="properties responsive fixed" id="SpreadsheetTheme.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="SpreadsheetTheme.FIELDS.primary_font_family"> <td><code translate="no" dir="ltr">primaryFontFamily</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>Name of the primary font family.</p> </td> </tr> <tr id="SpreadsheetTheme.FIELDS.theme_colors"> <td><code translate="no" dir="ltr">themeColors[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#ThemeColorPair">ThemeColorPair</a></code>)</code></p> <p>The spreadsheet theme color pairs. To update you must provide all theme color pairs.</p> </td> </tr> </tbody> </table> </section> </section> <section id="ThemeColorPair"> <h2 id="themecolorpair" data-text="ThemeColorPair" tabindex="-1">ThemeColorPair</h2> <section id="ThemeColorPair.description"> <p>A pair mapping a spreadsheet theme color type to the concrete color it represents.</p> </section> <section id="ThemeColorPair.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"colorType"</span><span class="pun">: </span><span class="kwd">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#ThemeColorType">ThemeColorType</a></code>)</span><span class="pun">,</span> <span class="str">"color"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#ColorStyle">ColorStyle</a></code>)</span> <span class="pun">}</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="ThemeColorPair.FIELDS"> <table class="properties responsive fixed" id="ThemeColorPair.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="ThemeColorPair.FIELDS.color_type"> <td><code translate="no" dir="ltr">colorType</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#ThemeColorType">ThemeColorType</a></code>)</code></p> <p>The type of the spreadsheet theme color.</p> </td> </tr> <tr id="ThemeColorPair.FIELDS.color"> <td><code translate="no" dir="ltr">color</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#ColorStyle">ColorStyle</a></code>)</code></p> <p>The concrete color corresponding to the theme color type.</p> </td> </tr> </tbody> </table> </section> </section> <section id="NamedRange"> <h2 id="namedrange" data-text="NamedRange" tabindex="-1">NamedRange</h2> <section id="NamedRange.description"> <p>A named range.</p> </section> <section id="NamedRange.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"namedRangeId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"name"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"range"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#GridRange">GridRange</a></code>)</span> <span class="pun">}</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="NamedRange.FIELDS"> <table class="properties responsive fixed" id="NamedRange.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="NamedRange.FIELDS.named_range_id"> <td><code translate="no" dir="ltr">namedRangeId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The ID of the named range.</p> </td> </tr> <tr id="NamedRange.FIELDS.name"> <td><code translate="no" dir="ltr">name</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The name of the named range.</p> </td> </tr> <tr id="NamedRange.FIELDS.range"> <td><code translate="no" dir="ltr">range</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#GridRange">GridRange</a></code>)</code></p> <p>The range this represents.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DataSource"> <h2 id="datasource" data-text="DataSource" tabindex="-1">DataSource</h2> <section id="DataSource.description"> <p>Information about an external data source in the spreadsheet.</p> </section> <section id="DataSource.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"dataSourceId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"spec"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceSpec">DataSourceSpec</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"calculatedColumns"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#DataSourceColumn">DataSourceColumn</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span><span class="pun">,</span> <span class="str">"sheetId"</span><span class="pun">: </span><span class="kwd">integer</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSource.FIELDS"> <table class="properties responsive fixed" id="DataSource.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="DataSource.FIELDS.data_source_id"> <td><code translate="no" dir="ltr">dataSourceId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The spreadsheet-scoped unique ID that identifies the data source. Example: 1080547365.</p> </td> </tr> <tr id="DataSource.FIELDS.spec"> <td><code translate="no" dir="ltr">spec</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceSpec">DataSourceSpec</a></code>)</code></p> <p>The <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceSpec">DataSourceSpec</a></code> for the data source connected with this spreadsheet.</p> </td> </tr> <tr id="DataSource.FIELDS.calculated_columns"> <td><code translate="no" dir="ltr">calculatedColumns[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#DataSourceColumn">DataSourceColumn</a></code>)</code></p> <p>All calculated columns in the data source.</p> </td> </tr> <tr id="DataSource.FIELDS.sheet_id"> <td><code translate="no" dir="ltr">sheetId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>The ID of the <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/sheets#Sheet">Sheet</a></code> connected with the data source. The field cannot be changed once set.</p><p>When creating a data source, an associated <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetType">DATA_SOURCE</a></code> sheet is also created, if the field is not specified, the ID of the created sheet will be randomly generated.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DataSourceSpec"> <h2 id="datasourcespec" data-text="DataSourceSpec" tabindex="-1">DataSourceSpec</h2> <section id="DataSourceSpec.description"> <p>This specifies the details of the data source. For example, for BigQuery, this specifies information about the BigQuery source.</p> </section> <section id="DataSourceSpec.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"parameters"</span><span class="pun">: </span><span class="pun">[</span> <span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceParameter">DataSourceParameter</a></code>)</span> <span class="pun">}</span> <span class="pun">]</span><span class="pun">,</span> <span class="com">// Union field <code translate="no" dir="ltr">spec</code> can be only one of the following:</span> <span class="str">"bigQuery"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryDataSourceSpec">BigQueryDataSourceSpec</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"looker"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#LookerDataSourceSpec">LookerDataSourceSpec</a></code>)</span> <span class="pun">}</span> <span class="com">// End of list of possible types for union field <code translate="no" dir="ltr">spec</code>.</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSourceSpec.FIELDS"> <table class="properties responsive fixed" id="DataSourceSpec.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="DataSourceSpec.FIELDS.parameters"> <td><code translate="no" dir="ltr">parameters[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceParameter">DataSourceParameter</a></code>)</code></p> <p>The parameters of the data source, used when querying the data source.</p> </td> </tr> <tr class="alt" id="DataSourceSpec.FIELDS.oneof_spec"> <td colspan="2">Union field <code translate="no" dir="ltr">spec</code>. The actual specification per data source type. <code translate="no" dir="ltr">spec</code> can be only one of the following:</td> </tr> <tr id="DataSourceSpec.FIELDS.big_query"> <td><code translate="no" dir="ltr">bigQuery</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryDataSourceSpec">BigQueryDataSourceSpec</a></code>)</code></p> <p>A <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryDataSourceSpec">BigQueryDataSourceSpec</a></code>.</p> </td> </tr> <tr id="DataSourceSpec.FIELDS.looker"> <td><code translate="no" dir="ltr">looker</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#LookerDataSourceSpec">LookerDataSourceSpec</a></code>)</code></p> <p>A [LookerDatasourceSpec][].</p> </td> </tr> </tbody> </table> </section> </section> <section id="BigQueryDataSourceSpec"> <h2 id="bigquerydatasourcespec" data-text="BigQueryDataSourceSpec" tabindex="-1">BigQueryDataSourceSpec</h2> <section id="BigQueryDataSourceSpec.description"> <p>The specification of a BigQuery data source that's connected to a sheet.</p> </section> <section id="BigQueryDataSourceSpec.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"projectId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="com">// Union field <code translate="no" dir="ltr">spec</code> can be only one of the following:</span> <span class="str">"querySpec"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryQuerySpec">BigQueryQuerySpec</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"tableSpec"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryTableSpec">BigQueryTableSpec</a></code>)</span> <span class="pun">}</span> <span class="com">// End of list of possible types for union field <code translate="no" dir="ltr">spec</code>.</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="BigQueryDataSourceSpec.FIELDS"> <table class="properties responsive fixed" id="BigQueryDataSourceSpec.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="BigQueryDataSourceSpec.FIELDS.project_id"> <td><code translate="no" dir="ltr">projectId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The ID of a BigQuery enabled Google Cloud project with a billing account attached. For any queries executed against the data source, the project is charged.</p> </td> </tr> <tr class="alt" id="BigQueryDataSourceSpec.FIELDS.oneof_spec"> <td colspan="2">Union field <code translate="no" dir="ltr">spec</code>. The actual specification. <code translate="no" dir="ltr">spec</code> can be only one of the following:</td> </tr> <tr id="BigQueryDataSourceSpec.FIELDS.query_spec"> <td><code translate="no" dir="ltr">querySpec</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryQuerySpec">BigQueryQuerySpec</a></code>)</code></p> <p>A <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryQuerySpec">BigQueryQuerySpec</a></code>.</p> </td> </tr> <tr id="BigQueryDataSourceSpec.FIELDS.table_spec"> <td><code translate="no" dir="ltr">tableSpec</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryTableSpec">BigQueryTableSpec</a></code>)</code></p> <p>A <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryTableSpec">BigQueryTableSpec</a></code>.</p> </td> </tr> </tbody> </table> </section> </section> <section id="BigQueryQuerySpec"> <h2 id="bigqueryqueryspec" data-text="BigQueryQuerySpec" tabindex="-1">BigQueryQuerySpec</h2> <section id="BigQueryQuerySpec.description"> <p>Specifies a custom BigQuery query.</p> </section> <section id="BigQueryQuerySpec.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"rawQuery"</span><span class="pun">: </span><span class="kwd">string</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="BigQueryQuerySpec.FIELDS"> <table class="properties responsive fixed" id="BigQueryQuerySpec.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="BigQueryQuerySpec.FIELDS.raw_query"> <td><code translate="no" dir="ltr">rawQuery</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The raw query string.</p> </td> </tr> </tbody> </table> </section> </section> <section id="BigQueryTableSpec"> <h2 id="bigquerytablespec" data-text="BigQueryTableSpec" tabindex="-1">BigQueryTableSpec</h2> <section id="BigQueryTableSpec.description"> <p>Specifies a BigQuery table definition. Only <a href="https://cloud.google.com/bigquery/docs/tables-intro">native tables</a> are allowed.</p> </section> <section id="BigQueryTableSpec.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"tableProjectId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"tableId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"datasetId"</span><span class="pun">: </span><span class="kwd">string</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="BigQueryTableSpec.FIELDS"> <table class="properties responsive fixed" id="BigQueryTableSpec.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="BigQueryTableSpec.FIELDS.table_project_id"> <td><code translate="no" dir="ltr">tableProjectId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The ID of a BigQuery project the table belongs to. If not specified, the <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#BigQueryDataSourceSpec.FIELDS.project_id">projectId</a></code> is assumed.</p> </td> </tr> <tr id="BigQueryTableSpec.FIELDS.table_id"> <td><code translate="no" dir="ltr">tableId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The BigQuery table id.</p> </td> </tr> <tr id="BigQueryTableSpec.FIELDS.dataset_id"> <td><code translate="no" dir="ltr">datasetId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>The BigQuery dataset id.</p> </td> </tr> </tbody> </table> </section> </section> <section id="LookerDataSourceSpec"> <h2 id="lookerdatasourcespec" data-text="LookerDataSourceSpec" tabindex="-1">LookerDataSourceSpec</h2> <section id="LookerDataSourceSpec.description"> <p>The specification of a Looker data source.</p> </section> <section id="LookerDataSourceSpec.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"instanceUri"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"model"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"explore"</span><span class="pun">: </span><span class="kwd">string</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="LookerDataSourceSpec.FIELDS"> <table class="properties responsive fixed" id="LookerDataSourceSpec.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="LookerDataSourceSpec.FIELDS.instance_uri"> <td><code translate="no" dir="ltr">instanceUri</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>A Looker instance URL.</p> </td> </tr> <tr id="LookerDataSourceSpec.FIELDS.model"> <td><code translate="no" dir="ltr">model</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>Name of a Looker model.</p> </td> </tr> <tr id="LookerDataSourceSpec.FIELDS.explore"> <td><code translate="no" dir="ltr">explore</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>Name of a Looker model explore.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DataSourceParameter"> <h2 id="datasourceparameter" data-text="DataSourceParameter" tabindex="-1">DataSourceParameter</h2> <section id="DataSourceParameter.description"> <p>A parameter in a data source's query. The parameter allows the user to pass in values from the spreadsheet into a query.</p> </section> <section id="DataSourceParameter.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="com">// Union field <code translate="no" dir="ltr">identifier</code> can be only one of the following:</span> <span class="str">"name"</span><span class="pun">: </span><span class="kwd">string</span> <span class="com">// End of list of possible types for union field <code translate="no" dir="ltr">identifier</code>.</span> <span class="com">// Union field <code translate="no" dir="ltr">value</code> can be only one of the following:</span> <span class="str">"namedRangeId"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"range"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#GridRange">GridRange</a></code>)</span> <span class="pun">}</span> <span class="com">// End of list of possible types for union field <code translate="no" dir="ltr">value</code>.</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSourceParameter.FIELDS"> <table class="properties responsive fixed" id="DataSourceParameter.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr class="alt" id="DataSourceParameter.FIELDS.oneof_identifier"> <td colspan="2">Union field <code translate="no" dir="ltr">identifier</code>. The parameter identifier. <code translate="no" dir="ltr">identifier</code> can be only one of the following:</td> </tr> <tr id="DataSourceParameter.FIELDS.name"> <td><code translate="no" dir="ltr">name</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>Named parameter. Must be a legitimate identifier for the <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSource">DataSource</a></code> that supports it. For example, <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical#identifiers">BigQuery identifier</a>.</p> </td> </tr> <tr class="alt" id="DataSourceParameter.FIELDS.oneof_value"> <td colspan="2">Union field <code translate="no" dir="ltr">value</code>. The parameter value. <code translate="no" dir="ltr">value</code> can be only one of the following:</td> </tr> <tr id="DataSourceParameter.FIELDS.named_range_id"> <td><code translate="no" dir="ltr">namedRangeId</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string</code></p> <p>ID of a <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#NamedRange">NamedRange</a></code>. Its size must be 1x1.</p> </td> </tr> <tr id="DataSourceParameter.FIELDS.range"> <td><code translate="no" dir="ltr">range</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/other#GridRange">GridRange</a></code>)</code></p> <p>A range that contains the value of the parameter. Its size must be 1x1.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DataSourceRefreshSchedule"> <h2 id="datasourcerefreshschedule" data-text="DataSourceRefreshSchedule" tabindex="-1">DataSourceRefreshSchedule</h2> <section id="DataSourceRefreshSchedule.description"> <p>Schedule for refreshing the data source.</p><p>Data sources in the spreadsheet are refreshed within a time interval. You can specify the start time by clicking the Scheduled Refresh button in the Sheets editor, but the interval is fixed at 4 hours. For example, if you specify a start time of 8 AM , the refresh will take place between 8 AM and 12 PM every day.</p> </section> <section id="DataSourceRefreshSchedule.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"enabled"</span><span class="pun">: </span><span class="kwd">boolean</span><span class="pun">,</span> <span class="str">"refreshScope"</span><span class="pun">: </span><span class="kwd">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshScope">DataSourceRefreshScope</a></code>)</span><span class="pun">,</span> <span class="str">"nextRun"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#Interval">Interval</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="com">// Union field <code translate="no" dir="ltr">schedule_config</code> can be only one of the following:</span> <span class="str">"dailySchedule"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshDailySchedule">DataSourceRefreshDailySchedule</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"weeklySchedule"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshWeeklySchedule">DataSourceRefreshWeeklySchedule</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"monthlySchedule"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshMonthlySchedule">DataSourceRefreshMonthlySchedule</a></code>)</span> <span class="pun">}</span> <span class="com">// End of list of possible types for union field <code translate="no" dir="ltr">schedule_config</code>.</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSourceRefreshSchedule.FIELDS"> <table class="properties responsive fixed" id="DataSourceRefreshSchedule.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="DataSourceRefreshSchedule.FIELDS.enabled"> <td><code translate="no" dir="ltr">enabled</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">boolean</code></p> <p>True if the refresh schedule is enabled, or false otherwise.</p> </td> </tr> <tr id="DataSourceRefreshSchedule.FIELDS.refresh_scope"> <td><code translate="no" dir="ltr">refreshScope</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshScope">DataSourceRefreshScope</a></code>)</code></p> <p>The scope of the refresh. Must be <code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshScope">ALL_DATA_SOURCES</a></code>.</p> </td> </tr> <tr id="DataSourceRefreshSchedule.FIELDS.next_run"> <td><code translate="no" dir="ltr">nextRun</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#Interval">Interval</a></code>)</code></p> <p>Output only. The time interval of the next run.</p> </td> </tr> <tr class="alt" id="DataSourceRefreshSchedule.FIELDS.oneof_schedule_config"> <td colspan="2">Union field <code translate="no" dir="ltr">schedule_config</code>. Schedule configurations <code translate="no" dir="ltr">schedule_config</code> can be only one of the following:</td> </tr> <tr id="DataSourceRefreshSchedule.FIELDS.daily_schedule"> <td><code translate="no" dir="ltr">dailySchedule</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshDailySchedule">DataSourceRefreshDailySchedule</a></code>)</code></p> <p>Daily refresh schedule.</p> </td> </tr> <tr id="DataSourceRefreshSchedule.FIELDS.weekly_schedule"> <td><code translate="no" dir="ltr">weeklySchedule</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshWeeklySchedule">DataSourceRefreshWeeklySchedule</a></code>)</code></p> <p>Weekly refresh schedule.</p> </td> </tr> <tr id="DataSourceRefreshSchedule.FIELDS.monthly_schedule"> <td><code translate="no" dir="ltr">monthlySchedule</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DataSourceRefreshMonthlySchedule">DataSourceRefreshMonthlySchedule</a></code>)</code></p> <p>Monthly refresh schedule.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DataSourceRefreshScope"> <h2 id="datasourcerefreshscope" data-text="DataSourceRefreshScope" tabindex="-1">DataSourceRefreshScope</h2> <section id="DataSourceRefreshScope.description"> <p>The data source refresh scopes.</p> </section> <section id="DataSourceRefreshScope.ENUM_VALUES"> <table class="constants responsive fixed" id="DataSourceRefreshScope.ENUM_VALUES-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Enums</th> </tr> </thead> <tbody> <tr id="DataSourceRefreshScope.ENUM_VALUES.DATA_SOURCE_REFRESH_SCOPE_UNSPECIFIED"> <td><code class="apitype" translate="no" dir="ltr">DATA_SOURCE_REFRESH_SCOPE_UNSPECIFIED</code></td> <td>Default value, do not use.</td> </tr> <tr id="DataSourceRefreshScope.ENUM_VALUES.ALL_DATA_SOURCES"> <td><code class="apitype" translate="no" dir="ltr">ALL_DATA_SOURCES</code></td> <td>Refreshes all data sources and their associated data source objects in the spreadsheet.</td> </tr> </tbody> </table> </section> </section> <section id="DataSourceRefreshDailySchedule"> <h2 id="datasourcerefreshdailyschedule" data-text="DataSourceRefreshDailySchedule" tabindex="-1">DataSourceRefreshDailySchedule</h2> <section id="DataSourceRefreshDailySchedule.description"> <p>A schedule for data to refresh every day in a given time interval.</p> </section> <section id="DataSourceRefreshDailySchedule.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"startTime"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#TimeOfDay">TimeOfDay</a></code>)</span> <span class="pun">}</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSourceRefreshDailySchedule.FIELDS"> <table class="properties responsive fixed" id="DataSourceRefreshDailySchedule.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="DataSourceRefreshDailySchedule.FIELDS.start_time"> <td><code translate="no" dir="ltr">startTime</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#TimeOfDay">TimeOfDay</a></code>)</code></p> <p>The start time of a time interval in which a data source refresh is scheduled. Only <code translate="no" dir="ltr">hours</code> part is used. The time interval size defaults to that in the Sheets editor.</p> </td> </tr> </tbody> </table> </section> </section> <section id="TimeOfDay"> <h2 id="timeofday" data-text="TimeOfDay" tabindex="-1">TimeOfDay</h2> <section id="TimeOfDay.description"> <p>Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are <code translate="no" dir="ltr">google.type.Date</code> and <code translate="no" dir="ltr">google.protobuf.Timestamp</code>.</p> </section> <section id="TimeOfDay.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"hours"</span><span class="pun">: </span><span class="kwd">integer</span><span class="pun">,</span> <span class="str">"minutes"</span><span class="pun">: </span><span class="kwd">integer</span><span class="pun">,</span> <span class="str">"seconds"</span><span class="pun">: </span><span class="kwd">integer</span><span class="pun">,</span> <span class="str">"nanos"</span><span class="pun">: </span><span class="kwd">integer</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="TimeOfDay.FIELDS"> <table class="properties responsive fixed" id="TimeOfDay.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="TimeOfDay.FIELDS.hours"> <td><code translate="no" dir="ltr">hours</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>Hours of day in 24 hour format. Should be from 0 to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time.</p> </td> </tr> <tr id="TimeOfDay.FIELDS.minutes"> <td><code translate="no" dir="ltr">minutes</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>Minutes of hour of day. Must be from 0 to 59.</p> </td> </tr> <tr id="TimeOfDay.FIELDS.seconds"> <td><code translate="no" dir="ltr">seconds</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>Seconds of minutes of the time. Must normally be from 0 to 59. An API may allow the value 60 if it allows leap-seconds.</p> </td> </tr> <tr id="TimeOfDay.FIELDS.nanos"> <td><code translate="no" dir="ltr">nanos</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>Fractions of seconds in nanoseconds. Must be from 0 to 999,999,999.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DataSourceRefreshWeeklySchedule"> <h2 id="datasourcerefreshweeklyschedule" data-text="DataSourceRefreshWeeklySchedule" tabindex="-1">DataSourceRefreshWeeklySchedule</h2> <section id="DataSourceRefreshWeeklySchedule.description"> <p>A weekly schedule for data to refresh on specific days in a given time interval.</p> </section> <section id="DataSourceRefreshWeeklySchedule.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"startTime"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#TimeOfDay">TimeOfDay</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"daysOfWeek"</span><span class="pun">: </span><span class="pun">[</span> <span class="kwd">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DayOfWeek">DayOfWeek</a></code>)</span> <span class="pun">]</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSourceRefreshWeeklySchedule.FIELDS"> <table class="properties responsive fixed" id="DataSourceRefreshWeeklySchedule.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="DataSourceRefreshWeeklySchedule.FIELDS.start_time"> <td><code translate="no" dir="ltr">startTime</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#TimeOfDay">TimeOfDay</a></code>)</code></p> <p>The start time of a time interval in which a data source refresh is scheduled. Only <code translate="no" dir="ltr">hours</code> part is used. The time interval size defaults to that in the Sheets editor.</p> </td> </tr> <tr id="DataSourceRefreshWeeklySchedule.FIELDS.days_of_week"> <td><code translate="no" dir="ltr">daysOfWeek[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">enum (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#DayOfWeek">DayOfWeek</a></code>)</code></p> <p>Days of the week to refresh. At least one day must be specified.</p> </td> </tr> </tbody> </table> </section> </section> <section id="DayOfWeek"> <h2 id="dayofweek" data-text="DayOfWeek" tabindex="-1">DayOfWeek</h2> <section id="DayOfWeek.description"> <p>Represents a day of the week.</p> </section> <section id="DayOfWeek.ENUM_VALUES"> <table class="constants responsive fixed" id="DayOfWeek.ENUM_VALUES-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Enums</th> </tr> </thead> <tbody> <tr id="DayOfWeek.ENUM_VALUES.DAY_OF_WEEK_UNSPECIFIED"> <td><code class="apitype" translate="no" dir="ltr">DAY_OF_WEEK_UNSPECIFIED</code></td> <td>The day of the week is unspecified.</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.MONDAY"> <td><code class="apitype" translate="no" dir="ltr">MONDAY</code></td> <td>Monday</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.TUESDAY"> <td><code class="apitype" translate="no" dir="ltr">TUESDAY</code></td> <td>Tuesday</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.WEDNESDAY"> <td><code class="apitype" translate="no" dir="ltr">WEDNESDAY</code></td> <td>Wednesday</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.THURSDAY"> <td><code class="apitype" translate="no" dir="ltr">THURSDAY</code></td> <td>Thursday</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.FRIDAY"> <td><code class="apitype" translate="no" dir="ltr">FRIDAY</code></td> <td>Friday</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.SATURDAY"> <td><code class="apitype" translate="no" dir="ltr">SATURDAY</code></td> <td>Saturday</td> </tr> <tr id="DayOfWeek.ENUM_VALUES.SUNDAY"> <td><code class="apitype" translate="no" dir="ltr">SUNDAY</code></td> <td>Sunday</td> </tr> </tbody> </table> </section> </section> <section id="DataSourceRefreshMonthlySchedule"> <h2 id="datasourcerefreshmonthlyschedule" data-text="DataSourceRefreshMonthlySchedule" tabindex="-1">DataSourceRefreshMonthlySchedule</h2> <section id="DataSourceRefreshMonthlySchedule.description"> <p>A monthly schedule for data to refresh on specific days in the month in a given time interval.</p> </section> <section id="DataSourceRefreshMonthlySchedule.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"startTime"</span><span class="pun">: </span><span class="pun">{</span> <span class="kwd">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#TimeOfDay">TimeOfDay</a></code>)</span> <span class="pun">}</span><span class="pun">,</span> <span class="str">"daysOfMonth"</span><span class="pun">: </span><span class="pun">[</span> <span class="kwd">integer</span> <span class="pun">]</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="DataSourceRefreshMonthlySchedule.FIELDS"> <table class="properties responsive fixed" id="DataSourceRefreshMonthlySchedule.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="DataSourceRefreshMonthlySchedule.FIELDS.start_time"> <td><code translate="no" dir="ltr">startTime</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">object (<code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets#TimeOfDay">TimeOfDay</a></code>)</code></p> <p>The start time of a time interval in which a data source refresh is scheduled. Only <code translate="no" dir="ltr">hours</code> part is used. The time interval size defaults to that in the Sheets editor.</p> </td> </tr> <tr id="DataSourceRefreshMonthlySchedule.FIELDS.days_of_month"> <td><code translate="no" dir="ltr">daysOfMonth[]</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">integer</code></p> <p>Days of the month to refresh. Only 1-28 are supported, mapping to the 1st to the 28th day. At least one day must be specified.</p> </td> </tr> </tbody> </table> </section> </section> <section id="Interval"> <h2 id="interval" data-text="Interval" tabindex="-1">Interval</h2> <section id="Interval.description"> <p>Represents a time interval, encoded as a Timestamp start (inclusive) and a Timestamp end (exclusive).</p><p>The start must be less than or equal to the end. When the start equals the end, the interval is empty (matches no time). When both start and end are unspecified, the interval matches any time.</p> </section> <section id="Interval.SCHEMA_REPRESENTATION"> <table class="properties responsive fixed"> <thead> <tr> <th>JSON representation</th> </tr> </thead> <tbody> <tr> <td style="margin:0;padding:0;"><div></div><devsite-code><pre style="border: 0;margin: 0;" translate="no" dir="ltr" is-upgraded><span class="pun">{</span> <span class="str">"startTime"</span><span class="pun">: </span><span class="kwd">string</span><span class="pun">,</span> <span class="str">"endTime"</span><span class="pun">: </span><span class="kwd">string</span> <span class="pun">}</span></pre></devsite-code></td> </tr> </tbody> </table> </section> <section id="Interval.FIELDS"> <table class="properties responsive fixed" id="Interval.FIELDS-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2">Fields</th> </tr> </thead> <tbody> <tr id="Interval.FIELDS.start_time"> <td><code translate="no" dir="ltr">startTime</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string (<code translate="no" dir="ltr"><a href="https://protobuf.dev/reference/protobuf/google.protobuf/#timestamp">Timestamp</a></code> format)</code></p> <p>Optional. Inclusive start of the interval.</p><p>If specified, a Timestamp matching this interval will have to be the same or after the start.</p> </td> </tr> <tr id="Interval.FIELDS.end_time"> <td><code translate="no" dir="ltr">endTime</code></td> <td> <p><code class="apitype" translate="no" dir="ltr">string (<code translate="no" dir="ltr"><a href="https://protobuf.dev/reference/protobuf/google.protobuf/#timestamp">Timestamp</a></code> format)</code></p> <p>Optional. Exclusive end of the interval.</p><p>If specified, a Timestamp matching this interval will have to be before the end.</p> </td> </tr> </tbody> </table> </section> </section> <section id="METHODS_SUMMARY"> <table class="methods responsive fixed" id="METHODS_SUMMARY-table"> <colgroup> <col width="25%"/> <col/> </colgroup> <thead> <tr> <th colspan="2"><h2 id="methods" data-text="Methods" tabindex="-1">Methods</h2></th> </tr> </thead> <tbody> <tr> <td> <h3 id="batchupdate" data-text="batchUpdate" tabindex="-1"><code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/batchUpdate">batchUpdate</a></code></h3></td> <td> Applies one or more updates to the spreadsheet.</td> </tr> <tr> <td> <h3 id="create" data-text="create" tabindex="-1"><code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/create">create</a></code></h3></td> <td> Creates a spreadsheet, returning the newly created spreadsheet.</td> </tr> <tr> <td> <h3 id="get" data-text="get" tabindex="-1"><code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/get">get</a></code></h3></td> <td> Returns the spreadsheet at the given ID.</td> </tr> <tr> <td> <h3 id="getbydatafilter" data-text="getByDataFilter" tabindex="-1"><code translate="no" dir="ltr"><a href="/sheets/api/reference/rest/v4/spreadsheets/getByDataFilter">getByDataFilter</a></code></h3></td> <td> Returns the spreadsheet at the given ID.</td> </tr> </tbody> </table> </section> </section> <devsite-hats-survey class="nocontent" hats-id="fS1QvrotT0eGRuQsCn30Rq78ZF6u" listnr-id="717201"></devsite-hats-survey> </div> <devsite-recommendations display="in-page" hidden yield> </devsite-recommendations> <devsite-thumb-rating position="footer"> </devsite-thumb-rating> <devsite-feedback position="footer" project-name="Google Sheets" product-id="717201" bucket="sheets" context="" version="t-devsite-webserver-20250304-r00-rc00.467441639078149051" data-label="Send Feedback Button" track-type="feedback" track-name="sendFeedbackLink" track-metadata-position="footer" class="nocontent" project-feedback-url="https://issuetracker.google.com/issues/new?component=191608&template=823917" project-icon="https://fonts.gstatic.com/s/i/productlogos/sheets_2020q4/v5/web-64dp/logo_sheets_2020q4_color_1x_web_64dp.png" project-support-url="https://developers.google.com/sheets/api/support" > <button> Send feedback </button> </devsite-feedback> <devsite-recommendations id="recommendations-link" yield></devsite-recommendations> <div class="devsite-floating-action-buttons"> </div> </article> <devsite-content-footer class="nocontent"> <p>Except as otherwise noted, the content of this page is licensed under the <a href="https://creativecommons.org/licenses/by/4.0/">Creative Commons Attribution 4.0 License</a>, and code samples are licensed under the <a href="https://www.apache.org/licenses/LICENSE-2.0">Apache 2.0 License</a>. For details, see the <a href="https://developers.google.com/site-policies">Google Developers Site Policies</a>. Java is a registered trademark of Oracle and/or its affiliates.</p> <p>Last updated 2024-09-04 UTC.</p> </devsite-content-footer> <devsite-notification > </devsite-notification> <div class="devsite-content-data"> <template class="devsite-thumb-rating-feedback"> <devsite-feedback position="thumb-rating" project-name="Google Sheets" product-id="717201" bucket="sheets" context="" version="t-devsite-webserver-20250304-r00-rc00.467441639078149051" data-label="Send Feedback Button" track-type="feedback" track-name="sendFeedbackLink" track-metadata-position="thumb-rating" class="nocontent" project-feedback-url="https://issuetracker.google.com/issues/new?component=191608&template=823917" project-icon="https://fonts.gstatic.com/s/i/productlogos/sheets_2020q4/v5/web-64dp/logo_sheets_2020q4_color_1x_web_64dp.png" project-support-url="https://developers.google.com/sheets/api/support" > <button> Need to tell us more? </button> </devsite-feedback> </template> <template class="devsite-content-data-template"> [[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-04 UTC."],[[["Google Sheets API v4 allows connecting spreadsheets to external data sources like BigQuery and Looker."],["Data sources can be refreshed automatically using customizable schedules (daily, weekly, or monthly)."],["`spec` object defines the data source type and connection details, while `parameters` allow passing user-defined values to queries."],["`DataSourceRefreshSchedule` controls the frequency and scope of data refreshes."],["Several API methods are available to manage spreadsheets and their data sources."]]],["Spreadsheets have unique IDs and URLs, contain sheets and named ranges, and have properties like title, locale, and time zone. They can connect to external data sources like BigQuery or Looker, defined by specifications that include queries or table details. Data source refresh schedules can be set for daily, weekly, or monthly intervals, with specific times and days. Data can be refreshed for all the connected sources. The spreadsheets are also updated in batches.\n"]] </template> </div> </devsite-content> </main> <devsite-footer-promos class="devsite-footer"> <nav class="devsite-footer-promos nocontent" aria-label="Promotions"> <ul class="devsite-footer-promos-list"> <li class="devsite-footer-promo"> <a href="https://developers.googleblog.com/search/?query=Google+Workspace" class="devsite-footer-promo-title gc-analytics-event" data-category="Site-Wide Custom Events" data-category="Workspace Footer" target="_blank" data-label="Promo - Google Workspace Developers Blog" > <picture> <img class="devsite-footer-promo-icon" src="https://www.gstatic.com/images/branding/product/2x/google_cloud_64dp.png" loading="lazy" alt="Blog"> </picture> <span class="devsite-footer-promo-label"> Blog </span> </a> <div class="devsite-footer-promo-description">Read the Google Workspace Developers blog</div> </li> <li class="devsite-footer-promo"> <a href="https://twitter.com/workspacedevs" class="devsite-footer-promo-title gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Promo - Google Workspace on X (Twitter)" target="_blank" data-category="Workspace Footer" > <picture> <img class="devsite-footer-promo-icon" src="/static/site-assets/logo-x.svg" loading="lazy" alt="X (Twitter)"> </picture> <span class="devsite-footer-promo-label"> X (Twitter) </span> </a> <div class="devsite-footer-promo-description">Follow @workspacedevs on X (Twitter)</div> </li> <li class="devsite-footer-promo"> <a href="https://github.com/googleworkspace" class="devsite-footer-promo-title gc-analytics-event" data-category="Site-Wide Custom Events" target="_blank" data-label="Promo - Google Workspace Github" data-category="Workspace Footer" > <picture> <img class="devsite-footer-promo-icon" src="/static/site-assets/logo-github.svg" loading="lazy" alt="Code Samples"> </picture> <span class="devsite-footer-promo-label"> Code Samples </span> </a> <div class="devsite-footer-promo-description">Explore our sample apps or copy them to build your own</div> </li> <li class="devsite-footer-promo"> <a href="https://codelabs.developers.google.com/?product=googleworkspace" class="devsite-footer-promo-title gc-analytics-event" data-category="Site-Wide Custom Events" data-category="Workspace Footer" data-label="Promo - Google Workspace Codelabs" target="_blank" > <picture> <img class="devsite-footer-promo-icon" src="/static/site-assets/developers-logo-color.svg" loading="lazy" alt="Codelabs"> </picture> <span class="devsite-footer-promo-label"> Codelabs </span> </a> <div class="devsite-footer-promo-description">Try a guided, hands-on coding experience</div> </li> <li class="devsite-footer-promo"> <a href="https://www.youtube.com/channel/UCUcg6az6etU_gRtZVAhBXaw" class="devsite-footer-promo-title gc-analytics-event" data-category="Site-Wide Custom Events" target="_blank" data-label="Promo - Google Workspace on YouTube" data-category="Workspace Footer" > <picture> <img class="devsite-footer-promo-icon" src="/static/site-assets/logo-youtube.svg" loading="lazy" alt="Videos"> </picture> <span class="devsite-footer-promo-label"> Videos </span> </a> <div class="devsite-footer-promo-description">Subscribe to our YouTube channel</div> </li> </ul> </nav> </devsite-footer-promos> <devsite-footer-linkboxes class="devsite-footer"> <nav class="devsite-footer-linkboxes nocontent" aria-label="Footer links"> <ul class="devsite-footer-linkboxes-list"> <li class="devsite-footer-linkbox "> <h3 class="devsite-footer-linkbox-heading no-link">Google Workspace for Developers</h3> <ul class="devsite-footer-linkbox-list"> <li class="devsite-footer-linkbox-item"> <a href="/workspace" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Linkbox - Platform overview"data-category="Workspace Footer"> Platform overview </a> </li> <li class="devsite-footer-linkbox-item"> <a href="/workspace/products" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Linkbox - Developer products"data-category="Workspace Footer"> Developer products </a> </li> <li class="devsite-footer-linkbox-item"> <a href="/workspace/support" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Linkbox - Developer support"data-category="Workspace Footer"> Developer support </a> </li> <li class="devsite-footer-linkbox-item"> <a href="/workspace/terms" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-category="Workspace Footer"data-label="Linkbox - Terms of Service"> Terms of Service </a> </li> </ul> </li> <li class="devsite-footer-linkbox "> <h3 class="devsite-footer-linkbox-heading no-link">Tools</h3> <ul class="devsite-footer-linkbox-list"> <li class="devsite-footer-linkbox-item"> <a href="https://admin.google.com/" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Linkbox - Admin console"target="admin-console"data-category="Workspace Footer"> Admin console </a> </li> <li class="devsite-footer-linkbox-item"> <a href="https://script.google.com/" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" target="_blank"data-category="Workspace Footer"data-label="Linkbox - Apps Script Dashboard"> Apps Script Dashboard </a> </li> <li class="devsite-footer-linkbox-item"> <a href="https://console.cloud.google.com/workspace-api" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" target="console"data-label="Linkbox - Google Cloud console"data-category="Workspace Footer"> Google Cloud console </a> </li> <li class="devsite-footer-linkbox-item"> <a href="/workspace/explore" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Linkbox - APIs Explorer"data-category="Workspace Footer"> APIs Explorer </a> </li> </ul> </li> <li class="devsite-footer-linkbox "> <h3 class="devsite-footer-linkbox-heading no-link">Connect</h3> <ul class="devsite-footer-linkbox-list"> <li class="devsite-footer-linkbox-item"> <a href="https://developers.googleblog.com/search/?query=Google+Workspace" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Linkbox - Blog"target="_blank"data-category="Workspace Footer"> Blog </a> </li> <li class="devsite-footer-linkbox-item"> <a href="/workspace/newsletters" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-category="Workspace Footer"data-label="Linkbox - Newsletter"> Newsletter </a> </li> <li class="devsite-footer-linkbox-item"> <a href="https://twitter.com/workspacedevs" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" target="_blank"data-label="Linkbox - X (Twitter)"data-category="Workspace Footer"> X (Twitter) </a> </li> <li class="devsite-footer-linkbox-item"> <a href="https://www.youtube.com/channel/UCUcg6az6etU_gRtZVAhBXaw" class="devsite-footer-linkbox-link gc-analytics-event" data-category="Site-Wide Custom Events" data-category="Workspace Footer"data-label="Linkbox - YouTube"target="_blank"> YouTube </a> </li> </ul> </li> </ul> </nav> </devsite-footer-linkboxes> <devsite-footer-utility class="devsite-footer"> <div class="devsite-footer-utility nocontent"> <nav class="devsite-footer-sites" aria-label="Other Google Developers websites"> <a href="https://developers.google.com/" class="devsite-footer-sites-logo-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer Google Developers Link"> <picture> <img class="devsite-footer-sites-logo" src="https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/images/lockup-google-for-developers.svg" loading="lazy" alt="Google Developers"> </picture> </a> <ul class="devsite-footer-sites-list"> <li class="devsite-footer-sites-item"> <a href="//developer.android.com" class="devsite-footer-sites-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer Android Link" > Android </a> </li> <li class="devsite-footer-sites-item"> <a href="//developer.chrome.com/home" class="devsite-footer-sites-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer Chrome Link" > Chrome </a> </li> <li class="devsite-footer-sites-item"> <a href="//firebase.google.com" class="devsite-footer-sites-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer Firebase Link" > Firebase </a> </li> <li class="devsite-footer-sites-item"> <a href="//cloud.google.com" class="devsite-footer-sites-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer Google Cloud Platform Link" > Google Cloud Platform </a> </li> <li class="devsite-footer-sites-item"> <a href="//ai.google.dev/" class="devsite-footer-sites-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer Google AI Link" > Google AI </a> </li> <li class="devsite-footer-sites-item"> <a href="/products" class="devsite-footer-sites-link gc-analytics-event" data-category="Site-Wide Custom Events" data-label="Footer All products Link" > All products </a> </li> </ul> </nav> <nav class="devsite-footer-utility-links" aria-label="Utility links"> <ul class="devsite-footer-utility-list"> <li class="devsite-footer-utility-item "> <a class="devsite-footer-utility-link gc-analytics-event" href="/terms/site-terms" data-category="Site-Wide Custom Events" data-label="Footer Terms link" > Terms </a> </li> <li class="devsite-footer-utility-item "> <a class="devsite-footer-utility-link gc-analytics-event" href="//policies.google.com/privacy" data-category="Site-Wide Custom Events" data-label="Footer Privacy link" > Privacy </a> </li> <li class="devsite-footer-utility-item glue-cookie-notification-bar-control"> <a class="devsite-footer-utility-link gc-analytics-event" href="#" data-category="Site-Wide Custom Events" data-label="Footer Manage cookies link" aria-hidden="true" > Manage cookies </a> </li> <li class="devsite-footer-utility-item devsite-footer-utility-button"> <span class="devsite-footer-utility-description">Sign up for the Google for Developers newsletter</span> <a class="devsite-footer-utility-link gc-analytics-event" href="/newsletter/subscribe" data-category="Site-Wide Custom Events" data-label="Footer Subscribe link" > Subscribe </a> </li> </ul> <devsite-language-selector> <ul role="presentation"> <li role="presentation"> <a role="menuitem" lang="en" >English</a> </li> <li role="presentation"> <a role="menuitem" lang="de" >Deutsch</a> </li> <li role="presentation"> <a role="menuitem" lang="es" >Español</a> </li> <li role="presentation"> <a role="menuitem" lang="es_419" >Español – América Latina</a> </li> <li role="presentation"> <a role="menuitem" lang="fr" >Français</a> </li> <li role="presentation"> <a role="menuitem" lang="id" >Indonesia</a> </li> <li role="presentation"> <a role="menuitem" lang="it" >Italiano</a> </li> <li role="presentation"> <a role="menuitem" lang="pl" >Polski</a> </li> <li role="presentation"> <a role="menuitem" lang="pt_br" >Português – Brasil</a> </li> <li role="presentation"> <a role="menuitem" lang="vi" >Tiếng Việt</a> </li> <li role="presentation"> <a role="menuitem" lang="tr" >Türkçe</a> </li> <li role="presentation"> <a role="menuitem" lang="ru" >Русский</a> </li> <li role="presentation"> <a role="menuitem" lang="he" >עברית</a> </li> <li role="presentation"> <a role="menuitem" lang="ar" >العربيّة</a> </li> <li role="presentation"> <a role="menuitem" lang="fa" >فارسی</a> </li> <li role="presentation"> <a role="menuitem" lang="hi" >हिंदी</a> </li> <li role="presentation"> <a role="menuitem" lang="bn" >বাংলা</a> </li> <li role="presentation"> <a role="menuitem" lang="th" >ภาษาไทย</a> </li> <li role="presentation"> <a role="menuitem" lang="zh_cn" >中文 – 简体</a> </li> <li role="presentation"> <a role="menuitem" lang="zh_tw" >中文 – 繁體</a> </li> <li role="presentation"> <a role="menuitem" lang="ja" >日本語</a> </li> <li role="presentation"> <a role="menuitem" lang="ko" >한국어</a> </li> </ul> </devsite-language-selector> </nav> </div> </devsite-footer-utility> <devsite-panel></devsite-panel> <devsite-concierge data-info-panel data-ai-panel data-api-explorer-panel > </devsite-concierge> </section></section> <devsite-sitemask></devsite-sitemask> <devsite-snackbar></devsite-snackbar> <devsite-tooltip ></devsite-tooltip> <devsite-heading-link></devsite-heading-link> <devsite-analytics> <script type="application/json" analytics>[{"dimensions": {"dimension6": "en", "dimension5": "en", "dimension3": false, "dimension1": "Signed out", "dimension11": false, "dimension4": "Google Sheets"}, "gaid": "UA-24532603-1", "metrics": {"ratings_count": "metric2", "ratings_value": "metric1"}, "purpose": 1}]</script> <script type="application/json" tag-management>{"at": "True", "ga4": [{"id": "G-272J68FCRF", "purpose": 1}, {"id": "G-YYP88VSJWR", "purpose": 0}], "ga4p": [{"id": "G-272J68FCRF", "purpose": 1}], "gtm": [], "parameters": {"internalUser": "False", "language": {"machineTranslated": "False", "requested": "en", "served": "en"}, "pageType": "reference", "projectName": "Google Sheets", "signedIn": "False", "tenant": "developers", "recommendations": {"sourcePage": "", "sourceType": 0, "sourceRank": 0, "sourceIdenticalDescriptions": 0, "sourceTitleWords": 0, "sourceDescriptionWords": 0, "experiment": ""}, "experiment": {"ids": ""}}}</script> </devsite-analytics> <devsite-badger></devsite-badger> <script nonce="ucVznV1ICmj607Qj/MP8PDqgJ/3iBJ"> (function(d,e,v,s,i,t,E){d['GoogleDevelopersObject']=i; t=e.createElement(v);t.async=1;t.src=s;E=e.getElementsByTagName(v)[0]; E.parentNode.insertBefore(t,E);})(window, document, 'script', 'https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/js/app_loader.js', '[1,"en",null,"/js/devsite_app_module.js","https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07","https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers","https://developers-dot-devsite-v2-prod.appspot.com",null,null,["/_pwa/developers/manifest.json","https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/images/video-placeholder.svg","https://www.gstatic.com/devrel-devsite/prod/v630f393d749cf7dff36a03367007d65915d987bf69b5409e6d70ed7311ba2c07/developers/images/favicon-new.png","https://fonts.googleapis.com/css?family=Google+Sans:400,500|Roboto:400,400italic,500,500italic,700,700italic|Roboto+Mono:400,500,700&display=swap"],1,null,[1,6,8,12,14,17,21,25,50,52,63,70,75,76,80,87,91,92,93,97,98,100,101,102,103,104,105,107,108,109,110,112,113,116,117,118,120,122,124,125,126,127,129,130,131,132,133,134,135,136,138,140,141,147,148,149,151,152,156,157,158,159,161,163,164,168,169,170,179,180,182,183,186,191,193,196],"AIzaSyAP-jjEJBzmIyKR4F-3XITp8yM9T1gEEI8","AIzaSyB6xiKGDR5O3Ak2okS4rLkauxGUG7XP0hg","developers.google.com","AIzaSyAQk0fBONSGUqCNznf6Krs82Ap1-NV6J4o","AIzaSyCCxcqdrZ_7QMeLCRY20bh_SXdAYqy70KY",null,null,null,["Search__enable_ai_search_summaries_restricted","CloudShell__cloud_shell_button","EngEduTelemetry__enable_engedu_telemetry","Cloud__enable_cloud_facet_chat","Search__enable_dynamic_content_confidential_banner","Profiles__enable_awarding_url","MiscFeatureFlags__emergency_css","Profiles__enable_profile_collections","Concierge__enable_concierge_restricted","Profiles__require_profile_eligibility_for_signin","MiscFeatureFlags__enable_view_transitions","Profiles__enable_completequiz_endpoint","Profiles__enable_join_program_group_endpoint","Profiles__enable_page_saving","Profiles__enable_completecodelab_endpoint","Profiles__enable_recognition_badges","Cloud__enable_cloud_shell_fte_user_flow","Cloud__enable_cloudx_ping","MiscFeatureFlags__enable_framebox_badge_methods","Cloud__enable_llm_concierge_chat","MiscFeatureFlags__enable_firebase_utm","MiscFeatureFlags__developers_footer_image","MiscFeatureFlags__enable_variable_operator","MiscFeatureFlags__enable_project_variables","Profiles__enable_release_notes_notifications","Profiles__enable_complete_playlist_endpoint","DevPro__enable_cloud_innovators_plus","TpcFeatures__enable_unmirrored_page_left_nav","MiscFeatureFlags__enable_variable_operator_index_yaml","Profiles__enable_developer_profiles_callout","Concierge__enable_key_takeaways","Cloud__enable_cloudx_experiment_ids","Search__enable_suggestions_from_borg","Cloud__enable_legacy_calculator_redirect","MiscFeatureFlags__enable_explain_this_code","Concierge__enable_concierge","Cloud__enable_cloud_dlp_service","Search__enable_ai_search_summaries","MiscFeatureFlags__developers_footer_dark_image","Profiles__enable_public_developer_profiles","Analytics__enable_clearcut_logging","Search__enable_page_map","Search__enable_ai_eligibility_checks","TpcFeatures__enable_mirror_tenant_redirects","Experiments__reqs_query_experiments","Significatio__enable_by_tenant","Cloud__enable_free_trial_server_call","CloudShell__cloud_code_overflow_menu","Profiles__enable_stripe_subscription_management","Profiles__enable_dashboard_curated_recommendations","Cloud__enable_cloud_shell","BookNav__enable_tenant_cache_key","DevPro__enable_developer_subscriptions","Concierge__enable_pushui"],null,null,"AIzaSyBLEMok-5suZ67qRPzx0qUtbnLmyT_kCVE","https://developerscontentserving-pa.clients6.google.com","AIzaSyCM4QpTRSqP5qI4Dvjt4OAScIN8sOUlO-k","https://developerscontentsearch-pa.clients6.google.com",1,4,null,"https://developerprofiles-pa.clients6.google.com",[1,"developers","Google for Developers","developers.google.com",null,"developers-dot-devsite-v2-prod.appspot.com",null,null,[1,1,[1],null,null,null,null,null,null,null,null,[1],null,null,null,null,null,null,[1],[1,null,null,[1,20],"/recommendations/information"],null,null,null,[1,1,1],[1,1,null,1,1]],null,[null,null,null,null,null,null,"/images/lockup-new.svg","/images/touchicon-180-new.png",null,null,null,null,1,null,null,null,null,null,null,null,null,1,null,null,null,"/images/lockup-dark-theme-new.svg",[]],[],null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,[6,1,14,15,20,22,23,29,32,36],null,[[null,null,null,[3,7,10,2,39,17,4,32,24,11,12,13,34,15,25],null,null,[1,[["docType","Choose a content type",[["Tutorial",null,null,null,null,null,null,null,null,"Tutorial"],["Guide",null,null,null,null,null,null,null,null,"Guide"],["Sample",null,null,null,null,null,null,null,null,"Sample"]]],["product","Choose a product",[["Android",null,null,null,null,null,null,null,null,"Android"],["ARCore",null,null,null,null,null,null,null,null,"ARCore"],["ChromeOS",null,null,null,null,null,null,null,null,"ChromeOS"],["Firebase",null,null,null,null,null,null,null,null,"Firebase"],["Flutter",null,null,null,null,null,null,null,null,"Flutter"],["Assistant",null,null,null,null,null,null,null,null,"Google Assistant"],["GoogleCloud",null,null,null,null,null,null,null,null,"Google Cloud"],["GoogleMapsPlatform",null,null,null,null,null,null,null,null,"Google Maps Platform"],["GooglePay",null,null,null,null,null,null,null,null,"Google Pay & Google Wallet"],["GooglePlay",null,null,null,null,null,null,null,null,"Google Play"],["Tensorflow",null,null,null,null,null,null,null,null,"TensorFlow"]]],["category","Choose a topic",[["AiAndMachineLearning",null,null,null,null,null,null,null,null,"AI and Machine Learning"],["Data",null,null,null,null,null,null,null,null,"Data"],["Enterprise",null,null,null,null,null,null,null,null,"Enterprise"],["Gaming",null,null,null,null,null,null,null,null,"Gaming"],["Mobile",null,null,null,null,null,null,null,null,"Mobile"],["Web",null,null,null,null,null,null,null,null,"Web"]]]]]],[1,1],null,1],[[["UA-24532603-1"],["UA-22084204-5"],null,null,["UA-24532603-5"],null,null,[["G-272J68FCRF"],null,null,[["G-272J68FCRF",2]]],[["UA-24532603-1",2]],null,[["UA-24532603-5",2]],null,1],[[13,10],[6,5],[15,12],[12,9],[4,3],[3,2],[1,1],[16,13],[14,11],[11,8],[5,4]],[[2,2],[1,1]]],null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"developers.devsite.google"],null,"pk_live_5170syrHvgGVmSx9sBrnWtA5luvk9BwnVcvIi7HizpwauFG96WedXsuXh790rtij9AmGllqPtMLfhe2RSwD6Pn38V00uBCydV4m",1]') </script> <devsite-a11y-announce></devsite-a11y-announce> </body> </html>

CINXE.COM

REST Resource: spreadsheets | Google Sheets | Google for Developers