CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet

Ask for Help
5

Sometimes Google Sheets will slow us down, limiting us to 1 action every few seconds. To avoid this:

  1. Use Glide Tables — we don’t have any limits on actions here
  2. Google has a quota per Google Account for how often you can update a Google Sheet each minute, so if you have many apps connected through the same Google account, these are all sharing the quota. So, if you have apps for 100 different clients under your My Apps, these are all sharing a single update quota tied to your Google account. If you can use your client’s Google account (e.g. have them create the initial app from the sheet), they will get their own quota

We are working on:

  1. Making it easier to replace a Google Sheet with a Glide Table without rebuilding your app
  2. Batching actions sent to your Google Sheet, so 100 actions could run at once, for example
  3. Always improving the performance of Glide Tables

Update

We have a new batch action processor, which should give a throughput of 50 actions per second.

23 Likes