title: Google sheets unable to parse range
body: <p>I am posting the following (incomplete code) to Google sheets batch update values:</p>
  
  <p><code>{"valueInputOption":"USER_ENTERED","data":[{"range":"'Home Sheet'!B2:B2","values":[</code></p>
  
  <p>And for some reason I am getting:</p>
  
  <pre><code>{
    "error": {
      "code": 400,
      "message": "Invalid data[0]: Unable to parse range: 'Home Sheet'!B2:B2",
      "status": "INVALID_ARGUMENT"
    }
  }
  </code></pre>
  
  <p>However if you refer to <a href="https://developers.google.com/sheets/api/guides/concepts" rel="nofollow noreferrer">https://developers.google.com/sheets/api/guides/concepts</a> this clearly looks like the range is valid. Interestingly this is only in the Javascript not if I use the PHP sdk.</p>