Integrate Google Sheets with Knorish Course Using Pabbly Connect

Learn how to automate user addition in Knorish courses from Google Sheets rows using Pabbly Connect in this detailed step-by-step tutorial. 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 begin integrating Google Sheets with Knorish using Pabbly Connect, first, navigate to the Pabbly Connect website. You can sign in if you already have an account or create a new one by selecting the ‘Sign up for free’ option.

Once logged in, you will be directed to the dashboard. From here, click on the ‘Create Workflow’ button to initiate the integration process. This will allow you to set up a workflow that connects Google Sheets and Knorish seamlessly.

2. Setting Up the Trigger in Google Sheets

In this step, we will set Google Sheets as the trigger application in Pabbly Connect. Choose Google Sheets and select the trigger event as ‘New or Updated Spreadsheet Row’. This means that the workflow will start whenever a new row is added to your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, go to your Google Sheets. Under the Extensions menu, select Pabbly Connect Webhooks and paste the copied URL into the designated field. Ensure you specify the trigger column, which is the last column where data will be entered.

3. Sending Test Data to Pabbly Connect

To confirm the integration setup, you need to send test data from Google Sheets to Pabbly Connect. After setting up the webhook, click on ‘Send Test’ in the Google Sheets add-on. This will send the data from the newly added row to Pabbly Connect.

Once the test data is sent, return to Pabbly Connect and check if the response has been received successfully. You should see the data matching the entries from Google Sheets, confirming that the integration is working correctly.

4. Configuring the Action to Add Users in Knorish

Now that the trigger is set up, it’s time to configure the action in Pabbly Connect. Choose Knorish as the action application and select the action event as ‘Add User to Course’. This action will automatically add users based on the data received from Google Sheets.

• Select Knorish as the action application.
• Choose ‘Add User to Course’ as the action event.
• Connect your Knorish account by entering the required API key and website URL.

After connecting to Knorish, map the user details from the Google Sheets data to the corresponding fields in Knorish, such as first name, last name, and email. This ensures that each new user is added with the correct information.

5. Finalizing the Integration and Testing

After mapping the necessary fields, save your workflow in Pabbly Connect and send a test request. This will attempt to add a user to your Knorish course using the data from Google Sheets. Check your Knorish account to verify that the user has been added successfully.

If everything is set up correctly, you will see the new user in your Knorish account. This confirms that the integration between Google Sheets and Knorish via Pabbly Connect is functioning as intended. You can now automate the process of adding users to your courses effortlessly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate user addition in Knorish courses from Google Sheets rows. By following these steps, you can streamline your workflow and enhance your course management efficiency.