Automate Google Form Responses to Zenler with Pabbly Connect

Learn how to automate Google Form submissions to Zenler using Pabbly Connect. Follow our step-by-step tutorial to streamline your enrollment process. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To automate Google Form submissions to Zenler, we first need to access Pabbly Connect. Start by navigating to the Pabbly website and signing in or signing up for a free account. New users can create an account in just two minutes and receive 100 free tasks for exploring the platform.

Once you’re logged in, go to the ‘All Apps’ section and select Pabbly Connect. This is the integration platform that will help connect Google Forms and Zenler seamlessly. Click on the ‘Access Now’ button to reach the Pabbly Connect dashboard.

2. Creating a New Workflow in Pabbly Connect

In this step, we will create a new workflow in Pabbly Connect. Click on the ‘Create Workflow’ button located at the top right corner. You will be prompted to name your workflow; you can name it something like ‘Create User in Zenler from Google Form Responses’.

• Click on the ‘Create’ button after naming your workflow.
• You will see two windows: one for Trigger and the other for Action.
• Select Google Forms as your Trigger application.

After setting up the trigger, select the event ‘New Response Received’. This will ensure that every time a new response is submitted in Google Forms, it triggers the workflow in Pabbly Connect.

3. Linking Google Forms to Pabbly Connect

Next, we need to link our Google Form to Pabbly Connect. You will be provided with a webhook URL after setting up the trigger. Open your Google Form and navigate to the ‘Responses’ section.

To capture responses, link your Google Form to Google Sheets. Click on ‘Create’ to generate a Google Sheet that will store the responses. Once the sheet is created, go to the ‘Extensions’ menu, select ‘Add-ons’, and then ‘Get Add-ons’ to install the Pabbly Connect Webhooks add-on.

4. Setting Up the Webhook in Google Sheets

After installing the add-on, go back to the ‘Extensions’ menu and select ‘Pabbly Connect Webhooks’ followed by ‘Initial Setup’. Here, paste the webhook URL you copied from Pabbly Connect. Specify the trigger column, which is the last column where data will be entered, typically the email or contact number column.

• Enter the trigger column as the last column (e.g., Column E).
• Click on ‘Send Test’ to verify the connection.
• Submit the form to ensure data flows to Google Sheets and Pabbly Connect.

This setup ensures that every new form submission will trigger data to be sent to Pabbly Connect, which can then be used for further actions.

5. Enrolling Users in Zenler

Now that we have our Google Form responses flowing into Pabbly Connect, the next step is to set up the action to enroll users in Zenler. Choose Zenler as your action application and select the action event ‘Enroll User to a Course’.

In the connection setup, input your API key and school/account name. You can find the API key in your Zenler account under the ‘API Key’ section. After entering these details, specify the course ID and plan ID for the course you want to enroll students in.

Map the email, first name, and last name fields from the Google Form responses to the Zenler enrollment fields. Click on ‘Save and Send Test Request’ to enroll the user. Check Zenler to confirm the user has been successfully enrolled.

By following these steps, you ensure that every new Google Form submission automates the enrollment process in Zenler through Pabbly Connect.

Conclusion

In this tutorial, we successfully integrated Google Forms with Zenler using Pabbly Connect. By automating this process, you can streamline student enrollments effortlessly. This integration showcases the power of Pabbly Connect in automating tasks across different applications.