How to integrate widgets with Google Sheets

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.

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 entered your login and password, click the Allow button to confirm authorization.

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.

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

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.

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.

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.