function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Elie RodrigueElie Rodrigue 

Google Data API - Read Timeout

Sometime, when we try to read or write multiple cells value in a google spreadsheet we often get timeouts. We read the cells using getFeedRange and write using updateCells. We are using large range to read and write (~75 cells at a time) which could cause this problem, but can't avoid this as we are already on our 10 callouts limits.

 

 

The request timeout is already set at 60 seconds.

 

It seems like the timeout occurs at random on any calls to google service : it happened on getSpreadsheetsTitle , getWorksheetFeedUrl, getFeedRange and updateCells...

 

Is there any to diagnose this properly? What could cause this problem?