# integration-google-sheets (Google Sheets)

You can run this example with:

```bash
npx promptfoo@latest init --example integration-google-sheets
cd integration-google-sheets
```

## Usage

This example shows how to use an external Google Sheet to run tests. To get
started, set your OPENAI_API_KEY environment variable.

Next, duplicate the Google Sheet in promptfooconfig.yaml and replace the URL.

Public sheet imports work without extra packages. Private sheet reads and Google Sheets output writes use the optional authenticated Sheets dependency:

```bash
npm install promptfoo @googleapis/sheets
```

Then run:

```bash
npx promptfoo eval
```

Afterwards, you can view the results by running `npx promptfoo view`