In Progress

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.

Skills: Google App Engine

See more: import nmea data google earth, import historical data excel format, quickbook import invoices data format, update google spreadsheet from calendar, google sheets to calendar script, google sheets to google calendar script, calendar events creator, import google calendar to google spreadsheet, insert google calendar in google sheets, google calendar spreadsheet sync, insert calendar in google spreadsheet, google maps import location data, prestashop import format data, format data sheets, calendar google calendar script, script import cdr data access database, perl script import csv data mysql, import text data excel using script, script import text data excel, data sheets excel format

About the Employer:
( 22 reviews ) Chula Vista, United States

Project ID: #18163899

Awarded to:

ioanaprof

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 creat More

$98 USD in 6 days
(11 Reviews)
4.7

3 freelancers are bidding on average $276 for this job

ajittomar9

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 yo More

$450 USD in 12 days
(0 Reviews)
0.0
ancientnix

work in various projects with google app engine, excel formatting and date conversion.

$280 USD in 4 days
(0 Reviews)
0.0