# 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     | email           |
| 2 | 1  | John Doe | john@email.com  |
| 3 | 2  | Mary     | mary@email.com  |

## 2. Connecting in Dashboard

When creating a new project:

1. Click on "New Project".
2. A Google window will open asking to select a file.
3. Choose the desired spreadsheet.
4. 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).

[Next: Use API Endpoints →](/content/docs/api/endpoints/index.html)
