Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

We are using LearnWorlds for our LMS and after each course, students submit feedback. We usually export the data into GSheet to share with stakeholders/leaders so they can retrieve insight into their learners progress, topics, and learning.

Right now, I am automating this process by creating a single zap for each course, by customer. This can range from 6 to 13 courses in our customized programs, which would mean 6-13 individual zaps just to collect course feedback automatically.

I’d like to know if we can create 1 zap to pull from a list of course feedback submission forms into a single GSheet, rather than 6 to 13 individual zaps, per customer. If we have 3 customers that is almost 40 zaps just for automating feedback.

Is there a way to select multiple submission forms into 1 zap? A better way to do it than manually exporting data from LW reporting suite?

Hi @AnnieStefano 

Good question.

Perhaps to help us have more context, you can provide screenshots of how your Zap steps are currently configured, so we know what Zap triggers/actions you are using.

Hi @AnnieStefano!

There are definitely ways that you can do this, both using a Zap for each course and using some other features to combine them into fewer Zaps. If you want to try and combine things into fewer Zaps, it will make the process of setting it up more complicated. 

Off the top of my head, the way that I would do this would be to make use of Google Slides’ Refresh Chart action. With that, you can set up a presentation (eg one presentation per tutor, with multiple pages for each course) that charts that show the feedback. 

You could then set up a Google Sheet so that it generates each chart based on the feedback from courses, there you would need 1 sheet per course - is that how the data is exported or is it mixed? If it’s mixed, you might be able to use a VLOOKUP formula to pull the relevant information into another column/sheet. You can then create charts from that information that link to the Google Slides presentations that you created. 

Each time you get a new export from the LMS, update the Google Sheet and trigger a Zap from that. That will then update all the charts in the presentations and you can also save the file of each of the sheets as a pdf and email them straight to the relevant people. 

As I said, that wouldn’t be a simple one, but it sounds like it could save you a lot of time!

 

Let us know if you have any questions or would like to look for another way!

 

 

 

Terms & Conditions