Connect Sheets
The core of Sheetful is the ability to turn any Google Sheet into a structured API. Follow the best practices below to ensure optimal performance.
1. Spreadsheet Structure
For the API to work correctly, your spreadsheet must follow a simple structure:
- Row 1 (Header): Must contain the keys of your API (e.g. "name", "email", "age"). Avoid spaces or special characters.
- Rows 2+ (Data): Where the records are. Each row will be an object in the JSON response.
| A | B | C | |
|---|---|---|---|
| 1 | id | name | |
| 2 | 1 | John Doe | john@email.com |
| 3 | 2 | Mary | mary@email.com |
2. Connecting in Dashboard
When creating a new project:
- Click on "New Project".
- A Google window will open asking to select a file.
- Choose the desired spreadsheet.
- Set a name for your API (e.g. "customers").
3. Working with Tabs
If your spreadsheet has multiple tabs, you can specify which tab the API should read. By default, Sheetful reads the first tab (Sheet1).