How to Add Academy LMS Registrations to Google Sheets Using Pabbly Connect

Learn how to integrate Academy LMS with Google Sheets using Pabbly Connect for automatic registration updates. Step-by-step tutorial included. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add Academy LMS registrations to Google Sheets, you need to access Pabbly Connect. First, go to the Pabbly Connect homepage. If you are an existing user, sign in; otherwise, click on the ‘Sign Up for Free’ button to create a new account.

Once logged in, navigate to the applications page and click on ‘Access Now’ under Pabbly Connect. This will take you to your dashboard where you can create a new workflow.

2. Creating a New Workflow in Pabbly Connect

In your Pabbly Connect dashboard, click on the ‘Create Workflow’ button. Name your workflow something descriptive, like ‘Add Academy LMS Registrations to Google Sheets’. You can also organize your workflows into folders for easier management.

To set up the integration, you need to define a trigger and an action. The trigger will be from Academy LMS, and the action will be to add a new row in Google Sheets. This setup is crucial for automating the registration process.

• Click on ‘Create Workflow’ and name it accordingly.
• Define your trigger application as Academy LMS.
• Set the action application to Google Sheets.

After setting the trigger and action, you are ready to establish the connection between Academy LMS and Pabbly Connect.

3. Connecting Academy LMS to Pabbly Connect

To connect Academy LMS, you will need a webhook URL provided by Pabbly Connect. This URL acts as a bridge between Academy LMS and Pabbly Connect. Copy the webhook URL and head to your Academy LMS plugin in WordPress.

In your WordPress dashboard, go to the add-ons section, scroll down to the webhooks option, and click on ‘Add Webhook’. Here, you will input the webhook title and set the status to published. Ensure the event is set to ‘New Student Registration’ and paste the webhook URL in the delivery URL field.

• Go to the add-ons section in Academy LMS.
• Click ‘Add Webhook’ and fill in the required fields.
• Paste the webhook URL from Pabbly Connect.

After successfully adding the webhook, Pabbly Connect will wait for a response, indicating that your integration is now set up to capture new registrations.

4. Testing the Integration from Academy LMS

To verify that your integration works, you need to create a test registration in Academy LMS. Open your course in incognito mode and click on the ‘Enroll Now’ button. If you do not have an account, you will need to register.

Fill out the registration form with your details such as first name, last name, username, and email. Once you submit the registration, Pabbly Connect should capture the new registrant’s details. You will see a response indicating that the registration was successful.

Open your course in incognito mode. Click ‘Enroll Now’ and complete the registration form. Submit the form to test the integration.

After the test submission, check Pabbly Connect for the captured data, confirming that the integration is functioning correctly.

5. Adding Registrant Details to Google Sheets

Now that you have verified the integration, it’s time to add the captured registration details to Google Sheets. In Pabbly Connect, establish a connection to your Google account. Click on ‘Connect’ and authorize Pabbly Connect to access your Google Sheets.

Select the spreadsheet where you want to store the registrations. Use the mapping feature to insert the data from the previous step into the appropriate columns in Google Sheets. This ensures that every new registration is automatically added to your sheet.

Click ‘Connect’ to link your Google account. Select the spreadsheet and map the fields for ID, Name, and Email. Save and test the request to confirm data is added.

Upon successful mapping, you will see the new registrant’s details added to your Google Sheets, completing the integration process through Pabbly Connect.

Conclusion

Integrating Academy LMS with Google Sheets using Pabbly Connect allows for seamless automation of registration updates. This tutorial provided a detailed step-by-step guide to set up the integration effectively.