How to integrate forms
with Google Sheets

Google Sheets is a spreadsheet app that helps people create easy-to-use spreadsheets and manage them online. You can set up an integration between Getsitecontrol and Google Sheets to automatically send the collected data to your spreadsheets.

1. Find the Integrations tab

To connect a Getsitecontrol form to Google Sheets, go to the ‘All widgets’ section and open the form by clicking on the Edit button at the bottom of the form card.

Next, switch to the Integrations tab from the top bar.

2. Connect your Getsitecontrol account to Google Sheets

In the ‘Third party integrations’ section, click the +Add application link and choose Google Sheets from the drop-down list.

You will be asked to sign in to your Google account.

After you enter your login and password, click the Continue button to confirm authorization.

Now, your Getsitecontrol account and Google Sheets account are connected.

3. Specify the spreadsheet

The next step is to specify the spreadsheet where you want to export the collected data. To do that, you need to get the spreadsheet URL.

Here is where you can find it: go to Google Sheets, open your spreadsheet, and copy its URL from the browser address bar:

Then switch back to Getsitecontrol and paste the URL in the corresponding field:

4. Map your form fields

Lastly, click the Map fields button to pair your form fields with spreadsheet columns.

Proceed to click the +Add field button. On the left, you’ll be able to select variables corresponding to form fields or system fields:

On the right, you’ll write the labels for the columns in your spreadsheet where the data will be sent:

❗ Keep in mind that you don’t need to name the columns in your spreadsheet: the column names will be entered automatically as soon as your form starts collecting data and sending it to Google Sheets.

To learn more about field mapping for third-party integrations, read this guide.

When you are done mapping the fields, click Save.

That’s it. The data submitted through the form will be automatically added to the columns in your spreadsheet.

You can connect your form to more than one third-party application. Click the +Add application link to add another integration for the current form.

If you have issues setting up mapping for third-party integrations, or with any other task, feel free to message us. Our Tech Support team will be happy to help you.