Tweaks on Google Calendar API
Buget $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");
}
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
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!
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
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
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
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
