Learn-to-send-email-via-google-script-html-no-server: Google Spreadsheet not updating

[mingxu16]

I have been successful until the google spreadsheet updating step. Once I click the submit button, it sends the data to my email but the Google Spreadsheet is not updating. Any possible reasons? Thanks.

[mckennapsean]

Permissions must have been all allowed. Spreadsheet must have, by default, a tab called "responses" like the example, and the column names must match the input names on the form.

Also, you must be using Javascript in order for this to work. Possible bug. Like the email, we may want to have a default server-side if no tab is passed in. The local Javascript code in form-submission-handler.js should be setting this tab by default, otherwise without it, none is set, and thus it may not write the data but still send the email.

Let us know if any of that helps, thanks!

[mingxu16]

Thank you so much. It was because my Google Spreadsheet tab was not named "responses." I didn't copy your sheet. Now it works smoothly. Thanks a lot!