# CData Connect Spreadsheets - Google Sheets Timeout Error - solution?

**URL:** <https://community.cdata.com/t/cdata-connect-spreadsheets-google-sheets-timeout-error-solution/1159>\
**Category:** CData Connect AI\
**Tags:** connect-spreadsheets, timeout-error, discussion, google-sheets\
**Created:** [August 8, 2025, 2:47pm UTC](https://community.cdata.com/t/cdata-connect-spreadsheets-google-sheets-timeout-error-solution/1159 "2025-08-08T14:47:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JDB](https://avatars.discourse-cdn.com/v4/letter/j/ee59a6/32.png) [@JDB](https://community.cdata.com/u/JDB)\
**Post date:** [August 8, 2025, 2:48pm UTC](https://community.cdata.com/t/cdata-connect-spreadsheets-google-sheets-timeout-error-solution/1159/1 "2025-08-08T14:48:20Z")

</div>

After wrestling with this issue to download / refresh over 140k rows of data daily I believe the problem is pivot tables embedded in the same workbook.&nbsp; After downloading data and creating pivot tables the data would time out on any overwrite or refresh.&nbsp; But…. if I use Queries then the issue does not seem to occur.

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [August 18, 2025, 2:43pm UTC](https://community.cdata.com/t/cdata-connect-spreadsheets-google-sheets-timeout-error-solution/1159/2 "2025-08-18T14:43:31Z")

</div>

HI ​ @JDB

To better understand why the Timeout is being thrown we would first need to verify if the timeout is being thrown by the source service or at the Connect Spreadsheets level. That being said would you be able to elaborate more on the exact error message you are seeing?

Additionally, did you have a chance to set up logging for the connection failing with the Timeout error? If not could you set up logging for the connection and review the logs to gather any insights on the failure?

> **[Google Sheets - CData](https://docs.cloud.cdata.com/en/Clients/GoogleSheets-Client)**
>
> This page outlines the steps to install and configure the CData Connect Spreadsheets add-on for Google Sheets. After installation, Google Sheets is able to pull data from sources that you have connected to your CData Connect Spreadsheets account.