How to create a direct link to your Google Sheets spreadsheet

To create a direct link to your spreadsheet, follow these steps:

Before you start

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

To enable sharing on your Google Sheet, follow these steps:

  1. Open your spreadsheet in Google Drive.
  2. Click the blue Share button in the top right hand corner to open the Share with others modal.share button on google drive
  3. If your file isn't shared already, click Get shareable link.get a shareable link on google driveOtherwise click the dropdown to choose the access permissions and select More...options for how to share your google drive files
  4. In the popup window select either On - Anyone with link can view or On - Public on the web.extended options for how to share your google drive files
  5. Click Save.
  6. Back on the Share with others modal, click Copy link to copy your sharing link.copy your shared link
  7. Click Done to close the Share with others modal.
  1. Start by creating the sharing link. We recommend using our link generator tool to receive a direct download link.

    Enter your generated link from Google in the Enter Share Link field and click Generate.generate your download link
  2. Next we'll need to change the generated URL because this link will download in PDF format by default. Copy the generated URL and paste into a text editor.copy the generated url
  3. To make it download in .xlsx format, change the end of the URL from ?format=pdf to ?format=xlsx.


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

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

    Example final Geckoboard-friendly link in .xlsx download format:
  4. Now you're ready to use the edited link in Geckoboard!

    Hover your cursor over the dashboard square you would like to position your new widget and click the + button.
  5. Search for Spreadsheets using the Search sources field.

    Alternatively, you can also click the Spreadsheets button.add widget spreadsheets
  6. From the Choose File menu, click on the link  icon.Choose your Excel file from a direct link
  7. Copy and Paste your URL in the Link to file field.Choose your Excel file from the direct link field
  8. You can now continue updating your Google Sheet as usual and it will automatically sync with Geckoboard via the generated link.

Suggested next step

Now that you've linked up your spreadsheet with Geckoboard, you can now begin creating visualizations using your spreadsheet.

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


  • Hariharan Customer Success Avatar


  • Fernanda Customer Success Avatar


  • Luis Customer Success Avatar


  • Richard Customer Success Avatar


  • Fernanda Customer Success Avatar


  • Heather Customer Success Avatar


  • Heather Customer Success Avatar