title: google sheet method: spreadsheets.get ... how to get field?
body: <p>I'm trying to get all of the <code>backgroundColor</code> for a specific range on a sheet. It is nested pretty deeply inside the json.</p>
  <p>It seems like you can't just specify a field with get. <a href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get" rel="nofollow noreferrer">https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get</a></p>
  <p>So you have to get the grid data and navigate through the json.</p>
  <p>Is that correct? Is that the only way to do it? Must I loop through each <code>rowData</code> and <code>values</code>?</p>
  <pre><code>response = service.spreadsheets().get(spreadsheetId=key, ranges=range_, includeGridData=True).execute()
  
  response.get('sheets')[0].get('data')[0].get('rowData')[0][&quot;values&quot;]
  </code></pre>