How do I connect a Google Sheet to Visible?

How to connect google sheet To give a deeper view on data sources and connecting one of our most popular integrations

To connect a google sheet into Visible, you need open Visible. Click on Metrics in the bottom left hand corner. Click + New data source in the top right. Click Connect next to the Google Sheets option. This will ask which gmail account owns your google sheet. Choose your google account. Google will ask for access to your Google Account. Click Allow.

Next you will choose which sheet you want to pull into Visible. Select the dropdown and choose the sheet you wish to bring in. You will choose the spreadsheet. Then the individual sheet you wish to bring in. Assign data columns and metrics names, then click Save

You will get a success message in the top right hand corner. From here, you can build charts and tables with this data!

 

See screenshots of the process below

Click Metrics in bottom left and then + New data source in the top right

 

Click Connect next to the Google Sheets option

 

Choose your google account.

 

Allow access to your google account

 

Click the dropdown and select the spreadsheet you want to bring data in from

 

Select the title of the individual sheet

 

Assign date and metric name rows and columns

 

Click Save

 

Get a success message!

 

From here you can build charts and tables with this google sheet as a data source!

Please let us know if you have additional questions!