I have a pre-made Google Sheet which has cells to be marked as "pass" or "fail" depending on the person's score. Is it possible to link a Form response to record a pass or fail mark depending on the scores of each person? Sorry if this is not making sense I can elaborate if needed to.

  • 1
    I answered your question to the best of my ability, based on my interpretation of your question. However, if my answer is not helpful, it might benefit me and other users if you did elaborate. :) Sep 20, 2015 at 22:12

3 Answers 3


Contrary to what many believe, it is actually possible.

When you edit your form, at the very bottom there's a checkbox where you can allow editing of submitted response:

enter image description here

If you use a newer version of the Google Forms, you can click on the Gear icon on the top right and see the following page:

enter image description here

Now, what you need to do is manually submit score for each student. After every submission, you will be offered a link to edit the submission. You need to manually copy and save each link to allow future editing.

If you want to automatically record the edit response link, you can do so via Google Apps Script.


It is not possible to link a new Google Form to an existing Google Sheet without utilising Apps Script.

Your next-best option would probably be to incorporate the formulae you have in the existing spreadsheet into the spreadsheet that is generated when you create the form. Each question in the form gets its own column, but you can add your own, additional columns of cells that, respectively, compute scores and mark down a "pass" or "fail."


Best way is to send an email using Code.gs from the Google Sheet to automatically send the student an email with the pass/fail result.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.