How to Integrate Published Sessions Events in Google Sheets with Pabbly Connect

Learn how to automate the process of adding published sessions events to Google Sheets using Pabbly Connect with this detailed step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To integrate published sessions events into Google Sheets, you will first need to access Pabbly Connect. This platform is essential for automating the process of adding event details directly into Google Sheets.

Start by opening a new tab and searching for Pabbly Connect. You can sign in if you already have an account or sign up for free if you are new. Signing up takes just a couple of minutes and offers you hundreds of tasks free every month.

2. Creating a New Workflow in Pabbly Connect

Once you are logged into Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button, and a dialog box will appear. Here, you will name your workflow, for instance, ‘Sessions Google Sheets Integration’.

• Name your workflow appropriately.
• Select a folder to save your workflow.
• Click on ‘Create’ to proceed.

This will take you to the workflow setup page where you can define the trigger and action applications.

3. Setting Up the Trigger in Pabbly Connect

The next step in using Pabbly Connect is to set up the trigger application. In this case, you will search for the application ‘Sessions’ and select it. The trigger event will be set to ‘Event Published’.

After selecting the trigger event, you will see a webhook URL provided by Pabbly Connect. Copy this URL as you will need to configure it in your Sessions account.

• Go to your Sessions account and open account settings.
• Add the copied webhook URL in the webhook section.
• Set the trigger to ‘Event Published’ and confirm the settings.

This will link your Sessions account to Pabbly Connect, allowing it to receive event data.

4. Formatting Date and Time for Google Sheets

After setting up the trigger, the next action in Pabbly Connect involves formatting the date and time. This is crucial as you want the event details to reflect the correct time zone in Google Sheets.

To do this, you will use the ‘Date and Time Formatter’ tool within Pabbly Connect. Select the action event as ‘Format Time Zone’ and connect it to the workflow. You will need to select the date and time from the webhook response and change it to the Asia Kolkata time zone.

Choose the date and time from the webhook response. Change the time zone to Asia Kolkata. Save and send the test request to confirm.

This ensures that the event date and time are correctly formatted before they are sent to Google Sheets.

5. Adding a New Row in Google Sheets

The final step in this integration using Pabbly Connect is to add a new row in Google Sheets. Search for ‘Google Sheets’ in the action application section and select it. The action event will be set to ‘Add New Row’.

Connect your Google Sheets account and select the spreadsheet where you want to add the event details. Map the event name, event description, and the formatted date and time to the respective columns in your Google Sheets.

After mapping the details, click on ‘Save and Send Test Request’ to ensure everything is working correctly. You should then see the new event details appear in your Google Sheets.

Conclusion

In this tutorial, we explored how to integrate published sessions events into Google Sheets using Pabbly Connect. By following these steps, you can automate the process of adding event details, ensuring your Google Sheets are always up to date with the latest information.