CODEWITHSUNDEEP
google-apps-scriptgoogle-apigoogle-sheetsgoogle-sheets-api
David
David

Reputation: 5016

Quotas or limits of Google Spreadsheets API v 3.0

I am considering using Google Spreadsheets and Google Apps Scripts for our business rules, given that Spreadsheets will make the business rules available and editable to non-technical employees.

My concern is about all the quotas that apply to Google Apps Scripts, as these also might change in the future, and there is no way to upgrade to a "premium" with more liberal quotas.

As a fall-back I am considering using the Google Spreadsheets API, and I assume that there are also quotas on this API, but I cannot find them anywhere. Does anyone know them? Or has anyone hit these quotas?

I am also trying to get some sort of idea of whether it is indeed a good idea to put the business rules in Google Spreadsheets in my question here.

Upvotes: 1

Views: 2882

Answers (1)

Cyrus Loree
Cyrus Loree

Reputation: 847

There is an Apps Script Dashboard which identifies any service disruptions, as well as a tab for a breakdown of quotas, based on your Google Apps account type.

Google Apps Script Dashboard

From a quick skim of your posting on StackExchange, one thing to be mindful of is the email quota (1500 total recipients per account each day). You may be able to offset this hurdle (if applicable) using Google Groups, either by creating predefined groups, or programmatically building groups using Advanced Google service in Apps Script (at least for internal communications; direct add accounts for external addresses require a welcome message).

I'm not familiar with Ultradox, but using Apps Script, you can populate Google Doc "Template" files, convert them to PDF, and attach in Gmail (or provide the share link), right from Apps Script.

Upvotes: 2

Related Questions