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

Learn how to seamlessly integrate Academy LMS registrations into Google Sheets using Pabbly Connect for efficient data management. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add Academy LMS registrations to Google Sheets, the first step is to access Pabbly Connect. This platform enables the seamless integration of various applications, including Academy LMS and Google Sheets.

As an existing user, you can sign in to your Pabbly Connect account. If you are new, click on the ‘Sign up for free’ button to create an account. Once logged in, navigate to the ‘All Applications’ page and select Pabbly Connect to reach your dashboard.

2. Creating a Workflow in Pabbly Connect

In this section, we will create a new workflow in Pabbly Connect to automate the registration process. Click on the ‘Create Workflow’ button on the right side of your dashboard.

• Name your workflow, e.g., ‘Add Academy LMS Registrations to Google Sheets’.
• Choose a folder to save your workflow, such as ‘Academy LMS’.
• Click on the ‘Create’ button to proceed.

After creating the workflow, you will see a window for setting up the trigger and action. Remember, Pabbly Connect operates on the trigger-action principle, where the trigger initiates the action.

3. Setting Up Trigger for Academy LMS

To set up the trigger in Pabbly Connect, search for ‘Academy LMS’ as your trigger application. The trigger event will be ‘New Student Registration’. This means that whenever a new student registers, the workflow will activate.

After selecting the trigger, Pabbly Connect will provide a webhook URL. This URL acts as a bridge between Academy LMS and Pabbly Connect. You will need to copy this URL to establish a connection in your Academy LMS settings.

4. Connecting Academy LMS to Pabbly Connect

Next, navigate to your Academy LMS plugin in WordPress. Go to the ‘Add-ons’ section and find the ‘Webhooks’ option. Here, you will add the webhook URL provided by Pabbly Connect.

• Click on ‘Add Webhook’.
• Enter a title for the webhook, e.g., ‘New Registration’.
• Set the status to ‘Published’ and choose the event as ‘New Student Registration’.
• Paste the webhook URL and click ‘Add Webhook’.

Once the webhook is created, Pabbly Connect will wait for a response. You can test this by registering a new student in the Academy LMS.

5. Adding Registration Details to Google Sheets

After successfully setting up the trigger, the next step is to add the registration details to Google Sheets. In Pabbly Connect, select ‘Google Sheets’ as your action application.

Choose the action event as ‘Add New Row’. You will need to connect your Google account to Pabbly Connect. After successful authorization, select the spreadsheet where you want to store the data and map the fields from the registration response.

Map the ID, Name, and Email from the response. Click on ‘Save & Test Request’ to ensure everything is working correctly.

Once you have tested the request, check your Google Sheets to see if the new registrant’s details have been added successfully. This confirms that the integration between Academy LMS and Google Sheets via Pabbly Connect is working perfectly.

Conclusion

In this tutorial, we explored how to integrate Academy LMS registrations into Google Sheets using Pabbly Connect. This powerful platform enables seamless automation, ensuring that every new registration is recorded efficiently. Now you can manage your data effortlessly!