> For the complete documentation index, see [llms.txt](https://bitpicky.gitbook.io/sheetwork/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://bitpicky.gitbook.io/sheetwork/usage/sheet-configuration/basic-configuration.md).

# Basic Configuration

### Basic Configuration

A basic sheet.yml file looks like this

```yaml
sheets:
  - sheet_name: test_sheet
    sheet_key: 10J52dhgTRqtI_lm4bf9B02nQu4zu5u6r0h2VIDTjRXg
    target_schema: sandbox # this will override the profiles.yml entry
    target_table: bb_test_sheetwork
```

As you can see it is a list of sheets with a `sheet_name` a `sheet_key` and some other controls such as object creation locations and column operation. This is pretty much the bare minimum.

#### How to populate this information?

* `sheet_name`: this is the name by which you'll want to refer to your sheet. It can be anything you like and doesn't have to be the google sheet name. We will refer to the sheet using the sheet\_key as it's less error prone
* `sheet_key:` this is a unique key automatically created for every sheet by google. It's easy to spot, when you have your sheet opened, if you look at the URL it will be something like that. In the example below the key is `10JJdwwd_lm4556uwedu4zu5u6r0h2VIDTjRXg` it always follows the `/d/` and precedes the `/edit` part.

```
https://docs.google.com/spreadsheets/d/10JJdwwd_lm4556uwedu4zu5u6r0h2VIDTjRXg/edit#gid=0
```

* `target_schema:` This one is optional if you set up a `target_schema` in your project file. If you did not, or you want to override the default you can just specify it here!
* `target_table:` This will be the name of the table in which sheetwork will push your data from the sheet.

The **sheet-level controls reference** will go into more details.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://bitpicky.gitbook.io/sheetwork/usage/sheet-configuration/basic-configuration.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.