# 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