Google Sheets integration
- or -
Post a project like this$
- Posted:
- Proposals: 2
- Remote
- #976705
- Expired
Description
Experience Level: Entry
General information for the business: Script to facilitate a scaffolding job tracking solution
Description of requirements/functionality: Description of requirements/functionality: We have developed a job tracking solution for a scaffolding provider. This includes the provision of a portal, Google Form to enter details of new jobs, Google Sheet to hold the job information, Zapier to send the job information to a Google Calendar and AppSheet to build a mobile app. AppSheet captures images from the remote users and places them in a Google Drive folder. The images are automatically tagged with a unique job reference and file name, in the form of 'BS002.Image 1.094606.jpg'.
We need a way to create a Google document from a specified row in a Google Sheet and attach the relevant images from Google Drive. The Sheet contains the file name of the image and all images are in the same folder. Ideally, we would like the script to reference a Google template which can be changed as required.
The process can be invoked either through a Google Sheet add-on or a bespoke menu item, whichever is quicker to produce.
Specific technologies required: Google Apps Script
Extra notes: Extra notes: This is the data structure in the Google Sheet:
11/29/2015 20:36:30
BS003
Peter Thompson
19 Farnley Street, Yeadon
LS19 7YU
97867
DAVID CARROLL
ANDY CARROLL, MATTHEW SIMM, CONNOR STANLEY
JON CONNOLLY
PN57 VMH
11/30/2015
Private client, construction need
678
XXX - New erection job_Images/BS003.Image 1.083848.jpg
XXX - New erection job_Images/BS003.Image 2.083850.jpg
XXX - New erection job_Images/BS003.Signature.083852.png
Completed
Description of requirements/functionality: Description of requirements/functionality: We have developed a job tracking solution for a scaffolding provider. This includes the provision of a portal, Google Form to enter details of new jobs, Google Sheet to hold the job information, Zapier to send the job information to a Google Calendar and AppSheet to build a mobile app. AppSheet captures images from the remote users and places them in a Google Drive folder. The images are automatically tagged with a unique job reference and file name, in the form of 'BS002.Image 1.094606.jpg'.
We need a way to create a Google document from a specified row in a Google Sheet and attach the relevant images from Google Drive. The Sheet contains the file name of the image and all images are in the same folder. Ideally, we would like the script to reference a Google template which can be changed as required.
The process can be invoked either through a Google Sheet add-on or a bespoke menu item, whichever is quicker to produce.
Specific technologies required: Google Apps Script
Extra notes: Extra notes: This is the data structure in the Google Sheet:
11/29/2015 20:36:30
BS003
Peter Thompson
19 Farnley Street, Yeadon
LS19 7YU
97867
DAVID CARROLL
ANDY CARROLL, MATTHEW SIMM, CONNOR STANLEY
JON CONNOLLY
PN57 VMH
11/30/2015
Private client, construction need
678
XXX - New erection job_Images/BS003.Image 1.083848.jpg
XXX - New erection job_Images/BS003.Image 2.083850.jpg
XXX - New erection job_Images/BS003.Signature.083852.png
Completed
Sean P.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
12 Apr 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies