Creating Google Sheet Connections

Google Sheets workbooks can connect to widgets inside your Connect app.

Get started by clicking Data in the left hand panel. 

The Data Connections menu will appear.. Click Create a Connection button to create a new connection. 

‍

Next click on Google Sheets under the Create a Connection heading. 

In Google Drive open a google sheet and copy the sheet’s url.

‍

Paste the url into Connect then click import spreadsheet.

If you haven’t authorized Connect with your Google account you will have to sign in with your Google account credentials and accept authorization before continuing. 

Choose the sheet in the workbook then click continue. 

Validate the data and make any necessary adjustments then click continue.

Set the synchronization frequency then name your connection.

Now you are ready to use your Google Sheet connection in your Connect App. 

‍