Harit Himanshu
Oct 15, 2019, 9:05:32 AM10/15/19
to Google Apps Script Community
Hello Community,
I am new to App Script (just discovered yesterday)
I wanted to know if App Script is FREE to use for personal google accounts (not GSuite). And if there are any limitations on the personal google accounts related to any features of App Scripts.
Can someone please help with this?
Thank you
+ Harit Himanshu
anne marie Gay
Oct 15, 2019, 9:22:50 AM10/15/19
to google-apps-sc...@googlegroups.com
Absolument Google apps Script est gratuit meme en version Gmail Classique
Les Limites d'appels quotas :
Bonne journée
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7e25bca7-1a86-4371-afff-ad7560112662%40googlegroups.com.
|
|
||||
Alan Wells
Oct 15, 2019, 9:26:45 AM10/15/19
to Google Apps Script Community
There is no cost to use Apps Script. Consumer / free accounts can only send an email to 100 recipients per day. That's one of the limits that people often hit if you're trying to use a consumer account for business, or other than personal use. Another quota limit that people hit is the "Script runtime." For example if you need to process 1000's of rows in a spreadsheet.
A consumer account can't send an email as being FROM an alias. People often want to do that in order to not expose their business email address, or manage what emails are used for what purpose. A consumer account can still use No Reply or Reply To.
You can use the APIs and create a standard Google Cloud Project for a free / consumer account.
So, if you are just exploring Apps Script, just use a free account. If you want to publicly publish an add-on, I'd get a G Suite account.
Harit Himanshu
Oct 15, 2019, 11:29:05 AM10/15/19
to Google Apps Script Community
Thank you very much
One thing in the limits that is not clear to me is
- How many record read/write can happen on a single spreadsheet in classic gmail?
- There is a limit on number of triggers - 20/user/script, but is there a limit on how many events can it generate? For example, I have 1 trigger that runs every minute. Does that mean 1 trigger can run 1140 (60*24) times?
Does anyone know?
On Tuesday, October 15, 2019 at 6:22:50 AM UTC-7, anne marie Gay wrote:
Absolument Google apps Script est gratuit meme en version Gmail ClassiqueLes Limites d'appels quotas :Bonne journée
Le mar. 15 oct. 2019 à 15:05, Harit Himanshu <harit.sub...@gmail.com> a écrit :
Hello Community,--I am new to App Script (just discovered yesterday)I wanted to know if App Script is FREE to use for personal google accounts (not GSuite). And if there are any limitations on the personal google accounts related to any features of App Scripts.Can someone please help with this?Thank you+ Harit Himanshu
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7e25bca7-1a86-4371-afff-ad7560112662%40googlegroups.com.
Dimu Designs
Oct 15, 2019, 11:41:40 AM10/15/19
to google-apps-sc...@googlegroups.com
You can populate a maximum of 5,000,00 cells per google spreadsheet file; where the sum of all cells used in file cannot exceed that number.
Note about triggers for consumer accounts: the max execution time a script can run is 6 minutes and the cumulative period (total time) scripts can run per day per account is 90 minutes. Excessive use of triggers can exhaust those quotas.
And if you're thinking of using a google sheet as a database for large datasets you may want to read the article linked below:
Harit Himanshu
Oct 15, 2019, 1:52:53 PM10/15/19
to google-apps-sc...@googlegroups.com
Thanks for the detailed response.
So , this means that total of 90 min/day/account (and not per script) is allowed for a user. With in this the there could be 90*60 = 5400 1-second triggers can run (ideally), is that correct?
Thanks
+ Harit Himanshu
On Tue, Oct 15, 2019 at 8:41 AM Dimu Designs <dimud...@gmail.com> wrote:
You can populate a maximum of 5,000,00 cells per google spreadsheet file; where the sum of all cells used in file cannot exceed that number.Note about triggers for consumer accounts: the max execution time a script can run is 6 minutes and the cumulative period (total time) scripts can run per day per account is 90 minutes. Excessive use of triggers can exhaust those quotas.
And if you're thinking of using a google sheet as a database you may want to read the article linked below:
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5156d006-1bfa-4dd9-a010-1b8ee7d20c19%40googlegroups.com.
Dimu Designs
Oct 15, 2019, 8:15:23 PM10/15/19
to Google Apps Script Community
You can't have 1 second triggers. The lowest interval possible for triggers is one minute.
Harit Himanshu
Oct 21, 2019, 9:24:06 AM10/21/19
to google-apps-sc...@googlegroups.com
Yes, that makes sense
Thank you
On Tue, Oct 15, 2019 at 5:15 PM Dimu Designs <dimud...@gmail.com> wrote:
You can't have 1 second triggers. The lowest interval possible for triggers is one minute.
--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/e6d679fb-cc52-4f59-a055-ee9d11a23beb%40googlegroups.com.
Chris Larkin
Oct 22, 2019, 1:20:31 PM10/22/19
to Google Apps Script Community
Harit -
Welcome to Apps Script - I'm a fan of your posts and it's a cosmic mystery that I was just reading you on Medium and then I see your question here!
I've gotten deep into Apps Script since last year, and I've found it to be incredibly powerful automating tasks that really are a waste of our time, in the sense that we don't want to pay a senior engineer or analyst to copy and paste, make reports, etc., and I'm easily bored with those repetitive tasks so I love automating them and focusing on big picture efforts to help my clients be most successful.
:-)
On Monday, October 21, 2019 at 8:24:06 AM UTC-5, Harit Himanshu wrote:
Yes, that makes senseThank you
On Tue, Oct 15, 2019 at 5:15 PM Dimu Designs <dimud...@gmail.com> wrote:
You can't have 1 second triggers. The lowest interval possible for triggers is one minute.--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-community+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages