How can I prevent Geckoboard account members from accessing my Google Drive spreadsheets?

When you use your Google Drive account to connect your Google Sheets to Geckoboard, you can indirectly give access to your Google Drive spreadsheets to anyone else invited to your Geckoboard account. This can become an issue if there are spreadsheets you don't want to share.

One solution is to create a direct download link which will allow you to continue updating your Google Sheet as before. To do this, follow these steps:

  1. Create a sharing link of your Google Sheet.

    Note

    You may need to enable link sharing first. You'll need to set it to any one of the following sharing permission levels:

    On - Anyone with link can view
    On - Anyone with link can edit
    On - Public on the web can view
    On - Public on the web can edit

  2. Now to create the sharing link. We recommend using this link generator tool to receive a direct download link. But first we need to change the URL because this link will download in PDF format by default.
  3. To make it download in .xlsx format, change the end of the URL from ?format=pdf to ?format=xlsx.

    Examples

    Here's an example sharing link generated from Google Sheets:

    https://docs.google.com/spreadsheets/d/1gnNj6NFErrRY0NqEBVuYzPcxJ8hnFPzZ01QDeo8xAW4/edit?usp=sharing

    Example URL generated by the tool (set to .pdf download by default):

    https://docs.google.com/spreadsheets/d/1gnNj6NFErrRY0NqEBVuYzPcxJ8hnFPzZ01QDeo8xAW4/export?format=pdf

    Example final Geckoboard-friendly link in .xlsx download format:

    https://docs.google.com/spreadsheets/d/1gnNj6NFErrRY0NqEBVuYzPcxJ8hnFPzZ01QDeo8xAW4/export?format=xlsx
  4. Now you're ready to use the edited link in Geckoboard. First, hover your mouse pointer over the widget you want to edit.
  5. Click the more options icon in the top right corner.Edit widget menu
  6. On the pop-up menu, Click Edit.
  7. On the edit widget screen's breadcrumbs menu, click the downward arrow beside the name of your widget.
  8. Click Change spreadsheet.
  9. From the Choose File menu, click on the link icon.Choose your Excel file from a direct link
  10. Copy and Paste your URL in the Link to file field.Choose your Excel file from the direct link field
  11. Repeat for any other widgets powered by this Google Sheet. You can now continue updating your Google Sheet as before and it will automatically sync with Geckoboard via the generated link.
Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!