Read from Google Sheets
PORT
: the port to listen onAPI_KEY
: the Google API key to use
POST to your-host:port/
with
{
"doc": "[Google Sheets document ID from URL]",
"sheet": 0, #index of the sheet to read from (0-indexed)
"range": "A1:B4" #range to read
}
The response will be a JSON array-of-arrays representing the range requested
- Add ability to write to sheets with service accounts