How to Add 3veta Booking Details to Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate 3veta booking details into Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for effective automation. 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. Accessing Pabbly Connect for Integration

To begin integrating 3veta booking details into Google Sheets, you must access Pabbly Connect. Start by visiting the Pabbly Connect website and either sign in or sign up for a free account if you are a new user. This process is quick and allows you to get free tasks every month.

Once logged in, you will see the Pabbly Connect dashboard. Here, you will create a new workflow. Click on the plus sign to initiate this process. Name your workflow something like ‘3veta Booking Details to Google Sheets’ and click on create. This sets the stage for integrating your applications using Pabbly Connect.

2. Setting Up the Trigger for 3veta

In this step, you will set up the trigger for your integration using Pabbly Connect. Select 3veta as your trigger application and choose the trigger event as ‘New Booking’. This means that every time a new booking is made in 3veta, it will trigger the action you set in Google Sheets.

• Choose the application name as 3veta.
• Select the trigger event as ‘New Booking’.
• Click on connect and add a new connection using your 3veta credentials.

After entering your username and password, click on save to create the connection. Once connected, you will need to send a test request to ensure that the integration is set up correctly. This is done by creating a new booking in your 3veta account to capture the response in Pabbly Connect.

3. Formatting Date and Time for Google Sheets

Once you have set up the trigger, the next step is to format the date and time using Pabbly Connect. This ensures that the booking details are captured in the correct format in Google Sheets. Select the ‘Date and Time Formatter’ application as your action step.

• Choose ‘Format Date with Time Zone’ as the action event.
• Map the date that needs to be formatted from the trigger response.
• Specify the output format as ‘DD/MM/YYYY’ without a time zone.

Make sure to select UTC as the from time zone and Asia/Kolkata as the to time zone. After saving the settings, test the request to ensure that the date is captured correctly in Indian Standard Time (IST). This formatted date will be used in the next step to add the booking details to Google Sheets using Pabbly Connect.

4. Adding Booking Details to Google Sheets

Now, you will integrate Google Sheets with Pabbly Connect to add the booking details. Click on the plus sign to add a new action step and select Google Sheets as your application. Choose ‘Add New Row’ as the action event.

Click on connect and then add a new connection to Google Sheets. You will need to choose your Google account where the Google Sheet is created. After granting access, select the spreadsheet where you want to store the booking details, which should be named ‘Pabbly Connect Demo Session’. The sheet name will be automatically captured as ‘Bookings’.

5. Conclusion: Automating Booking Details with Pabbly Connect

In conclusion, by following these steps, you have successfully integrated 3veta booking details into Google Sheets using Pabbly Connect. This automation allows you to save time and streamline your booking management process. Each time a new booking occurs, the details will automatically populate in your Google Sheets, ensuring that you have accurate records.

With Pabbly Connect, you can automate various applications beyond just this integration. Explore more possibilities and optimize your workflow today!