Articulate Storyline: Export to Google Drive

You do need a table or normal HTML element to push Sheetsrock data into. But you can hide that element and use the Google sheet data in other Storyline elements. For that you need this code.

$('#googleSheetTable').sheetrock({
  url: googleSheet,
  callback: function(error,options,response){
    console.log(response.rows[1]);
  },
  query: "select A,B,C,D,E,F where D is not null order by D desc",
   fetchSize: 10,
});

This adds a callback with a function in it. In that function you can capture the response and do anything wanted with the data. In the above sample the row with the top score is captured to the console.