# Google Sheets

## :clipboard: *Steps to Schedule Reports to Google Sheets*

1. **Open** the report that needs to be scheduled.
2. **Click** the ![](/files/NZdGZiP2Em8obDJ1zzFl) button.

<figure><img src="/files/pVGMx0D4UWMIfSriYz9Q" alt=""><figcaption></figcaption></figure>

3. **Select** how often you want to run the report like **Hourly**, **Daily**, **Weekly**, or **Monthly**, and **proceed** to the **next step**. **Click** on **Save and continue.**
4. **Pick** the **date** & **time** when the reports need to be delivered. **Click** on **Save and continue.**
5. **Click** on the **Google Sheets** tab and then, **click** on **Connect.**

<figure><img src="/files/qidgH1z9ifhg4f4oL8Hw" alt=""><figcaption></figcaption></figure>

6. **Select** your **Google account** and **click** on **Allow** to grant permission for **Data Export**.

{% hint style="info" %}
**Note:** We are only permitted to view the folder structure of your Google Drive, in order to select the folder in which the Google Sheet would be delivered. We do not have visibility or access to the contents of your Google Drive.
{% endhint %}

![](/files/-Ma2oOVr3Rnewwfa17Md)

7. **Select** the **Google Drive folder** in which you wish to receive and store the report.
8. **Enter** the **file name** and **Sheet title**.
9. **Choose** to **Append, Add Sheets** or **Overwrite** your report data.

* **Append:** adds the new data at the end of previous report data.
* **Add Sheets:** adds new data in a separate sheet in the same file.
* **Overwrite:** Overwrites the previous report data and replaces it with the new report data.

10. **Finally,** click the **'Save and Continue'** button to complete the **schedule setup**.

{% hint style="success" %}
:star2: That's it!. You have scheduled your reports to Google Sheets like a Pro!
{% endhint %}


---

# 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.dataexport.io/kb/scheduler/output-options/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.
