Tweaks on Google Calendar API

Job Description:


I have a spreadsheet ([login to view URL]) that I want to integrate with Google Calendar and I already have a code that does that for me.

However, I need the code to be tweaked so that:

1. one of the columns allows me to set the events to ALL DAY on Google Calendar;

2. one of the columns allows me to set the frequency of the events (daily, annualy etc.);

3. the code updates the calendar, instead of creating new events each time I run the script.


function create_Events(){

var ss = [login to view URL]();

var sheet = [login to view URL]("Teste");

var last_row = [login to view URL]();

var data = [login to view URL]("A1:E" + last_row).getValues();

var cal = [login to view URL]("calendarname");

//[login to view URL](data);

for(var i = 0;i< [login to view URL];i++){

// index 0 = Nome do Evento

// index 1 = Data e hora iniciais

// index 2 = Data e hora finais

// index 3 = Descricao

// index 4 = Cor

var Events = [login to view URL](data[i][0],

new Date(data[i][1]),

new Date(data[i][2]),

{description: data[i][3], colorID: data[i][4]});

//[login to view URL]('Event ID: ' + [login to view URL]());


[login to view URL]("Eventos criados com sucesso");


Taidot: PHP, Google APIs, Google Apps Scripts

Tietoa asiakkaasta:
( 11 arvostelua ) Sao Paulo, Brazil

Projektin tunnus: #36286388

Myönnetty käyttäjälle:


Hello, I'm an experienced Google Apps Scripts developer. I have experience in creating automation solutions for Google Workspace apps using Google Apps Scripts. I can add the features you mentioned in your project brie Lisää

$40 USD 2 päivässä
(70 Arvostelua)

14 freelanceria on tarjonnut keskimäärin $38 tähän työhön


Hi, I'm interested in your requirement. I have good experience of web development with Google Apps\Ads Scripts We can discuss further on chat. Thanks!

$75 USD 1 päivässä
(26 arvostelua)

Hello, I have great experience in API customization and modification and can do this project and can integrate spreadsheet with Google Calendar. I am waiting for your response. Thanks, Ankit

$100 USD 2 päivässä
(44 arvostelua)

Hi there, The script you showed will really add an event to the calendar, to update the event in the calendar, you also need the event id to that. I can provide you a new and cleaner script from scratch that can do t Lisää

$30 USD 2 päivässä
(7 arvostelua)

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Google APIs, Google Apps Scripts Please come over Lisää

$25 USD 7 päivässä
(2 arvostelua)

I'm a skilled developer of Google Apps Scripts. I have experience utilizing Google Apps Scripts to provide automation solutions for Google Workspace apps. The features you listed in your project brief, such as the abil Lisää

$30 USD 2 päivässä
(1 arvostelu)