Benchmark concurrent reads for a single Google Spreadsheet via multiple App scripts

user_3583595 0
Viewed 139

I have one Google Spreadsheet and I want to read that spreadsheet from multiple Google Apps Scripts (100+ scripts and 10,000+ users).

I'm not talking about Google Apps Script Benchmarks.

Is there a concurrent read limitation for a single spreadsheet via multiple Google App Scripts ?

google-apps-script google-sheets-api google-sheets performance
1 Answers
  • Apps Script quota do no mention such a limit
  • Also, Apps Script quota count per project / user - not per document

However, there is a limit coming from Google Drive:

Up to 100 people can edit and comment at the same time.

More than 100 people can view a file, though it’s easier to publish the file and create a link.

So, if the script not only reads,b ut also edits the spreadsheet - possibly it cannot be accessed by more than 100 users simulateneously.

Also, if several users run the same script:

  • Apps Script has a limit for simultaneous script executions
user_115997890
Related