Google Drive is a free cloud-based storage service that enables users to store and access files online.
To use files stored in your Google Drive to create a visualization/dashboard, follow the steps below.
Supported file types:
-
excel
-
csv
-
google sheets
-
json
-
Click the “+ Visualization” button in Analytics.
-
Click the “+ Add External Data Source” button and select “Google Drive”
-
Log in
-
Enter your login credentials and click Sign in.
-
Choose an account
If you have several Google Drive accounts, select the one you want to use.
Once logged in, you can also use the same account later to create another visualization, unless you delete the data source.
-
-
Select your file and the data that you want to use.
In this menu you can configure how often you would like the data to refresh:
-
Always
-
Once an hour
-
Once a day
-
Once a week
5. Set up your file according to the filetype you have selected. See: Excel / CSV for further details.