> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/endash-export-to-google-sheets/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/endash-export-to-google-sheets/export-to-google-sheets/authorize-google-account-to-export-to-google-sheets.md).

# Authorize Google Account to export to Google Sheets

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FX9eOvimWKiAiGIunXvrP%2Fimage.png?alt=media&amp;token=92a5ab82-e8f0-48a3-87b8-64cf401f10be" alt="" width="563"><figcaption></figcaption></figure>

* Click on the Authorize Google Account option and the Select dropdown to begin.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2Fr85sppBAPJ4IiePEhETk%2Fimage.png?alt=media&amp;token=cdf27003-f74a-4d9b-a701-d28f726bc3e4" alt=""><figcaption></figcaption></figure>

* You will be asked to authorize our service to your Google Drive.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FgOTRUmzTLnX6FGBIGlMP%2Fimage.png?alt=media&amp;token=4d70b7c7-98ae-4935-b6fc-f526247d0428" alt=""><figcaption></figcaption></figure>

* After that you can choose to Create new sheet or use exisiting sheet.

{% hint style="info" %}

* With Create new sheet option, you have to choose a folder.
  {% endhint %}

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FKPyftQPNK6SsdFVBOorG%2Fimage.png?alt=media&amp;token=eca24955-5e95-44d8-991e-18994401c429" alt=""><figcaption></figcaption></figure>

* You can choose which Sheet in that Google Sheets.
* The Continue button shall be active if permission is granted.&#x20;

{% hint style="info" %}
To start over, just click on the Authorize Google Account again.
{% endhint %}

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FW1mnvNID1YmEgWbesIKb%2Fimage.png?alt=media&amp;token=377e12ae-c3bc-4292-89ea-1ae6cc81d91d" alt=""><figcaption></figcaption></figure>

* Click on the checkbox(s) button to select the column to be exported.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FGtL6Vak4a7qmWwrUwAee%2Fimage.png?alt=media&amp;token=5758c0c6-dcd9-48b0-8ae8-2e35d7b5be1c" alt="" width="563"><figcaption></figcaption></figure>

* You can choose between the Add and Replace option.
* Replace is a default option.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FqhVRrDK7MU91lZPCuneB%2Fimage.png?alt=media&amp;token=d8aeeb58-cd02-4ead-abbf-8b756df57f83" alt="" width="563"><figcaption></figcaption></figure>

* You can [Filter ](https://endash-guidance-docs.gitbook.io/docs/dashboard/widget-types/table/table-filter)and [Sort](https://endash-guidance-docs.gitbook.io/docs/dashboard/widget-types/table/table-sort) to customize your data.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FsmFxWe1MRhsPnP4TIm0E%2Fimage.png?alt=media&amp;token=dda8641b-66b5-4632-997b-1b1344eff96a" alt="" width="563"><figcaption></figcaption></figure>

* You can further customize the exported table by settings the Limit row(s) and Header row.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FFyXifrZxHCBM1DpvW1Bq%2Fimage.png?alt=media&amp;token=ab9f309b-e4a3-49ff-8607-d5b0bfb59670" alt=""><figcaption></figcaption></figure>

* Click the View button to see the to-be-exported Table.
* Click on the Finish button to complete the process.

<figure><img src="https://1903595971-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fyj27U2mcGJB6ec2TNYzM%2Fuploads%2FlQUEIA9BDewwMcFv01fw%2Fimage.png?alt=media&amp;token=96c44409-0b11-4c8a-b50e-270dc79dd6d0" alt=""><figcaption></figcaption></figure>

* Your data will be auto-exported the first time.
