We need a Google Scripts experts to help us do the following tasks:
Step 1: From given Google Sheet as database with student information, create individual Google Documents as profiles for each student.
Step 2: Individual Google Documents must include all the information given by the format provided and taken from the database Google Sheet.
Step 3: Integrate a Google Form with the Google Sheet to send information with given values about the specific student and add it to the Individual Google Document. The Google Document keeps track of all the changes made by the Google Form.
Step 4: Generate an Individual Report from given format with the information of the Google Document and the information sent by the form. This report must be sent to the contact email of the student on every taking into account if the student is active on the database of the spreadsheet. If there is no new information sent with the form.
Step 5: Generate summary report of all the information sent with the form to a given email address.
Some of the steps are to be done automatically, some on given dates and some only when the application is requested.
Looking forward to hearing from you.
8 freelanceria on tarjonnut keskimäärin 195 $ tähän työhön
hello, I have experience on Google scripts for 3 years. I have created several software make the same that you need. also speak Spanish if you need.