Google Sheets - We need to be able to adjust and edit the google sheet that the responses sync to, and we need the google sheet to remain as is and not revert back to the original sync when new responses are added - how can we do that?
There are two options to sync the responses to Google Sheets:
1️⃣ Export data from Formfacade Reports
Login to Formfacade > click Forms > click on the form to open it > Edit page will be displayed > click Reports > In the Reports page, click on the settings gear icon > click Sync all responses. Please note that this is not a real time sync; the responses will be synced to the sheet whenever you click on the sync all responses option in the Formfacade Reports page. Once synced, you cannot change the linked google sheet.
Formfacade does not have permission to create a sheet in your Drive. When you export data from Formfacade Reports to Google Sheets, the sheet is created in the service account, and your email address is added as a collaborator to provide access. The first column, which contains the unique ID, is locked. You will not be able to delete rows, apply formatting or create filters that affect this column.
2️⃣ Sync Google Forms responses to Google Sheets
By default, the responses will be recorded only in Formfacade. You can view the form submissions in the Formfacade Responses and the Reports page. If needed, you can enable the option to submit responses to Google Forms.
Submit to google forms
Login to Formfacade > click on the form to open it > Edit page will be displayed > In the Edit page, click on the form title to select it > click on the settings gear icon > Form settings page will be displayed > click Advanced > enable the Submit to google forms option and click Save. Once enabled, new responses will be recorded in Google Forms.
Sync responses to Google Sheets
Open your form in Google Forms > click Responses > click Link to sheets and follow the prompts to set up the sync to google sheets.
Comments (1)
Oct 12, 2025
There are two options to sync the responses to Google Sheets: 1️⃣ Export data from Formfacade Reports Login to Formfacade > click Forms > click on the form to open it > Edit page will be displayed > click Reports > In the Reports page, click on the settings gear icon > click Sync all responses. Please note that this is not a real time sync; the responses will be synced to the sheet whenever you click on the sync all responses option in the Formfacade Reports page. Once synced, you cannot change the linked google sheet. Formfacade does not have permission to create a sheet in your Drive. When you export data from Formfacade Reports to Google Sheets, the sheet is created in the service account, and your email address is added as a collaborator to provide access. The first column, which contains the unique ID, is locked. You will not be able to delete rows, apply formatting or create filters that affect this column. 2️⃣ Sync Google Forms responses to Google Sheets By default, the responses will be recorded only in Formfacade. You can view the form submissions in the Formfacade Responses and the Reports page. If needed, you can enable the option to submit responses to Google Forms. Submit to google forms Login to Formfacade > click on the form to open it > Edit page will be displayed > In the Edit page, click on the form title to select it > click on the settings gear icon > Form settings page will be displayed > click Advanced > enable the Submit to google forms option and click Save. Once enabled, new responses will be recorded in Google Forms. Sync responses to Google Sheets Open your form in Google Forms > click Responses > click Link to sheets and follow the prompts to set up the sync to google sheets.
Add your comment
Add photo