Get Value of a Single Cell

Richard O'Dwyer

We're excited to announce a powerful new addition to our spreadsheet API - the ability to retrieve the value of a single cell using just its coordinates! This highly requested feature allows you to quickly fetch the contents of a specific cell without having to retrieve the entire sheet or row.

It streamlines your code and reduces unnecessary data transfers, improving performance. To use this endpoint, simply make a GET request to the following URL, replacing Looney Tunes with your sheet name and A1 with the cell coordinates:

https://sheet2api.com/v1/0kjuFCLSxW1e/characters/Looney%20Tunes/cells/A1

{
  "A1": "Hello, World!"
}

var cell = 'A1';
fetch(`https://sheet2api.com/v1/0kjuFCLSxW1e/characters/Looney%20Tunes/cells/${cell}`)
  .then(response => response.json())
  .then(data => console.log(data))
  .catch(error => console.error('Error:', error));