If you'd like to connect a spreadsheet using a direct link rather than connecting your entire account, you'll first need to generate the share link to use within Geckoboard. In most cases, you'll need to make sure your spreadsheet file is publicly available so it can be accessed, with permissions set to Anyone with the link or the equivalent. Continue reading to learn about specifics for each cloud platform.
Why you might prefer to connect your spreadsheet using a share link
All Account owners and Admin members who are part of your Geckoboard account have access to all data sources connected to it.
This means when you connect Google Drive, OneDrive, SharePoint, or Dropbox to Geckoboard, the spreadsheets within that account can be used to create widgets by all Account owners and Admins that belong to your Geckoboard account.
If you have spreadsheet files within your Google Drive, OneDrive, SharePoint, or Dropbox account that you do not want shared with other team members, you should use the method described in this guide and create share links for your files and connect using the link-to-file method.
Google Drive
Click the Share button in the top right-hand corner.
Set your spreadsheet file to be visible to Anyone with the link.
Click Copy link to copy your sharing link.
Switch to Geckoboard, then paste your share link into the Link to file field.
OneDrive for Business or SharePoint
Select your spreadsheet file, click Share, then select Copy link.
Then click Settings.
Scroll down to the More settings drop-down and open it.
Set the permission to Can edit, then click Apply.
Select Copy link again if needed.
Switch to Geckoboard, then paste your share link into the Link to file field.
OneDrive Personal is not currently supported for hosting .xlsx files, as Microsoft does not offer downloadable files through a share link for this platform.
Dropbox
Open the spreadsheet file you’d like to share, then click Share.
In the dropdown, click Share with Dropbox.
Click the settings icon.
In the modal that appears, click the Link for viewing tab.
In the Who has access section, set it to Anyone with the link.
Make sure all other options (Require password, Expiration, Disable downloads) are turned off.
Leaving any of these on will prevent Geckoboard from accessing your sheet.
Click Copy link.
Switch to Geckoboard, then paste your share link into the Link to file field.
