Publish & update files from Google Sheets

Using Google Drive to host your files, but still want to publish data on for easy sharing, collaboration, visualization, and querying? No problem!

When a file is added to your Google Drive, you can setup a link from Google to to easily update it on-demand with the following steps. Note: these instructions are specific to Google Sheets:

  1. Create your dataset container on
  2. Add files to your dataset
  3. Setup an update script

Create your dataset container on

  1. Login to
  2. Click '+ Add datasets' at the top of any page.

    alt text

  3. Name your dataset, select Open or Private and click Create dataset. Note that you don't need to add files through the interface. We'll add them in the next step.

Add files to your dataset:

Add files to your dataset with the published Google Drive link using the following command:

  curl<username>/<datasetName>/files \
    -H 'Content-Type: application/json' \
    -H 'Authorization: Bearer <MY-API-TOKEN>' \
    --data-binary '{"files": [
        { "name": "<fileName1>", "source": {"url": "<sourceURL1>" }},
        { "name": "<fileName2>", "source": {"url": "<sourceURL2>" }}
       ] }'


  • username is the dataset owner username. Note you must have permissions to modify the dataset if not the owner.
  • datasetName is the id of the dataset. This can be found in the URL path of the dataset.
  • MY-API-TOKEN can be found under your profile settings within, or by going to
  • fileName is what you'd like to name the file, and should include the file extension.
  • sourceURL is the sharable Google Drive link (see tip below).


    To get the sharable Google Drive url, go to the file on Google and:

    • Click on the Share button in the top-right corner of your file:

    Google Drive Sharing

    • Select the link sharing option. It must be set to either Public on the Web or Anyone with the link. Access can be edit / comment / or view:

    Google Link Sharing Options

    • Click Copy Link:

    Google Copy Link

Create a Google script to control the sync to

Complete this step for each file you've added to your dataset and would like to sync on-demand:

  1. Within the Google Sheet, go to Tools > Script editor.
  2. Copy the following script and replace the username, datasetName and myApiToken variables with the relevant values and save the script.

    function onOpen() {
    var ui = SpreadsheetApp.getUi(); // Or DocumentApp or FormApp.
     .addItem('Sync file', 'menuItem1')
    function menuItem1() {
    var username = 'username';
    var datasetName = 'datasetName';
    var myApiToken = 'myApiToken';
    var headers = {
     'Authorization': 'Bearer ' + myApiToken,
     'Content-type': 'application/x-www-form-urlencoded'
    var url = '' + username + '/' + datasetName + '/sync';  
    var options = {
     'method': 'post',
     'headers': headers
    var response = UrlFetchApp.fetch(url, options);  
    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
  3. Refresh your spreadsheet and you should now see a ‘’ menu with a 'Sync file' option.
  4. Anytime your file changes you'd like to push the new version to your dataset, just select > sync file.
    Note: you might be prompted to authorize the push using your Google account.

That's it! Add the Google Script to any files you'd like to keep up to date with the click of a button.

results matching ""

    No results matching ""