Relative Content

Tag Archive for google-apps-scriptgoogle-workspace

Service invoked too many times in a day: urlfetch

Today suddenly my app script stopped working with the message “Service invoked too many times in a day: urlfetch” though I haven’t reached the daily limit yet. I’ve checked the execution logs & dashboard & there are only less than 100 executions.

Service invoked too many times: Calendar error

Service called too many times: Calendar error occurred
I couldn’t upload the schedule to Google Calendar.
Which service is over-allocated and causes an alarm like this
Please check how we can solve it

Google Apps Script Mail Merge not working with Trigger

I have this Google Apps Script that I have modified and added and removed things over the months, I am trying to run “sendEmails” automatically but I keep getting this error (shown below, along with entire script) It works fine if I run it manually in the dropdown. This is for our car dealership, this is how we let the service department know a traded in vehicle is ready for them to service, works great but I always have to run it a few times a day.

onEdit event triggers when a row is deleted

I am using onEdit trigger in Google Sheet to send an email notification based on cell changes with certain conditions. That works fine, but the trigger also fires when a row is deleted and I get an error that the cells are undefined because of course the row was deleted. Is there a way to catch that event within onEdit? I know that I could use onChange as well, but would the onEdit event fire anyways?
Thanks for any tips.

How do I stop these messages?

How do I stop these messages? I have not used this for years and I do not see where to resolve. I click on the “click here” and it says that I have no triggers set up.

Google Workspace sandbox environment

I’d like to test a Google Apps Script that I’m building and I’m looking for a place to test it. It’s a script that will be executed by a service account and collecting information on users in an OU.