Forum Discussion

BastiaanTimmer's avatar
BastiaanTimmer
Partner
11 years ago

Articulate Storyline: Export to Google Drive

PREVIEW  |  SOURCE On the Articulate user days in Utrecht (2015), we held a session about exporting Articulate Storyline variables to Google Drive (Spreadsheet). This export is achieved via...
storyline 360
VanessaBarnes-b's avatar
VanessaBarnes-b
Community Member
5 years ago

Woohoo! I tried again but left the google sheet set to restricted. It's working now. The folder that the sheet sits in is also set to restricted. 

If I need to give clients access to the sheet via a link, I keep the original google sheet as a backup and start a new sheet that pulls data in from the backup sheet. To do this:

  • Leave the new sheet completely blank, don't add any headings
  • Set the new sheet to editable by anyone
  • Then paste the following into the top-left cell, but replace SHEETID with the ID of your backup sheet, and replace D with the letter that corresponds with how many columns you have (if you have 2 columns it should be B, 3 columns it should be C, and so on):

    =QUERY({IMPORTRANGE("SHEETID", "DATA!$A$1:$D")},"SELECT * WHERE Col1 is not null",1)

Note: The new sheet may have a pop up asking you to confirm that you want to connect the sheets.