×

Google Sheets eLearning Widget

for Articulate Storyline and Adobe Captivate

This widget allows to export and save data entered by the learner or generated in the learning course. The data can be both imported and exported to/from Google Sheets.

You can save and access all learning records from Google Sheets as well as pull data back into the course if needed. The ability to save records to Google Sheets provides a great way to have the data at your fingertips in a clean and easy-to-read format. You will connect your Sheets document first, and will then use triggers in Articulate Storyline or actions in Adobe Captivate to pass the data from the course to the spreadsheet.

Demo #1 - Saving data to Google Sheets

Demo #2 - Using data from Google Sheets

eLearning Widgets for Articulate Storyline and Adobe Captivate

Pricing

Free to process up to 100 data points per month, paid plans start from $6.95/month.

Use Case Example

Marla is an instructional designer building a compliance elearning course. She wants to know whether the learners click on the optional “Learn More” button on one of the slides, and how this action correlates with the final quiz scores.

Marla sets up a spreadsheet with two columns:

  • “Clicked” – a column that will indicate whether the learner clicked on the button, and,
  • “Score” – a column that will store the learner’s final score.

She then adds a trigger in Storyline to set the value of “Clicked” to True whenever the button is clicked. She also adds a trigger to set the value of “Score” to the number of points the learner scored in the quiz.

Marla deploys her course, and as learners complete it, she keeps an eye on the records populating in the spreadsheet to find out whether clicking the button results in higher quiz scores.

Google Sheets FAQs

How can I save learners' scores in Google Sheets without using a learning management system?
Use the Google Sheets elearning widget to directly capture scores from your elearning course and store them in Google Sheets. This integration provides a seamless way to review and analyze scores, enabling a comprehensive assessment of learner performance without an LMS.
How can I use Google Sheets to track a learner's progress throughout a course?
The Google Sheets elearning widget allows logging each step a learner takes within the course and store this data in Google Sheets. This method provides detailed insights into learner progress, helping you identify areas where they excel or need additional support.
Can I store responses from quizzes in Google Sheets?
Yes, use the Google Sheets elearning widget to save responses to knowledge checks directly in Google Sheets. This feature enables you to analyze learner responses to understand learning patterns and dynamically adjust course content based on learner feedback.
How can I record and analyze learner actions within my course using Google Sheets?
By using JavaScript triggers in Storyline or actions in Captivate, you can record each interaction learners have with the course material, such as clicks on links or resources accessed. This data is stored in Google Sheets and is invaluable for evaluating engagement and effectiveness of the content.
What tools allow using Google Sheets to monitor how learners utilize the course?
The Google Sheets elearning widget can help gather comprehensive data on how learners interact with different parts of the course, storing this data in Google Sheets for easy access and analysis. This enables you to optimize the course structure based on actual usage patterns.
How can I track custom variables in my elearning course using Google Sheets?
Custom variables such as learner choices and path decisions can be efficiently tracked and recorded in Google Sheets using the Google Sheets elearning widget. This allows for detailed customization and refinement of the learning experience based on specific course requirements.

Google Sheets Widget Tutorial