Script needed to import and format data from google sheets to google calendar

Script needed to import and format data from google sheets to google calendar

Current Google sheet:

[login to view URL]

Functions imports events from google calendar and parses the data into time sheets, then calculates distances from addresses.

Here is a sample calendar with test events in December 2017 and January 2018. The sheet is linked to the test calendar: [login to view URL]

The calendar ID is in the "Settings" tab/sheet.

To create time sheets:

1) click "Date Picker" at top and enter dates. To test sample data in sample calendar, enter dates 12/02/2017 to 02/02/2018 and an address in the United states. Example: 1 World Way, Los Angeles, CA 90045. Then click "Import events". Calendar information is imported into "Data" sheet. This is for review.

2) Click "Submit" (green button) and the time sheets are created for each different "CO" in column A.

3) The created time sheets can be saved as PDF's.

-----------------

Update needed: I want to add a new sheet that has a similar format as "Data" sheet but a script will format data from sheet into calendar. This function will come before the "Import events" function. Also, this sheet should not be deleted. The user should enter "Date from:" and "Date to:" and the script will import the data in the rows that match these dates.

Looking to make some money?

Awarded to:

Dear Sir or Ms.
I am John, pleased to meet you.
I'm well experienced in Google Apps Script and G Suite.
Please, take a look at my portfolio in my profile.
It is not very clear, do you want the script to creatMore

$98 USD in 6 days

(11 Reviews)

4.7

3 freelancers are bidding on average $276 for this job

Dear Client,
Greetings. I would absolutely love the opportunity to build the Gsheets to Gcalendar data processing script for you. I have extensive experience in Google sheets / docs script automation. I will help yoMore