Setting up Google Sheet integration? Check out these FAQs and their answers for everything you should know about it.
Q. Does a one time set up ensure that data from all my forms is integrated?
A. No, each form needs to be integrated with Google sheets individually following the steps outlined here. For instance, if you have 10 forms on your account, you'll have 10 different google sheets workbooks after integrating each form.
Q. I cannot see any data on the Google Sheet after integrating. What do I do?
A. The speed at which data is updated on the Google sheet after integrating a form depends on various factors, including the presence of monitoring questions (number of inter-linkages between forms), number of responses on the form, number of form revisions etc. It can take anywhere between 5 mins to a few hours for the integration to be set up. Be patient. :)
Q. Is data updated on the sheets in real time?
A. The data upload on Google sheets is dependent on the internet connectivity of the field data collectors. Once a response is submitted and considering that there is good internet connectivity available to data collectors, responses show on the Data tab on Collect as well as on the integrated Google sheet within a few seconds.
Q. I'm trying to connect a Google Account but it's showing me an error. What do I do?
A. Here are a couple of things you can try:
- Check your email ID and Password.
- Login on Collect using a different browser and try to set up integrations.
Q. I want to change the configurations I chose before integrating. What do I do?
A. Configurations cannot be changed once an integration on a form is set up. However, you can remove the current integration by clicking on “Stop Sending Responses” and recreating it following the steps outlined above. This will allow you to change configurations as required.
Q. I want to make some changes to the raw data on sheets. Is that possible?
A. Yes, changes can be made on sheets with some limitations. What's most important to keep in mind is that the first row on the sheet with Column headers is not edited. Here's what you can do -
- Add a column: If you want to add a column in sheet, for instance, to add some calculations, you can insert a new column and add the formula. This will work for all responses as and when they sync.
- Delete a column: You can delete a column from the sheet (except the column with Response ID). If the corresponding question still exists on your form, responses will still get synced for the deleted question. However, they will show in the last column of the Google sheet.
Q. My form is in draft stage. Can I create an integration?
A. No, drafts cannot be used to create integrations. Please publish your form before you create an integration.
Q. I have Collaborators on my account. But they cannot see the Integrations tab. What do I do?
A. Form Collaborators cannot create integrations at any level of access. The account administrator is the only one who can create integrations. Once done, the Google sheet with response data can be shared with as many people within and outside your organization with view/edit access.
Next Step:
Set up the Google Sheets integration for your form and get started. Check out this detailed, step-by-step guide for more details.