All Questions
167 questions
0
votes
1
answer
67
views
getStartTime/getEndTime
Im currently working on a simple internal add-on for google calendar. When we click a event we will choose a option from a dropdown and click a button. When that happens, take the selected item with ...
- 21
1
vote
0
answers
87
views
Google Form app script to add email to calendar event returns ReferenceError: email is not defined at onFormSubmit(Code:47:34)
I thought this would be simple. I have a Google Calendar Event and a Google Form. I'm trying to edit the app script so that when the user submits their email address, the only field on the form, it ...
2
votes
2
answers
162
views
Calendar Event Time Incorrect in Script despite Correct Formatting in Google Sheets
I'm currently working on a Google Apps Script that automatically creates events in Google Calendar based on data from a Google Sheets document. The script executes successfully, and events are created,...
- 23
0
votes
1
answer
103
views
Only add All-Day OOO events in Google App Script Vacation Calendar
I am trying to use the vacation calendar app script but I only want to include all-day events, regardless of whether people are using a default event or an OOO event. There is a similar question here: ...
0
votes
0
answers
136
views
After deleting an event in Google Calendar using GAS, send the contents to any email address through a spreadsheet
Currently, when you create or update an event on Google Calendar, an email notification is sent to any email address, but when you delete an event, you do not receive an email notification.
The ...
- 9
0
votes
1
answer
46
views
Retrieve events from multiple calendars in Google Sheets
I'm beginner in google script code. I'm stopped by loop in loop trying to get events of multiple google calendar in google sheets. I found some help in this forum (here) but wasn't able to get it ...
0
votes
2
answers
73
views
Write Calendar Event ID on Google Sheets with CalendarApp on Google Sheets Spreadsheet
I am writing an App Scripts code to write events from my spreadsheet into my Google Calendar, but I want to save the Event ID on the right of the range. I can get the event id no problem, but I don't ...
-1
votes
1
answer
236
views
ERROR: Exception: Invalid argument: [Ljava.lang.Object;@7fcbe025 mySetEvent @ Try Calendar Event.gs:49. Need help pls
I need help with my script. It's working fine when i tested it using 1 email in addGuests but when I added more email in the AddGuests it's now showing errors. (Exception: Invalid argument: [Ljava....
- 9
1
vote
1
answer
39
views
How to display a link inserted in Google Calendar on Google Sheet
After creating an event in Google Calendar, I inserted a link in the description box. How do I use apps script to display links properly in Google Sheets? When the link inserted in Google Calendar was ...
- 23
0
votes
1
answer
491
views
Google Sheet to Google Calendar Integration
I am a beginner, writing a code for google sheet to create event on google calendar based on data entered on a google sheet. My start Date and end date is written in this format: yyyy", "m&...
- 3
0
votes
0
answers
353
views
Get Recurrence Pattern from Google Calendar Events
I need help from Google Apps Script experts.
Below you can see my code that honestly I achieved with ChatGPT's help.
I want to fetch the events of a certain calendar into a spreadsheet considering a ...
1
vote
1
answer
97
views
Apps Script Sheets to Google Calendar String Class Error
I'm trying to connect Google Sheets to Google Calendar using AppScript. The purpose is to automatically add events in bulk from a sheet. Here is a sample with mock data.
Here is the code:
function ...
- 13
0
votes
1
answer
530
views
"ReferenceError: Calendar is not defined" When trying to list calendar events
I copied this code directly from here, but when I try to run it I keep getting the same error:
"ReferenceError: Calendar is not defined"
It cites line 9 as the issue:
const events = ...
0
votes
1
answer
415
views
Need Help Creating Events From Google Sheets
I have a script that effectively creates google calendar events with a Google Form Response Spreadhseet, but I have 2 changes that need to be made before I can consider it fully functional.
As is, the ...
- 1
1
vote
0
answers
40
views
How to add selectively create events & add event created / not created to my Google sheet?
I want to create a Google sheet that acts as "Scheduler + Logger" of all my meetings & calls.
To do this, I have a created a Google sheet containing all relevant information - I will ...
