title: Question about using API to retrieve cell data
body: <p>I’m wondering if someone could help me figure out a little issue I’m having. I’m trying to create an iOS shortcut to retrieve specific cell data from a Google Sheets document, and I’m really close, however, I’m hitting this snafu.</p>
  <p>For my example, the data entered into the specific cell is: “0+ 5” (without the quotes).</p>
  <p>I’m using the following URL to grab the data (with my string ID and API keys X’d out):</p>
  <blockquote>
  <p><a href="https://sheets.googleapis.com/v4/spreadsheets/XXXXXXXXXX/values/Sheet1!D#?key=XXXXXXXXXXXXXXXXX" rel="nofollow noreferrer">https://sheets.googleapis.com/v4/spreadsheets/XXXXXXXXXX/values/Sheet1!D#?key=XXXXXXXXXXXXXXXXX</a></p>
  </blockquote>
  <p>(Also, the <strong>#</strong> character after “Sheet1!D” is purposeful….I have shortcuts configured to replace that character with a number I input when running the shortcut)</p>
  <p>Anyway, the result I’m getting is:</p>
  <blockquote>
  <p>{&quot;range&quot;:&quot;Sheet1!D99&quot;,&quot;majorDimension&quot;:&quot;ROWS&quot;,&quot;values&quot;:[[&quot;0+  5&quot;]]}</p>
  </blockquote>
  <p><em>Notice the “0+ 5” near the end, which is the data entered in the specific cell.</em></p>
  <p>I know I can mess around with Regex to to have the shortcut specifically match that part of the text, but I’m assuming there’s a way to format the API URL so that it <em>only</em> gives me the data entered — in this case, <strong>only</strong></p>
  <blockquote>
  <p>0+ 5</p>
  </blockquote>
  <p>and not all of the other info….am I correct in that assumption? If so, I’d rather go that route and have the shortcut be a bit less convoluted.</p>
  <p>Thanks!</p>