Make your connected Google Sheet private

When you connect your Google Sheets to Geckoboard via Google Drive, 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 to your Google Sheet, which will allow you to continue updating your Google Sheet as before. First you'll need to to enable sharing on your Google Sheet

  1. Click the Share button in the top right hand corner.
  2. In the Get link panel, set your spreadsheet file to be visible to 'Anyone with the link'. options for how to share your google drive files
  3. Click Copy link to copy your sharing link.
  4. Switch to Geckoboard and edit a widget powered by your Google Sheet.
  5. On the edit widget screen's breadcrumbs menu, click the downward arrow beside the name of your widget.
  6. Click Change spreadsheet.
  7. From the Choose File menu, click on the link icon and paste your sharing link URL in the Link to file field.Paste your Google sheet sharing link into the direct link field
  8. 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!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.