> For the complete documentation index, see [llms.txt](https://engine.sygnal.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://engine.sygnal.com/usage/unit-testing/using-google-sheets-as-a-unit-test-data-source.md).

# Using Google Sheets as a Unit Test Data Source

* Create the Google sheet
* Column headings
* Make it readable by anyone with the link
  * Security ? 

e.g.

{% code overflow="wrap" %}

```
https://docs.google.com/spreadsheets/d/1DREayEscT7YyWCNQQLSkHjeVFi5bON1KODZxTIJQEnk/export?format=csv
```

{% endcode %}

## Advanced Sheet Setup

Sample data sheet 

Based on <https://docs.google.com/spreadsheets/d/1DREayEscT7YyWCNQQLSkHjeVFi5bON1KODZxTIJQEnk/export?format=csv>

ARRAYFORMULAS

Skip a row&#x20;

RANDOM data