It would be very nice to have the retry logic. I have a large spreadsheet with many worksheets, and cannot read it without hitting a rate limit.

Here is my workaround, in case it helps someone while there is no native support for rate limits in the module:

      //  Very rough ad-hoc implementation of https://developers.google.com/sheets/api/limits
      const maxBackoff = 32000;
      const maxRetries = 16;
      let retryNumber = 0;

      async function tryDownloadAsCSV(): Promise<ArrayBuffer> {
        return await sheet.downloadAsCSV().catch(async (e: AxiosError) => {
          if (e.response?.status !== 429) {
            throw e;
          }

          if (++retryNumber > maxRetries) {
            throw e;
          }

          const delay = Math.ceil(Math.min(maxBackoff, 100 + Math.pow(2, retryNumber) * 100) + Math.random() * 100);

          console.log(`[${retryNumber} / ${maxRetries}] got 429 from Google Sheets, waiting for ${delay} ms`);

          return new Promise(resolve => setTimeout(() => {
            resolve(tryDownloadAsCSV());
          }, delay));
        });
      }

      const buffer = await tryDownloadAsCSV();

Uh oh!

Check API status / Automated retry logic #418

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions