Google Sheets Integration

On this page:

  1. Setting up Google Sheets
  2. Step 1 - Authenticating Sheets
  3. Step 2 - Turning Sheets on
  4. IMPORTANT to know
  5. Formatting your Sheets

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 likely subject to your countries Privacy Laws, it is important your customer data is as protected as possible.

Please note this feature is only available on the 'business plan'.

Setting up Google Sheets

Step 1 - Authenticating Sheets

This help video shows you Step 1 of setting up and using Google Sheets with your web forms.

When you authenticate your Google Sheets, only the account you authenticate has access to the sheet, and nobody else (Including Limecube) unless you add them onto the sheet. If you want to add anyone else to the sheet, refer to Google's help file.

Step 2 - Turning Sheets on

This help video below shows you Step 2 of setting up and using Google Sheets with your web forms.

This 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.

It can take up to 3 minutes for the link to be available for Google Sheets and each time a form submission occurs.

Google Sheets activation

Connecting to existing sheets

By default, a new sheet will be connected each time you create a new form. However you do have the ability to connect to an existing sheet by choosing from the 'Spreadsheet' drop down options. This will create a new tab in an existing spreadsheet.

Google sheets select options

Finding all Google Sheets connections

All connected sheets can be found under the settings page. Go to:

  1. 'More' on the top menu:
  2. Administration > Settings > API Credentials
  3. Under the heading 'Google Sheets Integration' The list of your Google Sheets will display.
IMPORTANT: 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.

Help Video

IMPORTANT to know

Your 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.

Google Sheet example

Formatting your Sheets

Basic 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:

Formatting your Sheets

Formatting your Sheets

All forms where Sheets synchronization is enabled will push to the one Sheet. This is where filters can become very helpful.

Can't find the answer you are looking for?

Try using searching below: