For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).
|3||Elmer Fudd||Chasing Rabbits||Elmer.png|
You may add multiple worksheets such as 'Looney Tunes', 'The Simpsons' to seperate different categories of data.
sheet2api will create an API endpoint for each of these automatically.
Click the button below to view detailed documention on how to make HTTP requests to your Spreadsheet API.
By default when you create your API, all operations will be allowed: Read, Create, Update & Delete.
You may want to limit what's possible, for example only allow reading of data from your API.
To do this go to Your Account page, locate your Spreadsheet API from the list and click "Configure API".
On the next page, under "API Permissions", adjust which operations you'd like enabled, and click "Save".
If you have configured your API to require authentication then all requests will need to include an Authorization header.
The credentials are constructed like this:
The username and the password are combined with a colon (
The resulting string is base64 encoded (
That string should when be included within the Authorization header:
Authorization: Basic YWxhZGRpbjpvcGVuc2VzYW1l