Q: Is this for unlimited use, so I can use this in multiple GSheets projects?
Can I used it on multiple GSheets in multiple (different) G accounts?
Does Google impose any limits on the requests (either AI() function or API () function)?
I’m assuming the with the API() function I can GET data from any REST API and even POST data, correct?
Any limits we must consider?
Wei_Sheng
May 15, 2024A: Hi, thanks for your questions. Here are my answers.
Is this for unlimited use, so I can use this in multiple GSheets projects?
Yes, the add-on itself doesn't have any limit on your usage, but the AI formula is subject to OpenAI's fees. And yes, you can use it in multiple Google Sheets documents/projects.
Can I used it on multiple GSheets in multiple (different) G accounts?
This is only possible if you personally own the extra Google account. For example, if you have a Gmail account(gmail.com) and a Google Workspace account (@yourcompany.com), you can activate your LTD with one account and send us a message to request to add the other account to your license for free.
Does Google impose any limits on the requests (either AI() function or API () function)?
Yes, Google Sheets itself has a service quota which roughly allows you to make 20,000 API/AI calls per day of you have a Gmail account and 100,000 if you have a Google Workspace account.
I’m assuming the with the API() function I can GET data from any REST API and even POST data, correct?
Yes, you can both GET data from an API and send the data from Google Sheets to an API using POST. If you want to POST data, you can use =CONCATENATE() to combine your data into a request body. This is very easy to do with our formula builder UI.
Any limits we must consider?
Please take a look at the Google Service quota (https://developers.google.com/apps-script/guides/services/quotas) and OpenAI fees. Other than that, Power Formulas doesn't have any limit of usage.
Please let me know if you have any follow-up questions!
Wei