How to Add Sessions Event Registrants to Google Sheets Using Pabbly Connect

Learn how to automate adding Sessions event registrants to Google Sheets using Pabbly Connect. Follow this detailed 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. Setting Up Pabbly Connect for Sessions Integration

To automate the process of adding Sessions event registrants to Google Sheets, you need to set up Pabbly Connect. Start by logging into your Pabbly Connect account or create a free account in just two minutes.

Once logged in, you will be directed to the dashboard. Click on the blue button labeled ‘Create Workflow’ to start your automation. Give your workflow a name, such as ‘ADD Sessions Event Registrants to Google Sheets,’ and select the folder where this workflow will be stored. After this, click on the ‘Create’ button to proceed.

2. Configuring the Trigger with Sessions

In this step, you will configure the trigger in Pabbly Connect to capture new event registrations from Sessions. Select the Sessions application as your trigger app and choose the event named ‘New Registration’. This will initiate the automation whenever a new registrant is created.

• Choose ‘New Registration’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.
• Go to your Sessions account settings and add the copied webhook URL.

After adding the webhook URL, make sure to select the same trigger event. Confirm the settings to save your webhook. Once done, return to Pabbly Connect, which will now wait for a response from the webhook.

3. Testing the Integration with a Dummy Registration

Now it’s time to test the integration. Open an event registration link in a new tab and fill in the dummy registrant details. This step is crucial as it sends a test registration to the webhook.

For example, you can use the following dummy details:

• First Name: Demo
• Last Name: User
• Email: [email protected]
• Phone: 9666666666

Once you click the ‘Register Now’ button, Pabbly Connect will receive the registration details, confirming that the connection between Sessions and Pabbly Connect is working correctly.

4. Adding Registrant Details to Google Sheets

In this step, you will configure the action in Pabbly Connect to add the registrant details to Google Sheets. Select Google Sheets as your action app and choose the event ‘Add a New Row’. This action will automatically create a new row in your Google Sheets for each new registrant.

To connect Google Sheets, click on ‘Add a New Connection’ and grant access to your Google account. Once connected, select the specific spreadsheet where you want the registrant details to be stored. For example, choose the spreadsheet named ‘Event Registrants’ and select the sheet within it.

5. Mapping Registrant Data to Google Sheets

The final step involves mapping the data captured from the Sessions registration to the corresponding columns in Google Sheets. In Pabbly Connect, you will see fields representing the columns in your Google Sheet.

For each field, you can map the data from the trigger step. For instance, map the first name, last name, email, and phone number from the registration response to the respective columns in your Google Sheets.

After mapping the fields, click on the ‘Save and Send Request’ button. You will receive a positive response confirming that the data has been successfully added to Google Sheets. This means your automation is now fully functional, and every new registration will automatically update your spreadsheet.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of adding Sessions event registrants to Google Sheets. By following these steps, you can streamline your workflow and ensure that all registration details are captured efficiently.