"Service timed out: Spreadsheets" - Why it happens and how to fix it

Have you ever received this error when making queries in Google Sheets?

image_gti2tk

Don't worry, here's what causes it and how to fix it.

 

Why does this error happen?

This error comes directly from the Google Sheets servers, not from Dataslayer. It usually happens when the Google server has to do a lot of calculations, and fails to insert the data or process the document, either because it is a very large document, because there are many formulas in the document, very large queries, many sheets, etc.

 

How can I solve it?

To solve it, you have to minimize the processing load as much as possible.

To do this, we recommend that you make your query on a new empty sheet or in a new document, so that Google can correctly process and insert the data sent by Dataslayer into your sheet.

 

As always, please do not hesitate to contact us via our live chat on our website or via e-mail if you still have doubts or questions. We are happy to help!