Linking Up Google Sheets and Google Calendar -

i trying figure out how work shifts created in google sheet automatically entered each individual employees google calendar.

here link test google sheet (accessible link): https://docs.google.com/spreadsheets/d/1ljkwzmhavesba6xrxkwweuizvtfgfakdk9si39on95g/edit?usp=sharing

i assume can enter code google script, not programmer, have no clue begin - if possible.

here brief description of seeing in google sheet:

each person has 2 weeks of shifts run left right. each letter represents different shift, corresponding day @ top. need separate email associated person1, person2, etc.

i appreciate help! if have questions @ all, ask!

thanks,

cory

you need permission access these people's calender's. can grant permission when code runs. if user has more 1 calender, , don't want program change/use default calender, you'd need know name of calender want updated. information in spreadsheet need "parsed".

basically, need data out of spreadsheet. use getvalues() that. returns 2 dimensional array. so, need able use loop 2 dimensional array. code put new event calender shouldn't hard relatively. search documentation, , there example code.

google documentation - event