Frequently Asked Questions
Google Sheets Integration
Last Updated 6 months ago
Google Sheets Integration allows all form submissions through your site to be pushed back to Google Sheets keeping a history of your enquiries.
Why Google Sheets?We have chosen Google Sheets as Google is amongst the most secure companies in the world, and with all your form data being sensitive and likey subject to your countries Privacy Laws, it is important this is as protected as possible.
Please note this is only available on the 'business plan'.
Setting up Google SheetsIMPORTANT: Before you get started, please read the "Important - What to know" information at the bottom of this page as by not being aware of these issues could cause the integration to break.
Step 1This help video shows you Step 1 of setting up and using Google Sheets with your web forms.
Step 2This help video shows you Step 2 of setting up and using Google Sheets with your web forms.
Turning on SheetsThis feature to enable Sheets synchronization is in place so that you can control whether a form pushes to Google Sheets or not as there may be times when you do not wish to do so.
IMPORTANT: It can take a couple of minutes for the link to be available for Google Sheets and each time a form submission occurs.
Important - What to knowYour Google Sheet will look something like this screenshot when you immediately create it. This is exactly how it should look. Once the first entry has been submitted through a form that has Sheets integration activated, Limecube will automatically create the required columns.
Formatting your SheetsBasic formatting and adding filters is fine, but any structural changes to Sheets may break this link.
When your Sheet has been created it will look something like this:
You can however add some basic formatting like this example below and put filters on. Filters will be important as your Sheet starts to fill up.
All forms where Sheets synchronization is enabled will push to the one Sheet. This is where filters can become very helpful.