How to Unenroll a Teachable Student from Google Sheets Using Pabbly Connect

Learn how to integrate Google Sheets with Teachable using Pabbly Connect to automate unenrollment of students based on course status. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Teachable, you need to access Pabbly Connect. First, navigate to the Pabbly Connect dashboard by signing in or creating a new account. New users receive 100 free tasks upon registration, making it easy to begin.

Once logged in, locate the ‘Create Workflow’ button on the right side of the dashboard. Click it, and a dialog box will prompt you to name your workflow. Name it according to your objective, such as ‘Unenroll Teachable Student from Google Sheets.’ Then, click on ‘Create’ to proceed.

2. Setting Up the Google Sheets Trigger in Pabbly Connect

In this step, we will set Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets as your trigger application and choose the trigger event as ‘New or Updated Spreadsheet Row.’ This event will initiate the workflow whenever a new entry is added or an existing entry is updated in your Google Sheet.

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

Next, go to your Google Sheet, navigate to ‘Extensions,’ and select ‘Add-ons’ to install the Pabbly Connect Webhook add-on. After installation, refresh your Google Sheet to ensure the add-on appears. Go back to ‘Extensions,’ select Pabbly Connect Webhooks, and proceed to the ‘Initial Setup.’ Paste the webhook URL and set the trigger column to the final data column, which is usually column C. Click ‘Submit’ to finalize the setup.

3. Filtering Course Status for Unenrollment

Once the trigger is set, the next step in Pabbly Connect is to filter the course status. This is crucial as we only want to continue the workflow if the course status indicates ‘completed’ or ‘unenrolled.’ To do this, add a filter action after the trigger.

• Select ‘Filter’ as the action application.
• Set the condition to check if the course status equals ‘completed.’
• Save and send a test request to verify the condition.

If the condition is true, the workflow will proceed to the next action step, which is to search for the user in Teachable. This ensures that we only unenroll students who are currently enrolled in the course.

4. Searching for the User in Teachable

Now that we have filtered the course status, the next step in Pabbly Connect is to search for the user in Teachable. Select Teachable as your action application and choose ‘Search User’ as the action event. This step is essential to verify whether the user exists in Teachable before proceeding to unenroll them.

Connect your Teachable account by entering the required credentials, including your subdomain. Once connected, map the user’s email address from the previous steps to search for the user in Teachable. After mapping, click on ‘Save and Send Test Request’ to confirm that the user exists in the system.

If the user is found, you will receive a confirmation response containing the user’s details. This information is vital for the final step where we will unenroll the user from the course.

5. Unenrolling the User from the Course

The final step in this workflow using Pabbly Connect is to unenroll the user from the course in Teachable. After confirming the user exists, select Teachable again as your action application and choose ‘Unenroll Student from Course’ as the action event.

Map the student ID and course ID from the previous steps to ensure that the correct user is unenrolled from the correct course. Click on ‘Save and Send Test Request’ to execute the unenrollment process. If successful, you will receive a confirmation response indicating that the user has been successfully unenrolled.

To verify, you can check the user’s enrollment status in Teachable. If the unenrollment was successful, the user will no longer appear as enrolled in the course.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the unenrollment of students from Teachable based on their course status in Google Sheets. This integration streamlines the process, ensuring efficiency and accuracy in managing student enrollments.