I gang

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.

Evner: Google App Engine

Se mere: 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

Om arbejdsgiveren:
( 22 bedømmelser ) Chula Vista, United States

Projekt ID: #18163899

Tildelt til:


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 Flere

$98 USD in 6 dage
(11 bedømmelser)

3 freelancere byder i gennemsnit $276 på dette 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 yo Flere

$450 USD in 12 dage
(0 bedømmelser)

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

$280 USD in 4 dage
(0 bedømmelser)