I've seen Tom's helpful screencast on how to embed a Google docs form into a Storyline project. However, what I want to do is a little different. I'd like to be able to export the values of about a dozen variables from Storyline so I could see them in a spreadsheet the way I would if students entered those values into a Google docs form. I've got a grammar assessment, and I want to export a student's name and either OK/NEED TO REVIEW/MIGHT WANT TO REVIEW for each of a dozen or so topics. Now, I could just use a final page screen in Storyline showing a student her status on these dozen topics and ask her to fill out an embedded Google docs form in which she basically copies the results manually. These are just initial assessment scores, and I'm not worried about honesty issues. However, this seems like a pretty klutzy way to do things. Would anyone be able to help me out with a suggestion for a better method? I don't know any JavaScript, and my familiarity with Storyline is fairly low. Thanks! Dorothy

Sending data from Storyline using variables to a Google spreadsheet can be done...and quite effectively, too. I just finished a project doing this very thing. First is setting up a Google Script. In Storyline you'll need to write a Javascript that will read all the variables and fire the data off. In our project we had over 50 questions each with 3 possible choices. We wanted to see the result (choice1, choice2, or chioce3) for each of the questions. The neat thing is the Google Spreadsheet would update dynamically. We tested several outputs including a stand alone Storyline output on a web server, Storyline published as SCORM on an LMS, Storyline published for AO, and Storyline as a web object in a Studio '09 output in both SCORM and AO. Same project all sending data to the same spreadsheet while multiple users were accessing the various platforms and being able to literally watch the spreadsheet as it fills up.

Hi everyone, My solutions for this is here. Helpful link to do this solve in Storyline is here. You will find there solution to send date from html form to google spreadsheet. To implemnt this in Storyline you will need this link. I hope it's helpful.

oh noo :( I'm really sorry that I did not respond earlier but I had no access to the Internet - long duration holidays. I don't know if I can do it but I have saved this page for all of you to pdf. There is note who is author of this article. Function in Storyline can look like this (you can put it on Click event or timline starts): var player = GetPlayer(); $.ajax({ url: "https://docs.google.com/forms/d/XXXXXXXXXXXXXXXXXXX/formResponse", type: "POST", data: {"entry.yyyyy" :player.GetVar("your_verible1"), "entry.zzzzz":player.GetVar("your_verible2")}, success: function(data) { alert(data); } }); return false; XXXXXXXXXXXXXXXXXXX - must be replaced by the form key (for more details chceck pdf file) yyyyy, zzzzz - must be replaced by number from your's google form. You can find it with firebug (for more details chceck pdf file) your_verible1, your_verible1 - veribles from Storyline If you want to check how it is work you have to put content on server.

Here is my take on using GoogleDocs with Storyline variables: http://dev.keypointlearn.com/xcl71_SL/Soccer/story.html

I just posted, what I hope, is a step-by-step guide for making this work. I based it on the posts here and what I learned from them gathering them together. There were a few of us that needed steps from the beginning and others that needed them only part way through. Hope this helps anyone new to this particular forum. http://www.tracyparish.ca/2015/08/how-to-send-variables-from-storyline-to-google-docs.html

exporting variables to be read in a Google docs spreadsheet

LeslieMcKerchie
Staff
8 years ago
Glad that this thread was able to assist you as well Benoit :)
Innowijs
Community Member
7 years ago
Hi Tracy,

I've followed your instructions step by step. But somehow it won't work with me.
For this story module I used Storyline 360 and Google Chrome as browser.

Could you please help me with this? I've attached the storyline file and a screenshot of how the js is triggered.
storyline-to-google-forms.zip21 KB
SameekshaMis875
Community Member
7 years ago
Hi,

Is there any code which can store storyline 360 variables like score in excel sheet? Let me know if anyone has done this before.

Thanks!
KengHweeWee
Community Member
5 years ago
I am totally new to html. Can you tell me how to include the latest script version in he story.html?

Thanks
- TracyParish
  Super Hero
  5 years ago
  
  Keng Hwee Wee
  
  I am totally new to html. Can you tell me how to include the latest script version in he story.html?
  
  Thanks
  
  I've been using this method now without fail. Just this past fall used it. I can't remember all the details of my own post that is linked above, but Matthew's method works. Let me know if you have trouble.
  
  https://www.youtube.com/watch?v=5V2pvtFGeyY
  - KengHweeWee
    Community Member
    5 years ago
    Thanks for the reply.
    
    I follow every step in the instruction but still cannot get the variables
    posted to the Google Sheet.
    
    Please advise
    
    Regards
    
    KH Wee
SherriSagers-ca
Community Member
4 years ago
Tracy's links are no longer valid so I'm trying to cobble things together using the YouTube video she links to above. Is there a new "script.src" link we should be using?
- SherriSagers-ca
  Community Member
  4 years ago
  I got it to work! Here's the first JavaScript that needs to be executed at the beginning of the Storyline file:
  
  var head = document.getElementsByTagName("head")[0];
  var script = document.createElement('script');
  script.src = 'https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js';
  script.type = 'text/javascript';
  head.appendChild(script);
  - BeccaLevan
    Community Member
    4 years ago
    Awesome Sherri! Happy you got this to work, and so kind of you to come back and share it with the community!
SherriSagers1
Community Member
4 years ago
This video by Dmitry M explains another way to export variables from Storyline to Google Sheets. His method requires executing only one JavaScript file: https://youtu.be/g8_Ns6k-K8k
- MuhammodAlaa
  Community Member
  4 years ago
  
  Sherri Sagers
  
  This video by Dmitry M explains another way to export variables from Storyline to Google Sheets. His method requires executing only one JavaScript file: https://youtu.be/g8_Ns6k-K8k
  
  It seems this video isn't available anymore :/
  - SherriSagers-ca
    Community Member
    4 years ago
    I'm sorry it's gone, Muhammod! I checked and couldn't find it, either. That's really sad because I thought it was an even better solution since it only required one JavaScript file.