How to create a direct link to your Google Sheets spreadsheet

If you have spreadsheets you don't want to share in your Google Drive when connecting your Google Sheet to Geckoboard, one solution is to create a direct download link. 

  1. In Google Sheets select File - Publish to the Web.
  2. From the pop-up modal, create a link to an .xlsx Excel file by clicking the menu marked Web page and changing it to Microsoft Excel (.xlsx).

    Then click Publish.Publish your Google Sheet to the Web
  3. Click OK when Google Drive asks Are you sure you want to publish this selection?
  4. Copy the generated link in the modal.Copy the link to your Google Sheet
  5. Switch to Geckoboard and hover your cursor over an empty area of your dashboard and click the + button.

    Alternatively, click Add widget in the top right of your dashboard.
  6. You'll see a scrollable list of data sources. Click Excel.
  7. In Geckoboard, in the Link to file field, paste the copied link to your file. Our integration will do the rest.Choose your Excel file from the direct link field
  8. And that’s it! You're now ready to prepare a visualization using your spreadsheet data.

Turn spreadsheet data into shareable dashboards

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Heather

    USA