Google App Script - pull response from form and distribute to multiple sheets based on specific email

Hello. I have 120 google form quizzes which I plan to embed in my LMS.

I would then like to pull responses from each form and send to a specific spreadsheet based on email.

For example, student @ [login to view URL] takes the quiz and their result is pulled from the form and sent to a sheet for school1 or student @ [login to view URL] takes quiz and there result is pulled into a sheet for school2. If possible I would also like the results removing from the form responses once they have successfully been moved to another sheet.

There would be 100 schools approximately.

Is this possible?

Навыки: Google App Engine, Google APIs, Google Sheets

Показать больше: how to assign form responses to different sheets in a workbook, google form responses to multiple sheets, sort google form responses to different sheets, one google form to multiple spreadsheets, multiple response destinations google forms, google form pull data from spreadsheet, google apps script, google sheets, custom form database multiple emails php, script pull data internet explorer, create email response form, joomla google app, python rss script google app engine, job search engine script pull data simplyhired google, script pull data multiple excel worksheets, email form google app engine, string app script google, google app engine blobstore upload multiple files java, google app engine java multiple upload, Google app script

О работодателе:
( 6 отзыв(-а, -ов) ) Hove, United Kingdom

ID проекта: #27167543

10 фрилансеров(-а) готовы выполнить эту работу в среднем за £158


Hi there It is possible using Google Apps script, here is rough plan and step to follow - Is this possible to place all the response sheets into a same folder so the script can manage all of them? - There is an event t Больше

£350 GBP за 3 дней(-я)
(20 отзывов(-а))
(4 отзывов(-а))

Hi Mr. Employer, Basically the Google sheet is running by Javascript. So we have some knowledge in JavaScript. I have a lot of experience in Google sheets and I can do this project in an effective manner with 100% accu Больше

£20 GBP за 1 день
(6 отзывов(-а))

Hi. I have written many automation GoogleShete scripts. Ready to write your project. Will complete within 2 days

£120 GBP за 2 дней(-я)
(3 отзывов(-а))

Hi employer, Hope your are doing well. I have seen your requirement to create a google app script to fill date into google sheets with certain conditions. I can help you completed the task in smallest possible time. I Больше

£110 GBP за 2 дней(-я)
(1 отзыв)

Hello, Hope you are safe. Yes. your idea is really possible and I can do it in a short time. https://www.freelancer.com.ru/projects/javascript/second-project/reviews This is my previous google app script project. As yo Больше

£140 GBP за 2 дней(-я)
(0 отзывов(-а))

Hi, We have checked [login to view URL], [login to view URL] . I have gone through your requirements " Google App Script - pull response from form and distribute to multiple sheets based on specific email " and can absolutely assist Больше

£189 GBP за 7 дней(-я)
(0 отзывов(-а))

I am a software engineer with 6 years of software development experience. For around 2 years I am writing google scripts and doing similar jobs that you have posted. I can do your job in quick time.

£200 GBP за 7 дней(-я)
(0 отзывов(-а))

This is possible to interface with LMS, even better options are there for managing form responses from indivisual students. Do you have website that has LMS already? Your Invitation over a private chat would be highl Больше

£120 GBP за 7 дней(-я)
(0 отзывов(-а))

Hi, I will setup the google sheets to pull responses from the 120 odd google forms and send them to specific spreadsheets based on the student email address. Please revert with a few samples forms for the quizzes and d Больше

£135 GBP за 2 дней(-я)
(0 отзывов(-а))