I’m having trouble with a Google Forms integration on my website. I created a Google Sheets document and built a form that connects to it. Then I took the form HTML code and put it on my own webpage instead of using Google’s default form page.
Everything was working perfectly fine at first. The form would submit data directly to my spreadsheet without any problems. But then I decided to share the spreadsheet with another person and gave them view access to it.
Now something weird is happening. When people fill out the form on my site and click submit, instead of saving the data to the spreadsheet like before, it redirects them to Google’s original form page. The data doesn’t get saved anywhere either.
I’m wondering if adding viewing permissions for someone else somehow messed up my custom form setup. Has anyone experienced this kind of issue before? Is there a way to fix this while still keeping the spreadsheet shared with the other person?
I encountered a similar issue when customizing Google Forms for a project. It seems that when you altered the permissions of your linked spreadsheet, it might have activated Google’s security settings. These settings can prevent cross-origin submissions, which is likely why you’re seeing a redirect to the default Google Forms page instead of your spreadsheet being updated.
A potential solution is to recreate the form from scratch while linking to the same spreadsheet, which sometimes resolves these kinds of issues. Another option could be to use a server-side script to handle the form data and send it to Google Sheets directly. Sharing settings usually don’t cause the problem directly but might trigger heightened security measures that hinder submissions.
yeah i’ve seen this before too. google gets weird when you mess with permissions after the fact. try reverting the spreadsheet back to private temporarily and test if your form works again. if it does, then slowly re-add the viewing permission but make sure the other person doesnt have edit access - that can definately break things.
This sounds like a permissions conflict that I’ve dealt with before. When you modify sharing settings on the connected spreadsheet, Google sometimes breaks the direct submission link between your custom HTML form and the sheet. The redirect you’re seeing typically happens when Google can’t verify the form’s authenticity against the current permissions structure. Try checking if your form action URL is still pointing to the correct endpoint. Sometimes the sharing change generates a new form ID or modifies the submission URL. You can verify this by going back to your original Google Form and comparing the form action URL with what you have in your custom HTML. If they don’t match, update your custom form with the correct URL. This usually resolves the redirect issue while maintaining your sharing permissions.