How to Send Learnyst Transaction Details to Google Sheets Using Pabbly Connect

Learn how to send Learnyst transaction details to Google Sheets seamlessly using Pabbly Connect. Follow our step-by-step guide for easy integration. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To send Learnyst transaction details to Google Sheets, first access Pabbly Connect. Open your browser and type the URL Pabbly.com/connect to reach the landing page of this integration platform.

On the landing page, you’ll see options to sign in or sign up for free. If you are a new user, click on ‘Sign Up’, which takes less than two minutes. Existing users can simply click ‘Sign In’ to access their accounts.

2. Creating a Workflow in Pabbly Connect

After signing into Pabbly Connect, navigate to the dashboard where you will see an option to create a workflow. Click on ‘Create Workflow’ and name it ‘Send Learnyst Transaction Details to Google Sheets’. This name reflects the objective of the integration.

Upon naming your workflow, you will be presented with two significant events: Trigger and Action. The trigger application will be Learnyst, and the action application will be Google Sheets. Select Learnyst as the trigger application and choose the event ‘Purchase’ as the trigger event.

3. Setting Up the Webhook for Learnyst

Once you select the Purchase trigger, Pabbly Connect generates a webhook URL. This URL acts as a bridge, enabling Learnyst to send transaction details to Pabbly Connect.

Copy the webhook URL and navigate to your Learnyst account. Go to Marketing > Integrations > Pabbly, and paste the webhook URL in the designated field. Click on ‘Test and Save’ to complete the setup. This step ensures that Learnyst can successfully communicate with Pabbly Connect.

4. Capturing the Webhook Response in Pabbly Connect

After setting up the webhook, go back to Pabbly Connect and click on ‘Recapture Webhook Response’. This requires a test submission to verify that the data is being sent correctly. Perform a transaction on Learnyst to trigger the webhook.

Once the transaction is completed, return to Pabbly Connect to check if the webhook response has been captured. You should see details such as the username, email address, transaction ID, product name, price, and creation date. If the date format is not suitable, you can format it using the DateTime Formatter feature in Pabbly Connect.

5. Adding Google Sheets Action in Pabbly Connect

The final step involves adding Google Sheets as the action application in Pabbly Connect. Select ‘Add New Row’ as the action event. You will need to connect your Google Sheets account by authorizing Pabbly Connect to access it.

After connecting, map the necessary fields such as learner name, email address, course name, amount paid, and enrollment date. Once the mapping is complete, click on ‘Save and Send Test Request’. This action will send the transaction details to your Google Sheet, confirming the integration was successful.

Conclusion

In this tutorial, we demonstrated how to send Learnyst transaction details to Google Sheets using Pabbly Connect. This integration automates the process, ensuring that every transaction is recorded seamlessly in your spreadsheet. By following these steps, you can easily manage your transaction data without any manual effort.