All Questions
18 questions
0
votes
1
answer
104
views
How to Automatically Trigger a Webhook on New Row Addition in Google Sheets Using Google Apps Script?
I’m working on a feature where a client can link their Google Sheet to my system. Whenever a new row is added to the sheet, the system should send the new order data to a webhook. My initial approach ...
- 93
0
votes
0
answers
50
views
When do time-driven triggers initially go off?
I'm using time-driven triggers in my apps script to get it to run my code every 2 hours. The problem is that there are reasonably specific times I would like this to happen - it doesn't have to be ...
0
votes
1
answer
57
views
SyntaxError: missing ) after argument list (line : 13, file : Code.gs)
I am very new to coding, and I keep getting this error when trying to save my script.
Heres the code:
function myFunction() {
const calID = '*email*'
const cal = CalendarApp.getCalendarById(calID) ...
0
votes
1
answer
865
views
I can't make changes to a specific Instance of a recurring event in Google Calendar
I am utilizing an Apps Script code to synchronize Google Calendar and Google Sheets. This allows me to generate calendar events from Google Sheets and vice versa, resulting in the information being ...
0
votes
0
answers
44
views
Trying to sort out Google Yearly Time-driven Trigger but failed
As the Google Apps Script doesn't support yearly triggers, I am trying to run a monthly trigger that runs on a certain date of every month, and if the month is matching my criteria, run the actual ...
- 55
0
votes
2
answers
2k
views
Apps Script: How to capture oldValue of a cell after a change made by sheets api?
I am running a python script that updates my google sheet (named 'Notifications') through the sheets api every 5 minutes. The python script first clears and resizes the sheet to only two rows and then ...
- 23
0
votes
1
answer
169
views
Google Scripts onEdit showing API Call Error
I have a system to collect time from job tickets that my employees fill out and have that information collected daily in a common timesheet. For each job, we are copying a template and filling it with ...
0
votes
2
answers
864
views
Google script error: An unexpected error occurred from openById
I' making automation system that google spreadsheet convert it to PDF file and save on my google drive.
I've known this script works successfully on my project page, but doesn't work on trigger.
how ...
- 45
0
votes
1
answer
37
views
Trigger should be activated every 5 minutes, but it doesn't happen
The sequence of activations does not follow even a time logic, as shown here:
It is enabled based on time every 5 minutes.
The script I use is very simple:
function ProjetoNovasLigas() {
var ss = ...
- 2,177
3
votes
2
answers
6k
views
Trigger a function on selecting a cell
How to write a trigger which gets triggered everytime the user selects any cell. The trigger will call a function which would log the row number of the highlighted cell on Google Apps Scripts
I have ...
- 1,290
0
votes
1
answer
266
views
Google Form Response Submit and Google Sheet Update
I have a script I am working on and need some help.
First how my script is supposed to work.
Script: A user fills out google form and hits submit. Upon submit my script runs and reads from the ...
1
vote
2
answers
1k
views
Use a library to create installable triggers for Google sheets
My customer has ~150 Google spreadsheets, one each for their "vendors". The spreadsheets are based on a template spreadsheet, in which, I've setup triggers for custom functions. However, when the ...
- 91
2
votes
1
answer
2k
views
How to create a yearly time-driven trigger?
I'm attempting to create a time-based trigger to execute my incrementCell function once a year on a specified date at 1 AM in perpetuity. When attempting to run below
ScriptApp.newTrigger("...
- 47
0
votes
0
answers
105
views
"on form submit" trigger on response spreadsheet stopped working with google change
I have a google form with a response spreadsheet and code (on the sheet) that is associated with an "on form submit" trigger. This has been working without issue for years. Google's recent change to ...
- 1
2
votes
2
answers
2k
views
This add-on has created too many time-based triggers in this document for this Google user account
I get the error as in title - This add-on has created too many time-based triggers in this document for this Google user account
When I run the add-on.
The add-on is for creating time triggers. I ...
- 3,198