Auto populating Google Calendar based on Google Sheets document -

i've read lot of posts related problem... problem i'm not computer programmer , it's reading foreign language me. i've tried muddle way through no avail. i've been working this post , links page.

i have google sheets document list of id numbers , start date , end date treatments. i'd able run script auto populate google calendar id numbers event title , treatment time frame. don't need start , end time, i'm looking dates.

i create google calendar same spreadsheet. have 6 columns associated each id number - projected date , actual date 3 different types of testing. able run script populates google calendar type of testing event title. again, not concerned times @ all, dates.

i'm using track experiment i'm running , it's lot of information see on spreadsheet. nice easier see testing need in calendar format don't make more mistakes in missing testing days or when stop treatments.

i've been trying 3 weeks figure out on own. let's say, know nothing coding...

you should try writing function in google apps script.

1. get active sheet, range , retreive id numbers , start date , end date.
2. then create calender event referring link.

hope helps!