Importing Variables into Storyline From Google Sheets

Hi all,

So I have a robust elearning program with various modules and quizzes. Each quiz builds onto the other, so most questions are asked a total of 3-4 times. Each response is being recorded in a Google Sheet from a post I read on this site, but now I want to know how to import a variable from Google Sheet into Storyline.

My goal is to create a page in Storyline at the end that’s like a report card. First, I’ll have Google Sheets tally up the total scores for each category in the program, and then I want it to spit out that value for that particular employee. It’s kind of like a vlookup, in the sense that it’s going to the spreadsheet, finding an employee ID # and then reporting that person’s score. Any tips or resources to share on how to make this work with JavaScript?

Thanks, in advance, for the support!

-Kyle