# Google Sheets Connector

## How to export data to Google Sheets?

1\. Click the export button on the top right of the table. 

![](/files/xJYy0eLxYZMWOEatWQdL)

2\. Select **Google Sheets Connector** and click **Generate API**.

![](/files/iDLvvul9kHGQ9LsGbekp)

{% hint style="info" %}
Notice that Google Sheets can only support importing a table with up to 2.15 MB via API. You can check the table size by clicking the **Table Info** button next to the **Export** button. If your table is too large to export, you can use [Filter](/acho-studio/data-prep-projects/applying-actions/view/filter.md) or [Cut](/acho-studio/data-prep-projects/applying-actions/view/cut.md) to shrink your table size.
{% endhint %}

3\. When the API is generated successfully, a green message will pop up from the top of the page. The Excel connector API will be copied to your clickboard automatically

![](/files/S4owRcMhGsuvQcOokJOW)

4\. Open your Google Sheets and type `IMPORTDATA()` in the first cell. Remember to put the API that you just generated within the brackets. 

![](/files/m8iqCagCT8j2QLZhEFbz)

5\. Then, your data will show up in your Google Sheets. By default, Google Sheets will retrieve data from Acho every hour and refresh the entire dataset automatically. (Notice that every time Google Sheets request data from Acho via API, the request is also metered for usage.)

![](/files/serSTZEzfqBndNSYQsgE)

If you encountered the following error. Please try to export fewer rows. Google Sheets has a limit for the size of the imported table. (The limit is around 2.15 MB)

![](/files/-MHY7dvhTxkOTkoA8Lea)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.acho.io/acho-studio/data-flow/export-data/export-to-google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.