# Google Sheets

### :clipboard: *Steps to Schedule any Report to Google Sheets*

1. **Open** the report that needs to be scheduled.
2. **Click** the **Schedule** button.
3. **Select** how often you want to run the report like **Hourly**, **Daily**, **Weekly,** or **Monthly**, and proceed to the next step. **Click** the **button**.
4. **Pick** the **date** & **time** when the reports need to be delivered.
5. **Click** on the **Google Sheets** tab and then, **click** on **Connect**.
6. **Select** your Google account and **click** on **Allow** to grant permission to Report Pundit.

{% 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 %}

![](https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2F2ZC36aOqbphVZnQR4RoU%2FRPg1.png?alt=media\&token=d8c00b44-43bd-4e21-9955-4ff4feafded4)

![](https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FHGa6Tkca86dRf5WbCmPb%2FRPG2.png?alt=media\&token=a2837849-a286-411b-adbf-5182b2a9ed50)

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 on **Save** to complete the schedule setup.

{% embed url="<https://youtu.be/QT41s8g-vSw>" %}

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