You can connect your forms to a Google Sheet. Exporting your form data to Google Sheets in real-time is powerful for many reasons:
- Your form data is automatically backed up to an additional server.
- From your Google spreadsheet, you can easily forward your form information to a CRM, an email marketing list, or any other third-party tool that you use for managing your customer data. (We recommend Zapier for additional automations).
To get started, follow these steps:
- Open your Form Editor.
- Go to Settings
- Under Integrations, click on Google Sheets
- Toggle on Connect to Google Sheets. You will be redirected to a Google page.
- Log into your Google account, or select an account you are already logged into.
- Authorize POWR to send form data to your Google Drive.
- You will then have a new spreadsheet in your Google Drive that collects your form data in real-time. You can also access your connected spreadsheet via the View Google Sheet button in your connected form.
Note: As of Jan 10, 2019 images are no longer displayed in cells in a connected Google Sheet. Please visit your form response dashboard to get an updated link for your file.
Can I download the file directly from Google Sheet?
Yes, it is possible to download the file from Google Sheet that was connected to POWR FormBuilder app.
Please follow these steps:
1. Open Google Sheet
2. Click on the file download link
Comments
15 comments
Integration of Google Sheets and real time feed works nicely. But it seems there are significant bugs that keep it from collecting accurate data. Unless I'm doing something wrong...
Here's the problem:
Is there any way to lock the Header Row so it includes all of the possible Form Element Labels? (I already tried to lock the editing permissions on the Google sheet.) Or, is there a way to fill a non-required field with a place holder, even a "N/A" so that it doesn't skew the data if someone chooses not to answer?
This is not just helpful. It's necessary.
Hi Courtney!
Thanks for reaching. Great feedback! That is obviously not supposed to happen. I'll shoot you an email so you can send me the link to your form. Our engineering team will be happy to take a look and help you make everything work correctly!
I have just experienced a problem with the google sheets integration and can't figure out how to resolve. I had everything setup and it was working fine. Somehow, I deleted the file in my google drive. I went back into Form Builder Plus and tried to set it up again. I see no way of correcting the problem. When I click on go to google sheets it tells me the file has been deleted or moved; but no way to correct my mistake. If anybody knows a fix, please inform me. I would greatly appreciated any help I can get. Thanks again,
Hi there!
There should be a way to move the file out of the trash if that is where it's currently stored in your Google Drive folder.
Typically, "Move out of Trash" appears as an option in the modal that appears in your Google Drive when clicking on the link.
If that isn't happening, please send a link to your form as well as a screenshot of the error to our support team and they'll be happy to take a look!
I had deleted it from my trash also. I’ve contacted google and they have restored the file; but haven’t had a true test yet. I will know more once a form is filled out. Thanks for replying so quickly.
Hello!
I connected my form to the google sheet but it only seems to work sporadically. Sometimes it autopopulates and sometimes or quite often it doesn't auto fill for the form respons submissions. Why does it only work sometimes?
Hi Kerry!
Did you frequently change fields in your form? If the headers in your form change, that can cause the fields to not merge correctly. I'd recommend submitting a support ticket with more details, including a link to your form and a share link to your Google Sheet, so that our engineering team can take a look.
Thank you! :)
When trying to "view google sheet", I keep getting a blank screen.
I presently use PowrForm with File Upload as an option. If/when I connect my Form to a Google Sheet, what happens with the uploaded file?
Chris Beeler
I seem to be having a issue sending multiple forms to the same google account, is this normal or is there something i need to do to fix the issue
Hi Anfloyd,
You should be able to connect multiple forms into one Google account, as app creates separate spreadsheet to each app. I'd recommend submitting a support ticket with more details, including a link to your form and a share link to your Google Sheet, so that our engineering team can take a look.
Thank you! :)
They keep closing my ticket without any help. if they need additional information that is fine just ask for what is needed
Hi Anfloyd, The reason why your tickets are being closed, is that you already have an open ticket that being served. This is to prevent to reply you multiple times:) Our agents will get back to you as soon as possible! Thanks for your understanding.
I setup the integration no problem, i see the Google Sheet created, but when the form gets completed, it doesnt add a row entry to the sheet. What did i miss?
Hello! This advice is not working. I am trying to connect my form to google sheets, and it will not even give me the option to toggle the "connect to google sheets" option. If I select the blue button to "view the google sheet" it sends me to google to request access....and then I receive no email to grant access. Can you tell me what is wrong? Thanks in advance for your help. nicole@lovelydots.com.
Please sign in to leave a comment.