Integrate Academy LMS Course Enrollments into Google Sheets with Pabbly Connect

Learn how to seamlessly integrate Academy LMS course enrollments into Google Sheets using Pabbly Connect. Step-by-step tutorial for effective automation. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Academy LMS Integration

To begin integrating Academy LMS course enrollments into Google Sheets, you need to access Pabbly Connect. Start by signing in to your existing account or create a new one if you are a first-time user. Pabbly Connect allows you to automate tasks seamlessly between different applications.

After signing in, navigate to the applications page. Here, you will find all the tools available for integration. Click on the Pabbly Connect option to reach your dashboard, where you can create a new workflow for your integration.

2. Creating a New Workflow in Pabbly Connect

To set up your integration, click on the Pabbly Connect dashboard and select the Create Workflow button in the top right corner. This will open a dialog box where you can name your workflow. Name it something descriptive, such as ‘Add Academy LMS Enrolled Students in Google Sheets’.

• Choose a folder to save your workflow, for instance, the folder named Academy LMS.
• Click on the Create button to proceed to the next step.

Now, you will see the trigger and action setup window. In this section, you will define the trigger application as Academy LMS and the action application as Google Sheets. This setup is crucial as it determines what happens when a new enrollment occurs.

3. Setting Up Trigger and Action Applications

In the trigger section, select Academy LMS as your trigger application and choose the trigger event as New Enrollment. This means that every time a student enrolls in a course, this trigger will activate.

Next, move to the action section and select Google Sheets as your action application. Here, the action event you want to choose is Add New Row. This configuration will ensure that the details of the enrolled student are automatically added to your Google Sheet whenever a new enrollment occurs.

• Copy the webhook URL provided by Pabbly Connect for the integration.
• This URL will be used to connect Academy LMS with Pabbly Connect.

Once you have configured the trigger and action, you can proceed to set up the webhook in your Academy LMS plugin on WordPress.

4. Setting Up Webhook in Academy LMS

To connect Academy LMS with Pabbly Connect, navigate to the add-ons section in your WordPress dashboard. Scroll down to find the webhooks option and click on it. Here, you will see an option to Add New Webhook.

In the webhook setup window, provide a title for your webhook, such as ‘New Enrollment’. Set the status to published and select the event as New Enroll. Then, paste the webhook URL you copied earlier from Pabbly Connect into the delivery URL field.

After completing these steps, click on the Add Webhook button. Your webhook is now created and is waiting for a response. This means that the next step is to test the webhook by creating a new enrollment in your Academy LMS.

5. Testing the Integration with a New Enrollment

To test the integration, open an incognito window and enroll a new student in one of your courses, such as ‘Core PHP’. Fill in the required details, including first name, last name, username, email, and password, and complete the registration process.

Once the enrollment is successful, go back to Pabbly Connect to check if the details are captured correctly. You should see the student’s name, email, and the course they enrolled in. This confirms that the trigger is working correctly and that the data is being captured in real-time.

Now, go back to Google Sheets and check if the new enrollment details have been added to the specified sheet. You should see a new row with the user ID, name, email, and course information.

This process demonstrates how Pabbly Connect effectively automates the task of adding enrollments from Academy LMS directly into Google Sheets, streamlining your workflow.

Conclusion

Integrating Academy LMS course enrollments into Google Sheets using Pabbly Connect simplifies data management. This step-by-step guide ensures that every new enrollment is automatically recorded, enhancing your operational efficiency.