Forum Discussion
Exporting variables from Storyline 360 to Google Sheets
Hi All
I've seen some of the old posts from Katie Robinson on doing this - but I cannot get it to work.
Please can someone help with some 'novice' code.
5 Replies
- AngelaDemmerCommunity Member
Same here. I had it working with a previous version from 2019, but the same scripts no longer work. I have verified that my previously published web story works, but not the story published today. Hmmmmm. Did you ever get a resolution ?
- TrevorLaForce-aCommunity Member
Hello both,
We are also having this issue. Projects from as recently as this summer were a breeze to set up, for for some reason but it's a struggle now. Older projects continue to work fine.
Unfortunately testing new web apps return {"result":"success","row":2} but nothing is written to the cells. I should be getting a row of "Undefined" values when testing the web app, I believe. Either way, nothing is written out to the spreadsheet when I use the scripts in my Storyline projects.
There is an alternate method floating around using Google Forms as an intermediary, so I'm going to try that and see if it'll work any better.
EDIT: That alternate method is no longer viable, as it's from 2016 and it seems as though Forms has changed enough since then that the necessary info about individual form fields is obscured. Too bad.
- JenniferPage-85Community Member
@Lucia, did you end up getting this to work? I'm trying to do the same thing but not having any luck. I'd love to get some sample code (both for the google sheet and the js for storyline) if anyone out there has it!
- MariaCSStaff
Hi, Jennifer.
Lucia might not be subscribed to this discussion, but you're welcome to contact them directly through their profile by clicking on their name and selecting Contact Me.
- K4InteractiveCommunity Member
Also looking for a solution to this.