How to integrate widgets with Google Sheets

How to integrate widgets with Google Sheets

Google Sheets is a spreadsheet app that helps people create flexible, easy-to-use spreadsheets and manage them online. You can easily connect Getsitecontrol widgets to specific spreadsheets to send the collected data to Google Sheets automatically and avoid having to manually export and import it.

1. Find the Integrations tab

You can connect your Getsitecontrol account to Google Sheets when editing your widget. Choose the Integrations tab in the top bar.

Getsitecontrol dashboard with the highlighted Integrations tab

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.

Integrations section with the highlighted Google Sheets item in the dropdown list

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

Google Account login modal window in the Integrations section

After you entered your login and password, click the Allow button to confirm authorization.

 Google Account login modal window with the Allow button

Now your accounts are connected.

3. Specify the spreadsheet

On the next step, you can specify the spreadsheet you want the collected data to be exported to. To do that, you need to get the spreadsheet URL.

Specifying a spreadsheet in the Integrations tab

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

Google Sheets spreadsheet with the highlighted URL

Then switch back to Getsitecontrol and paste it in the corresponding field.

4. Map your widget fields

Finally, click the Map widget fields button to specify which data from your widget will be passed to your spreadsheet.

Map widget fields button highlighted in the Integrations section

On the left you’ll see the list of fields that Getsitecontrol can export. And on the right you’ll find the list of columns that will be added to your Google spreadsheet once you set up the integration. You can change the names of these columns on the right.

You also can add new fields on the left to pass some extra details. To learn more about field mapping, see this guide.

Widget fields mapping modal window

When you are done mapping the fields, click OK. That’s it. Now the data submitted through the form will be automatically added in new rows inside your spreadsheet.

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

Browse by category