В работе

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");


Навыки: PHP, Google APIs, Google Apps Scripts

О клиенте:
( 11 отзыв(-а, -ов) ) Sao Paulo, Brazil

ID проекта: #36286388



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 Больше

$40 USD за 2 дней(-я)
(70 отзывов(-а))

14 фрилансеров(-а) готовы выполнить эту работу в среднем за $38


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 день
(26 отзывов(-а))

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 дней(-я)
(44 отзывов(-а))

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 Больше

$30 USD за 2 дней(-я)
(7 отзывов(-а))

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 Больше

$25 USD за 7 дней(-я)
(2 отзывов(-а))

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 Больше

$30 USD за 2 дней(-я)
(1 отзыв)