În desfăşurare

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


Aptitudini: PHP, Google APIs, Google Apps Scripts

Despre client:
( 11 recenzii ) Sao Paulo, Brazil

ID Proiect: #36286388

Acordat lui:


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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 2 zile
(70 Recenzii)

14 freelanceri licitează în medie 38$ pentru acest proiect


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!

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(26 recenzii)

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(44 recenzii)

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(7 recenzii)

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(2 recenzii)

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(1 părere)