Tweaks on Google Calendar API
Бюджет $10-30 USD
Job Description:
Hi.
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.
BELOW IS THE CODE:
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");
}
Поручен:
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 Больше
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!
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
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 Больше
