Forum Discussion
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...
Hi Alison,
I'm afraid my problem seemed to 'resolve itself', in that I created a new Google Sheet from scratch and followed the instructions above. When you run your eLearn and check your report, do you see the words "undefined" in any of your fields? Or does nothing appear at all?
One possible troubleshooting method you may try is the following:
In the Script Editor for your Google Sheet (where you've copied and pasted the code), click on Publish, then Deploy as Web App. You'll notice that the box at the top displays your current web app URL, but also has a button labelled "Test web app for your latest code". Give that a click, and see what happens. If the test returns successfully, you'll see the words "undefined" have appeared in your spreadsheet.
If this happens, that means the report itself is set up correctly, and the issue may lie in the Javascript within your Storyline project. If the test does not run successfully, it might be an issue with the sheet itself.
Hope this makes sense! Feel free to let me know if you need more clarification. Good luck getting this issue fixed up.
Cheers,
MB
Hi Mark
I will definitely give it a try. The issue is that nothing appears at all. I know about the "undefined" issue, I have had that before and could resolve it. I did try creating a new sheet, a couple of times. I even used a previous sheet and copied that and just added the new variables, and still nothing.
I think it might be something in SL, I don't know, but I will look at everything again.
Thanks for the help.
Hi Alison,
I've tried my existing exported storyline project that is connected to a google sheet database using the method above and it's working properly.
I haven't checked a new google sheet. I hope this helps.
Thanks,
Jack
