Integrate LearnWorlds Purchases to Google Sheets with Pabbly Connect

Learn how to integrate LearnWorlds purchases to Google Sheets using Pabbly Connect step-by-step. Automate your workflow seamlessly! Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating LearnWorlds purchases into Google Sheets, first access Pabbly Connect. Visit the Pabbly website by typing ‘Pabbly.com’ into your browser. If you are a new user, click on the ‘Sign Up for Free’ button to create an account. Existing users can simply click on ‘Sign In’ to access their dashboard.

Once logged in, navigate to the ‘All Apps’ section and select Pabbly Connect. Click on ‘Access Now’ to enter the dashboard where you can create a new workflow for your integration.

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the plus sign to create a new workflow. Name your workflow something descriptive, such as ‘Add LearnWorlds Purchase to Google Sheets’. After naming your workflow, click on ‘Create’ to proceed.

You will see two windows: a trigger window and an action window. In this case, your trigger application is LearnWorlds, and the action application is Google Sheets. This means that whenever a new purchase is made on LearnWorlds, the details will be sent to Google Sheets.

• Click on the trigger window and select the application as LearnWorlds.
• Choose the trigger event as ‘New Purchase’.
• Copy the Webhook URL provided by Pabbly Connect.

After setting up the trigger, follow the instructions to configure the webhook in your LearnWorlds account.

3. Configuring LearnWorlds for Webhook

To configure LearnWorlds, log into your LearnWorlds account and go to ‘Settings’. Under the ‘Integrations’ section, find ‘Webhooks’ and click on it. Activate the option for when products are bought by checking the active checkbox.

Paste the webhook URL copied from Pabbly Connect into the designated field and click on ‘Save’. This step ensures that LearnWorlds sends purchase data to your Pabbly Connect workflow whenever a new course is purchased.

4. Testing the Integration with a Purchase

To test the integration, make a test purchase on LearnWorlds. Navigate to the courses section, find a course, and click on the preview link. Open the link in incognito mode to simulate a new user experience.

Fill in the necessary details for a new user, including name, email, and password, and complete the purchase. After the payment is successful, return to Pabbly Connect to check if the data has been captured correctly.

• Verify that the response received includes all the purchase details.
• Ensure you capture details like product name, price, and customer information.

This confirms that Pabbly Connect is successfully receiving purchase data from LearnWorlds.

5. Adding Purchase Data to Google Sheets

Now that you have tested the trigger successfully, it’s time to add the purchase data to Google Sheets. In the action window of Pabbly Connect, select Google Sheets as the application and choose the action event as ‘Add New Row’.

Connect your Google Sheets account to Pabbly Connect by clicking on ‘Connect’ and authorizing access. Once connected, select the spreadsheet where you want the data to be added. Map the fields from the LearnWorlds response to the corresponding columns in your Google Sheets, such as payment date, invoice number, user name, email address, course name, and amount.

After mapping the required fields, click on ‘Save and Send Test Request’ to verify that the data is successfully added to your Google Sheets. You can check your spreadsheet to confirm that the new purchase details appear correctly.

Conclusion

By following these steps, you can seamlessly integrate LearnWorlds purchases into Google Sheets using Pabbly Connect. This automation allows you to manage your sales data efficiently and keep track of customer purchases automatically. With Pabbly Connect, you can create various integrations and enhance your workflow effortlessly.