Integrate Google Sheets with Pabbly Connect for Automated User Enrollment

Learn how to automate user enrollment from Google Sheets to Riggy using Pabbly Connect with this step-by-step tutorial. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, open your web browser and navigate to the Pabbly Connect website. If you don’t have an account, click on the ‘Sign up for free’ button, which only takes a couple of minutes to set up. By signing up, you will get 100 free tasks every month.

After signing up, log in to your account and head to the dashboard. Here, you will see various applications that Pabbly offers. Click on the ‘Access Now’ button under Pabbly Connect to begin creating your workflow.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, your first step is to create a new workflow. Click on the ‘Create Workflow’ button, which opens a dialog box for naming your workflow. Name it something descriptive, like ‘Enroll Riggy User from New Google Sheets Row’ and select the folder where you want to save it.

• Click ‘Create’ to proceed to the workflow setup.
• You will see two boxes: Trigger and Action.
• Set up your trigger first, which will initiate the workflow.

In the trigger box, search for Google Sheets and select it. For the trigger event, choose ‘New or Updated Spreadsheet Row’. This setup ensures that every time a new user detail is added to your Google Sheets, it will trigger the workflow to enroll that user automatically.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets with Pabbly Connect, you will need to use the VAB URL provided by Pabbly. Copy this URL as it acts as a bridge between Google Sheets and Pabbly Connect. Now, open your Google Sheets and navigate to the specific spreadsheet you are using for user enrollment.

Go to the ‘Extensions’ menu, look for the Pabbly Connect VAB Books extension, and select ‘Initial Setup’. Paste the VAB URL you copied earlier into the designated field. Next, specify the trigger column, which is the last data entry column in your sheet, usually Column C. This column will trigger the workflow whenever data is added.

• Click ‘Send Test’ to ensure the setup works correctly.
• After successful testing, click ‘Submit’ to finalize the setup.

After submitting, enable the ‘Send on Event’ option in the Pabbly Connect VAB Books extension to ensure that every new row added will automatically send data to Pabbly Connect.

4. Setting Up the Action in Pabbly Connect

Now that Google Sheets is connected to Pabbly Connect, it’s time to set up the action. In the action box, search for Riggy and select it. For the action event, choose ‘Import User’. This action will enroll the user in your course using the data received from Google Sheets.

Connect Riggy with Pabbly Connect by clicking on ‘Add New Connection’. You will need a token from your Riggy account to establish this connection. Log into Riggy, go to the Integrations section, and enable the Pabbly Connect option to retrieve your token.

Copy the token and return to Pabbly Connect. Paste the token into the connection setup and click ‘Save’.

With the connection established, map the user details from Google Sheets to the corresponding fields in Riggy, ensuring that each new user is enrolled automatically when added to the Google Sheet.

5. Testing Your Integration with Pabbly Connect

To test your integration, add a new row in your Google Sheets with user details, such as name, email, and phone number. Once you add this information, Pabbly Connect will automatically trigger the workflow and enroll the user in Riggy.

Check your Riggy account under User Management to verify that the new user has been successfully added. By using Pabbly Connect, you can streamline the enrollment process, ensuring no new signups are missed.

Whenever you add a new user to Google Sheets, the automation will work seamlessly, enrolling them into your course without manual intervention. This approach not only saves time but also enhances efficiency in managing user registrations.

Conclusion

This tutorial demonstrated how to integrate Google Sheets with Riggy using Pabbly Connect for automated user enrollment. By following these steps, you can efficiently manage user registrations and streamline your online training platform.