Is there a way to create a Form that submits to a particular TAB of a Google Sheet?

Use Case:

We are using this for meeting pre-check-in. There's standard form. I'd like the results for each participant to go to their own TAB.


Short answer

Use Google Apps Script


This isn't built-in function on Google Forms or Google Sheets, but we could create bounded script projects on forms and spreadsheets. Both have an onFormSubmit installable trigger that could be used to send the form submissions as soon as their occur to the desired tab.

Another alternative is to create a script to be triggered by other means, like from the Apps Script editor, just to mention one.

A third alternative could be to use an add-on, if there is already one that do this.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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