Google Apps Integration with Google Apps Script - Create a custom Addon

Objective: Create an addon that ties together Google Drive, Docs, Sheet, Gmail and Forms using google apps script (javascript): [url removed, login to view]

Addon will take submissions from two separate similarly formatted google forms, log user submissions to a single google sheet for both forms, and create a formatted PDF that is emailed to designated admin emails as well as to the email address provided by the user of the form each time the form is submitted. PDF will also be saved in an admin designated Google Drive folder, and Google Form will auto-update crew lists upon editing of respective Google Sheets containing the crew lists.

Essential Features:

-Google Form follows given example format.

-PDF follows given example format.

-Admin email addresses are designated on startup/installation of addon, and can be changed as necessary.

-Directory that PDF’s are stored in is designated on startup/installation of addon, and can be changed as necessary.

-On form submission PDF is emailed to admin email addresses as well as email address submitted by the user of the form.

-On form submission PDF is saved in the admin designated Google Drive folder.

-Each of the Google Forms auto-update upon editing of the respective crew list Google Sheets.

-In case of error addon sends email to admin email address with description of failure (does not fail silently)

-Master Google Sheet that both Google Forms are tied to will be created when tied to the forms. Must contain all info/responses submitted by users of both forms in a single Google Sheet.

-Addon must be flexible enough to allow for changes in number/names of vessels and number/names of crew if form is changed.

Google Form formats, Google Sheet crew list formats, and PDF format can be found here:

[url removed, login to view]

For the auto-update from Google Sheet feature above please see the existing and available addon 'FormRanger'. An auto-updating version of this functionality included in the addon you will be writing is what is required for this project. Form Ranger can be found here: [url removed, login to view]

For the admin email and directory designation on startup features above please see the sample addon 'Form Notifications' which implements this functionality and is a good starting point. It can be found here: [url removed, login to view]

The budget for this project is not to exceed $125.00. This is a fixed amount that will be paid when all requirements are met. If you bid below this amount I am more likely to award this project to you, depending on experience. This project requires prior experience with the Google apps Drive, Docs, Sheet, Gmail and Forms, as well as google apps script which ties these apps together. The project is tied directly to the form in the description, and edit access will be granted when project is awarded.


DO NOT TRY TO SUBCONTRACT THIS PROJECT. This is an unfair practice for everyone on Freelancer - the person who does the work will receive 100% of the profit, no middleman. I will deal only with software author directly. Re-posting this project or other untrustworthy actions will result in project cancellation. We will be working together, and trust in this working relationship is as important as the final product.

Compétences : Moteur Google App, Javascript, Architecture Logicielle

en voir plus : how to create a website using google apps, integration moodle google apps, google maps api create script, javascript, google app engine, google apps sso sample, write script migrate cyrus google apps, login google apps sso sample, google map custom marker maker script, google apps api sample php, create script google maps, example create script google provisioning api, php script return number google results, script php apps mobile, integration routes google site, joomla login apps google, php script number pages google, create script google, integration joomla google apps, rental script integration jooma

Concernant l'employeur :
( 1 commentaire ) Marina Del Rey, United States

Nº du projet : #13862424

Décerné à:


Hello Dave, I will be happy to help you with that project. I can create a Google Script Addon that does all the specified requirements. We will have two triggers. 1. For the forms, we will have onSubmit trigge Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(21 Commentaires)

6 freelance font une offre moyenne de $171 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)

Hello! I have 5 years experience using Google apps. My work is all my own, I don't send my projects to a sweatshop. I am highly qualified for this project and would love to speak with you further about taking this p Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(28 Commentaires)

Hi, great and very detailed project description ! Am using Google Apps / G-Suite for over 15 years and AppScripts since it's available in private beta. I am not (not longer) a developer but am using app scripts to a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)

Hey We are a team of Technical Developers and have got expertise in such stuff. Ping me if you are looking for a quick resolution

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(4 Commentaires)