> For the complete documentation index, see [llms.txt](https://pathta.gitbook.io/pathta-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://pathta.gitbook.io/pathta-docs/reporting/see-your-data-on-google-sheet-with-the-pathta-addin.md).

# See your data on Google Sheet with the Pathta Addin

{% hint style="info" %}
The Pathta Google Sheet add-in lets you retrieve your data into Google Sheet tables in just a few clicks. \
Data refresh can be scheduled to display dynamic dashboards.
{% endhint %}

{% stepper %}
{% step %}

### <mark style="color:red;">STEP 1</mark>

Create one reporting Path and copy the token from reporting Path checking tab
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 2</mark>

Open Pathta Google Sheet Addin and paste the token to sign in
{% endstep %}

{% step %}

### <mark style="color:red;">STEP 3</mark>

Select one or more paths and click on Import
{% endstep %}
{% endstepper %}

## 1. Create a reporting path and copy the token

See [here ](/pathta-docs/reporting/create-a-reporting-path.md)how to create a reporting Path.\
Copy the token started with PAT

## 2. Open Pathta Google Sheet Addin

Open Pathta Excel Addin and paste the token to sign in.

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2FFTMMrjCFQZFQ1P7HNaTU%2Fimage.png?alt=media&amp;token=51988a52-e827-44e3-9da1-020742febe01" alt=""><figcaption></figcaption></figure>

## 3. Add one or mode tabs

Select one or more tabs corresponding to the data you want to retrieve.\
You will see in the the list all your reporting path.

Click on add to import to get data. You can check Auto-refresh if you want to refresh all your data automatically.

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2FB2GkrAHCBROSsoaOnVey%2Fimage.png?alt=media&amp;token=422e25d2-19a5-4da0-ba1f-f6841d61a8a1" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1039087027-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKMgBZ3wq0SUPGSqOmR9C%2Fuploads%2F4dzQv4lKn8Sg7e70JrHI%2Fimage.png?alt=media&amp;token=929e28b2-eab4-46ed-a549-0a29c7ae3171" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
A tab is created containing a table for each selected path. \
All tables will be cleared during the next refresh/Import
{% endhint %}