How to Revoke Heights Platform Course from a Student via Google Sheets Using Pabbly Connect

Learn how to revoke a Heights Platform course from a student using Google Sheets and Pabbly Connect in this step-by-step tutorial. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Course Revocation

To start revoking a Heights Platform course from a student using Google Sheets, the first step is to access Pabbly Connect. Navigate to the Pabbly website and sign in or create a new account if you are a first-time user. This platform provides the necessary automation tools to connect Google Sheets with Heights Platform seamlessly.

Once signed in, locate the ‘Access Now’ option for Pabbly Connect. Click on this to enter the dashboard where you can manage your workflows. To create a new workflow, click on the ‘Create Workflow’ button, and name it appropriately, such as ‘Revoke a Course from Student in Heights Platform via Google Sheets’.

2. Setting Up Google Sheets as the Trigger Application

In this step, you will configure Google Sheets as the trigger application using Pabbly Connect. Select Google Sheets from the trigger options and choose the event as ‘New or Updated Spreadsheet Row’. This means that whenever a new row is added to your Google Sheets, it will trigger the workflow.

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

After copying the webhook URL, navigate to your Google Sheets document. Go to the ‘Extensions’ menu, select ‘Add-ons’, and then click on ‘Get Add-ons’. Search for the Pabbly Connect Webhooks add-on and install it. This will allow your Google Sheets to communicate with Pabbly Connect.

3. Initializing Google Sheets for Data Entry

After installing the Pabbly Connect Webhooks add-on, you need to set it up. Open the add-on from the Extensions menu and select ‘Initial Setup’. Here, you will paste the copied webhook URL and specify the trigger column where data will be entered.

• Paste the webhook URL in the designated field.
• Specify the trigger column (e.g., column D).
• Click on ‘Send Test’ to ensure data is sent successfully.

Once you have completed these steps, click on ‘Submit’. This will confirm the setup, allowing Pabbly Connect to receive data from your Google Sheets whenever a new student entry is made.

4. Connecting Heights Platform for Course Revocation

Next, you will configure Heights Platform as the action application in Pabbly Connect. Select Heights Platform from the action options and choose the action event ‘Revoke a Course from a Student’. This setup allows the workflow to take action based on the data received from Google Sheets.

To establish the connection, click on ‘Connect’ and then select ‘Add New Connection’. You will need to provide the subdomain and API key from your Heights Platform account. The subdomain is the part of the URL before ‘heightsplatform.com’.

5. Finalizing the Workflow and Testing

After entering the required details, map the email field from the previous response received from Google Sheets. This mapping ensures that the email of the student is dynamically updated with each new entry. Once everything is set, click on ‘Save and Send Test Request’ to test the workflow. using Pabbly Connect

To confirm the course revocation, check the Heights Platform admin student list for the student you just updated. You should see that the course access has been successfully revoked. Finally, return to your Google Sheets and set the Pabbly Connect Webhooks add-on to send on events, ensuring that any future entries automatically trigger the workflow.

Conclusion

In this tutorial, we demonstrated how to revoke a Heights Platform course from a student using Google Sheets and Pabbly Connect. By following these steps, you can automate the process efficiently, ensuring that course access is revoked seamlessly whenever a new entry is made in your Google Sheets.