sheet2api logo Sign in

characters - API Documentation

1. How to format your Spreadsheet

For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column names.
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).

For example:

A B C D E
1 Name Favourite Thing Image
2 Bugs Bunny Carrots Bugs.png
3 Elmer Fudd Chasing Rabbits Elmer.png
4
Looney Tunes
The Simpsons
Sheet3

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.


2. Making Requests

The base URL for all requests is https://sheet2api.com/v1/FgI6zV8qT121/characters/. This URL will return data from the first Sheet of the Spreadsheet.

Need help? Email support now.

3. Authentication

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 (aladdin:opensesame).
The resulting string is base64 encoded (YWxhZGRpbjpvcGVuc2VzYW1l).
That string should when be included within the Authorization header:

Authorization: Basic YWxhZGRpbjpvcGVuc2VzYW1l