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 ?
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.
@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!
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.
5 Replies
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 ?
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.
@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!
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.
Also looking for a solution to this.