How to Add Registration Details of WebinarKit to MS Excel Using Pabbly Connect

Learn how to integrate WebinarKit with MS Excel using Pabbly Connect for seamless registration details management. Follow our step-by-step tutorial to automate your workflow. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WebinarKit and MS Excel Integration

To add registration details from WebinarKit to Microsoft Excel, you will first need to access Pabbly Connect. Start by going to the Pabbly Connect website at Pabbly.com/connect.

Once there, you can either sign in if you are an existing user or sign up for free if you are new. Signing up will give you access to 100 free tasks, which is a great way to start automating your workflows.

2. Creating a Workflow in Pabbly Connect

After signing in, you will be taken to the Pabbly Connect dashboard. Here, click on the ‘Create Workflow’ button to start a new integration. Name your workflow something like ‘WebinarKit to MS Excel’ to easily identify it later.

• Click on the ‘Create’ button to proceed.
• Select ‘WebinarKit’ as your trigger application.
• Choose ‘New Registration’ as the trigger event.

Once you have set up the trigger, you will receive a webhook URL. This URL is crucial as it will connect Pabbly Connect with WebinarKit, allowing for data transfer between the two applications.

3. Setting Up WebinarKit to Use Webhooks

Next, navigate to your WebinarKit account. Here, you will need to edit the webinar for which you want to capture registration details. Scroll down to the ‘Other’ section and find the webhooks option.

Paste the webhook URL you copied from Pabbly Connect into the designated field. After pasting, make sure to save your changes. This step is essential to ensure that every new registration in WebinarKit sends data to Pabbly Connect.

4. Testing the Integration with a Mock Registration

After successfully setting up the webhook in WebinarKit, return to Pabbly Connect. Here, you will be prompted to perform a test submission to confirm that the data is being received correctly. To do this, fill out the registration form on your WebinarKit account.

• Enter a first name, last name, email address, phone number, and webinar topic.
• Click on ‘Register Now’ to submit the registration.

Once you have registered, Pabbly Connect should receive the registration data, allowing you to proceed to the next step of adding this information to MS Excel.

5. Adding Registration Details to Microsoft Excel

Now that you have confirmed that Pabbly Connect is receiving data from WebinarKit, it’s time to connect to Microsoft Excel. In the Pabbly Connect dashboard, select ‘Microsoft Excel’ as your action application and choose ‘Add Row to Worksheet’ as the action event.

Connect your Microsoft Excel account by authorizing access. You will then need to select the appropriate workbook and worksheet where the registration data will be stored. Map the fields from the WebinarKit registration to the corresponding columns in your Excel sheet, such as first name, last name, email address, and more.

Conclusion

This tutorial has guided you through integrating WebinarKit with Microsoft Excel using Pabbly Connect. By following these steps, you can automate the process of adding registration details to your Excel spreadsheet effortlessly. This integration not only saves time but also ensures that your data is organized and easily accessible.