All Questions
24 questions
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
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 ...
0
votes
0
answers
74
views
Google Calendar and Google spreadsheet Sync: performance issue
Well well. I made a script that:
Download all (30 years) calendar Events in a spreadsheet (sheet0) with function (Sincronizza) and if empty, create an History (sheet1)
Check if Current Events in my ...
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
2
answers
142
views
Wildcards and OR clause in App Script (JavaScript)
Having some issues with my App Script code when trying to sync a Google Calendar to a Google Sheet.
I've written an if statement that posts calendar events to a specific sheet within my Google ...
-1
votes
1
answer
131
views
From Google Sheets to Google Calendar - Create event with info in differents cells
I am in the process of learning and trying to build some things.
This is a sheet where I have to send to google calendar the dates from a reservation, the start and end, the guest name, the location, ...
- 1
0
votes
3
answers
123
views
How to write Google Calendar Events from Sheets AND write EventID back to Sheet
I am attempting to write events from Google Sheets to Google Calendar. However, I want to modify my code to write the Event ID back to the Google Sheet. This code successfully writes the events. ...
0
votes
1
answer
163
views
What am I missing from this Google Scripts code (attempting to create Calendar Event from Sheets)
Forgive me, I'm new to all of this. I only have a very rudimentary grasp of programming in general (early concepts of Python/C, but nothing extensive); however, I do have an extensive background in ...
0
votes
0
answers
165
views
How can I retrieve the event Id from single instance of recurring series using Advanced Calendar Service and Calendar API?
When I use the Spreadsheet App service .getId() on a single instance of a recurring event, it returns the IcalUID for the recurring series, and not the individual event Id. This is a problem because I ...
- 3
1
vote
1
answer
389
views
Event Creation impersonation
Trying to create events using Sheets/Calendar for users in our Workspace
The events must be owned by the user so that they have ownership of the Meet to control access to invitees outside of Google. ...
- 17
1
vote
1
answer
197
views
How do I properly reference a Google Calendar Event in the same code that I created it with?
To preface this, I have never taken a coding class in my life and the only things I know about Google Apps Script are things I've read on here or their reference page. So not incredibly technical or ...
- 13
1
vote
2
answers
492
views
how to automatically add a schedule from Google Sheets into Calendar?
I have tried to implement this code to integrate google calendar with my spreadsheet, but i am fail until now. Follow the code...
function scheduleShifts() {
var spreadsheet = SpreadsheetApp....
- 23
0
votes
1
answer
889
views
Google Apps Script: Concatenating date and time
[UPDATED]: To create a google calendar event using AppsScript we can use the simple method of createEvent(eventName, startTime, endTime). I have worked with this and did not have any issues. But the ...
user11899141
2
votes
1
answer
3k
views
Delete Events from Google Calendar based on Google Sheets using Google Apps Script
Absolute noob here !
Background:
am trying to create a Google Sheet which I can update for a series of events and
create Google Calendar events based on those entries
so far, am successful in ...
- 23
0
votes
2
answers
45
views
How to best loop over each row in certain columns to create a Google Calendar Event, from a Google Sheet
I basically have the below code:
// To identify the Active Spreadsheet and link to Google Calendar
function scheduleNotifications(){
var sheet = SpreadsheetApp.getActiveSheet();
var eventCal = ...
- 11