Integrate Google Sheets and Zenler Using Pabbly Connect

Learn how to automate user enrollment in Zenler courses from Google Sheets using Pabbly Connect in this step-by-step tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Zenler, you first need to access Pabbly Connect. If you are a new user, click on the ‘Sign Up Free’ button to create an account and receive 100 free tasks. Existing users can simply log in to their account.

After signing in, navigate to the Pabbly Connect dashboard. Here, you can view existing workflows or create a new one by clicking on the ‘Create Workflow’ button on the right side. Name your workflow, for example, ‘Enroll User in Zenler Course from Google Sheets,’ and click on ‘Create’ to proceed.

2. Setting Up the Trigger Application in Pabbly Connect

In this step, you will set up Google Sheets as the trigger application in Pabbly Connect. This is essential for automating the enrollment process. In the trigger setup, search for ‘Google Sheets’ and select it. Choose the trigger event as ‘New or Updated Spreadsheet Row,’ which will activate whenever a new row is added or modified.

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

Next, go to your Google Sheet where you have the user enrollment details. Under the ‘Extensions’ menu, ensure you have the Pabbly Connect Webhooks extension installed. If not, you can find it in the ‘Get Add-ons’ section. Once installed, go to the Pabbly Connect Webhooks extension and click on ‘Initial Setup.’ Here, paste the copied webhook URL and specify the trigger column, which should be your final data column.

3. Capturing Data from Google Sheets

Now that you have set up the trigger in Pabbly Connect, it’s time to capture data from Google Sheets. After refreshing the sheet, click on ‘Send on Event’ in the Pabbly Connect Webhooks extension. This action allows Pabbly Connect to listen for new entries in your Google Sheet.

Fill in a new row with dummy data, including the first name, last name, email, phone number, and the course name. Once you add this data, Pabbly Connect will receive the webhook response, confirming that the details have been captured successfully. You will see the data reflected in the Pabbly Connect interface, including the spreadsheet name and ID.

• Add a new row to your Google Sheet with user details.
• Click on ‘Send on Event’ to trigger data capture.
• Verify that the data appears correctly in Pabbly Connect.

This step ensures that every new entry in Google Sheets triggers the automation in Pabbly Connect, allowing for real-time data processing.

4. Filtering Data for Specific Course Enrollment

To ensure that only users who have opted for the specific course enroll in Zenler, you will need to set up a filter in Pabbly Connect. Add an action step and select the filter option. Here, define the condition that the course name must equal ‘Core PHP Programming’ for the automation to continue.

In the filter setup, select the course name from the captured data and set the filter type to ‘Equal To.’ If the condition is met, the workflow will proceed to the next step; otherwise, it will stop. Click on ‘Save and Send Test Request’ to verify the filter’s functionality, ensuring that it only allows the specified course to proceed.

5. Enrolling Users in Zenler Using Pabbly Connect

Now that you have filtered the data, it’s time to enroll users in Zenler through Pabbly Connect. Search for Zenler in the action application section and select the action event as ‘Enroll User to a Course.’ You will need to connect your Zenler account with Pabbly Connect by providing your API key and school name.

After successfully connecting, select the course ID and course plan ID for the enrollment. Map the user’s email, first name, and last name from the captured data to ensure that the correct details are sent to Zenler. Finally, click on ‘Save and Send Test Request’ to complete the enrollment process. You will receive a success message confirming that the user has been enrolled in the specified course.

Conclusion

This tutorial demonstrated how to automate user enrollment in Zenler courses directly from Google Sheets using Pabbly Connect. By following these steps, you can streamline your workflow and ensure that user data is processed efficiently and accurately.