Exporting Variables into a Google Spreadsheet

If you don't want to use the iFrame method, you can use Jquery pretty easily. I don't like to do post publish surgery so I use a bit of Javascript to jack jquery into the head of the document at runtime. Note that you need to load this well ahead of your AJAX calls. Don't try to load this and your AJAX call in the same trigger. 

function add_script(scriptURL,oID) {
var scriptEl = document.createElement("script");
var head=document.getElementsByTagName('head')[0];
scriptEl.type = "text/javascript";
scriptEl.src = scriptURL;
scriptEl.id=oID;
head.appendChild(scriptEl);}

//only want to add these once!

if(document.getElementById('jquery')==null){
add_script("https://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js","jquery");
}

In a separate trigger (give it some time after your JQUERY head load):

var player=GetPlayer();
var vStudent=player.GetVar("studentName");
var vSupervisor=player.GetVar("supervisorName");
var vFacility=player.GetVar("facilityName");

var fTarget="https://docs.google.com/a/nara.gov/forms/d/YOURUNIQUEFORMID/formResponse";

function submit_form(){

$.ajax({
url: fTarget,
type: "GET",
data: {"entry.1481580269" :vStudent,"entry.1244291729":vSupervisor,"entry.2088465962":vFacility},

success: function(data) {
//won't return since it's cross domain
}

});
return false;

}
setTimeout(submit_form(), 2000);

@Steve, you're a genius. How did you ever figure out the form entry ID thing? That's brilliant.

@ Ken. I tried following all the instructions and still struggled.

I came across this website 

https://helpdesk.courseware.nl/hc/en-us/articles/205740482-Articulate-Storyline-Export-to-Google-Drive

It has a built in template that can be used for your projects. I haven't had any problems but anything can happen.

Hope this helps.

Thanks Alison for sharing that - and it's worth noting that as of August, Google Drive no longer allowed for hosting of HTML files. With that in mind, you'll want to look at a web server such as Amazon S3 - we've got a great tutorial on this here. 

Thank you Alison, I've been working on this and  followed the example exactly, even had a 'tech' guy look at my work and we're still not having any success.

This is hosted on wordpress and the site is Http:// not Https:// .  Someone told me that wordpress might strip all scripts.

In the process of setting up another server for testing, I'll let you know.

Actually I found the problem.  I had one variable that was killing the script.  Renamed it to shorter less cryptic name.  Got things exporting fine.

Thanks for everyone's help.  Actually it pretty simple once you past the 'brain freeze'

Thanks Ken for that update and I'm happy to hear you were able to figure it out! 

Thanks for the great tutorial.

a) Will it work for concurrent users ? I have several users taking the course at same time ?Will it create a seperate row in Google Spreadsheet for each user ? or overwrite in the same row ?

b) The most important aspect i want is that the same row in the sheet should be used for a particular user for that specific attempt / session. Not create a new row for the same session whenever the javascript trigger is executed in Storyline. The JS trigger is set on each question slide to keep track where the user has left the course if he/ she exits the course halfway without completing it. Currently it creates a new row for each question.

A) Yes. It will work for concurrent users.

B) The spreadsheet has no way to know if it's the same user. However, you can use formulas to find =Unique() from one sheet to another and get the last value or a calculated value.

For anyone following along, I wanted to let you know that Abhishek asked a similar question here as well.