How to Add New Sessions in Google Sheets Using Pabbly Connect

Learn how to integrate Sessions with Google Sheets using Pabbly Connect to automatically add new session details. Follow our step-by-step tutorial now! Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Sessions Integration

To add new sessions in Google Sheets, the first step is to set up Pabbly Connect. This integration allows you to automate the process of adding session details whenever a new session is created in Sessions. Start by signing into your Pabbly Connect account. If you’re new, you can sign up for free and get 100 tasks each month.

After signing in, navigate to the dashboard. Click on the ‘Create Workflow’ button located at the top right corner. Name your workflow, for example, ‘Add New Sessions in Google Sheets’ and save it in the folder named ‘Sessions’. This organization helps in managing your workflows efficiently.

2. Configuring the Trigger Application in Pabbly Connect

In this step, you will configure the trigger application in Pabbly Connect. The trigger application is Sessions, and the trigger event is ‘Session Created’. This means that every time a new session is created, it will trigger the automation.

• Select ‘Sessions’ as your trigger application.
• Choose ‘Session Created’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

Next, go to your Sessions account, navigate to account settings, and then to webhooks. Create a new webhook by pasting the copied URL. Set the trigger to ‘Session Created’ and confirm the settings. This setup ensures that any new session created in Sessions will automatically send data to Pabbly Connect.

3. Scheduling a New Session in Sessions

Now that you’ve set up the webhook, it’s time to schedule a new session in Sessions. For this example, name your session ‘Digital Marketing Workshop’ and provide a detailed description. This is crucial as it will be sent to Google Sheets.

• Set the date for the session to 27th, and time from 11:45 AM to 12:45 PM.
• Confirm the session to be scheduled.

Once the session is scheduled, you will see a confirmation message indicating that the session has been created successfully. This action will trigger the webhook you set up in Pabbly Connect and send the session details to the platform.

4. Formatting Date and Time for Google Sheets

After scheduling your session, the next step involves formatting the date and time received in UTC to match Indian time. In Pabbly Connect, add a new action step and select the ‘Date Time Formatter’ as your action application.

Choose ‘Format Date with Time Zone’ as the action event. Map the date and time fields from the trigger response. Set the ‘From Time Zone’ to UTC and the ‘To Time Zone’ to Asia/Kolkata.

This step ensures that the date and time are correctly formatted before being sent to Google Sheets. Click on ‘Save and Send Test Request’ to verify that the date and time are formatted correctly.

5. Adding New Sessions to Google Sheets Using Pabbly Connect

The final step is to add the formatted session details to Google Sheets. In Pabbly Connect, select Google Sheets as your action application and choose ‘Add New Row’ as the action event. This will allow you to insert the session details into your Google Sheets document.

Connect your Google Sheets account to Pabbly Connect. Select the spreadsheet named ‘Session Spreadsheet’. Map the date, session name, and description fields accordingly.

After mapping the fields, click on ‘Save and Send Test Request’ to add the new session details to your Google Sheets. Once confirmed, check your Google Sheets to see that the session details have been added successfully. This integration ensures that every new session created in Sessions is automatically logged in your Google Sheets.

Conclusion

In this tutorial, we explored how to seamlessly integrate Sessions with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of adding new session details effortlessly. This integration not only saves time but also ensures accurate record-keeping for your sessions.