Author: Nitin Maheshwari

Learn how to accurately retrieve payment amounts from Stripe using Pabbly Connect with 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 Stripe Integration

To get an accurate payment amount from Stripe, first, access Pabbly Connect. This platform allows you to set up automated workflows between Stripe and other applications seamlessly. Start by logging into your Pabbly Connect account and create a new workflow.

Within the workflow, select Stripe as your trigger application. Choose the event ‘Checkout Complete’ to initiate the process. After this, you will be provided with a webhook URL. This URL is crucial for connecting your Stripe account to Pabbly Connect.

---

2. Connecting Stripe to Pabbly Connect

Next, you will need to connect your Stripe account to Pabbly Connect. Use the webhook URL generated in the previous step to set up the connection. This integration allows Pabbly Connect to receive payment notifications directly from Stripe.

• Log into your Stripe account.
• Navigate to the Webhooks section.
• Add a new webhook and paste the URL from Pabbly Connect.
• Select the events you want to trigger, specifically ‘Checkout Session Completed’.

By following these steps, you ensure that Stripe sends payment data to Pabbly Connect whenever a checkout is completed. This connection is vital for receiving accurate payment amounts.

---

3. Testing Payment Amount Retrieval from Stripe

After setting up the connection, it’s time to test the payment retrieval process. Make a test payment of 500 rupees through your Stripe account. Once the payment is processed, Pabbly Connect will receive a webhook response containing the payment details.

Upon checking the response, you may notice that the amount appears as 50,000 instead of 500. This discrepancy occurs because Stripe sends the amount in a format that does not support decimal values, hence adding extra zeros. Understanding this will help you correct the amount in the next step.

---

4. Correcting the Payment Amount Using Pabbly Connect

To correct the payment amount received from Stripe, utilize the Number Formatter feature within Pabbly Connect. This module allows you to perform mathematical operations on the data received. To do this, add an action step in your workflow and select the Number Formatter app.

In the Number Formatter settings, choose the action event as ‘Perform Math Operation’. Map the amount received from Stripe in the Numbers field. To convert the amount to the correct value, add a comma and then write 100, selecting ‘Divide’ as the operation. This effectively converts 50,000 to 500, the accurate payment amount.

---

5. Finalizing the Workflow in Pabbly Connect

Once you have corrected the payment amount using the Number Formatter, it’s essential to finalize your workflow in Pabbly Connect. After performing the math operation, click on ‘Save and Send Test Request’ to ensure the changes are applied correctly.

Upon successful execution, Pabbly Connect will return the accurate payment amount. You can then use this corrected amount in subsequent actions, such as sending it to other applications or storing it in a database. This flexibility allows you to automate your workflow effectively.

---

Conclusion

In this tutorial, we explored how to accurately retrieve payment amounts from Stripe using Pabbly Connect. By connecting Stripe, setting up the Number Formatter, and performing the necessary calculations, you can ensure that your payment data is precise and ready for further processing. This integration streamlines your workflow and enhances the accuracy of your payment processing.

Learn how to automate WhatsApp messages based on Google Forms submissions using Pabbly Connect. Step-by-step tutorial for seamless integration. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To start sending WhatsApp messages upon customer feedback submission, you’ll first need to access Pabbly Connect. This platform allows seamless integration between Google Forms and WhatsApp, automating your communication process.

Begin by creating your free account on Pabbly Connect. Once logged in, navigate to your dashboard and click on the blue button labeled ‘Create Workflow’. Here, you can name your workflow, for example, ‘Auto Reply on WhatsApp for Feedback’.

---

2. Setting Up Google Forms Trigger Using Pabbly Connect

In this step, you will set up Google Forms as your trigger application in Pabbly Connect. This means that whenever a customer submits feedback via your form, it will trigger an action in WhatsApp.

To do this, select Google Forms as your trigger application and choose the event ‘New Response in Spreadsheet’. This will allow you to capture the responses from your Google Form submissions. You will then need to connect Google Forms with Pabbly Connect using a webhook URL.

• Copy the webhook URL provided by Pabbly Connect.
• Go to your Google Sheets linked with the form and install the Pabbly Connect Webhooks add-on.
• Set up the webhook by pasting the copied URL into the add-on.

After completing these steps, your Google Forms will send submission data directly to Pabbly Connect, allowing you to automate WhatsApp messages based on customer feedback.

---

3. Configuring WhatsApp Messages with Pabbly Connect

Now that you have set up the trigger, it’s time to configure WhatsApp messages. This is where Pabbly Connect shines by allowing you to send personalized messages based on the feedback rating.

Using the router feature in Pabbly Connect, you can set conditions based on the ratings received. For instance, if the rating is less than 3, you can send a different message than for ratings of 3 or higher. Here’s how to set it up:

• Add a router step in your workflow.
• Set conditions for ratings less than 3 and greater than or equal to 3.
• For each condition, connect to the WhatsApp application to send messages.

This setup ensures that customers receive appropriate responses based on their feedback ratings, enhancing customer engagement through Pabbly Connect.

---

4. Testing the Integration of Google Forms and WhatsApp via Pabbly Connect

Once you have configured your workflow, it’s crucial to test the integration. This step ensures that everything is functioning correctly before going live. In Pabbly Connect, you can easily test the connection.

Submit a test response through your Google Form and check if the data appears in Pabbly Connect. If everything is set up correctly, you should see the WhatsApp message sent to the specified number. Make sure to check the response in your WhatsApp application as well.

To effectively test the integration, follow these steps:

Submit a dummy feedback form with various ratings. Monitor the Pabbly Connect dashboard for incoming data. Check your WhatsApp for the corresponding messages.

By testing the integration, you can ensure that your automated system is ready to handle real customer feedback seamlessly with the help of Pabbly Connect.

---

5. Conclusion: Automate Your Customer Feedback Process with Pabbly Connect

In conclusion, using Pabbly Connect to send WhatsApp messages based on Google Forms submissions is an effective way to enhance customer communication. By following the outlined steps, you can automate responses based on customer feedback ratings.

This automation not only saves time but also improves customer satisfaction by providing timely responses. With Pabbly Connect, you can easily manage your workflows and ensure your customers feel valued after providing feedback.

---

Learn how to automate Google Sheets updates using Pabbly Connect. This tutorial covers integrating Google Sheets to insert data for days with no entries. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Automation

To start automating Google Sheets updates, you need to access Pabbly Connect. Visit the Pabbly Connect website and sign in to your account. If you’re a new user, the sign-up process is quick and easy, taking less than two minutes.

Once signed in, navigate to the dashboard and click on the ‘Create Workflow’ button. This action sets the stage for your automation process. You will name your workflow, for instance, ‘Insert Data When There is No Entry for a Day’, which clarifies your objective.

---

2. Setting Up a Scheduled Trigger with Pabbly Connect

Using Pabbly Connect, the first step is to set a trigger for your workflow. Select the ‘Schedule’ feature to run your automation daily. Specify the time for the workflow to execute, like 12:45 PM.

• Choose ‘Schedule’ as your trigger application.
• Set the frequency to ‘Every Day’.
• Select the desired time for execution.

Once saved, your workflow will run automatically at the specified time. This initial setup is crucial for ensuring that your Google Sheets are updated daily without manual intervention.

---

3. Fetching the Current Date Using Pabbly Connect

Next, you will use Pabbly Connect to fetch the current date. This step is essential to determine if there are any entries for the day in your Google Sheets. Select the ‘DateTime Formatter’ feature and configure it to return the current date in the format of month, date, and year.

Make sure to set the option for including time as ‘False’. After saving this step, you will receive the current date, which will be used to check against your Google Sheets entries.

---

4. Checking Google Sheets for Existing Data

Now, the next action in your Pabbly Connect workflow involves checking your Google Sheets for existing data. Select ‘Google Sheets’ as the action application and choose the ‘Lookup Spreadsheet Rows’ option. Connect your Google Sheets account to allow Pabbly Connect to access your data.

• Select your spreadsheet and the relevant sheet.
• Set the lookup column to the date column (Column A).
• Map the current date as the lookup value.

Once you run this step, if no data is found for that date, it indicates that no sales were recorded, and you can proceed to the next step to insert data.

---

5. Inserting Data into Google Sheets for Missing Entries

Finally, if the previous step confirms that there are no entries for the current date, you will use Pabbly Connect to insert data into Google Sheets. Again, select ‘Google Sheets’ as the action application, this time choosing ‘Add New Row’ as the action event.

Configure the fields to insert the current date, set the sales value to 0, and the order quantity to either 0 or a simple hashtag. This ensures that your Google Sheets accurately reflects that no sales occurred on that date.

---

Conclusion

By following this tutorial, you can effectively automate Google Sheets updates using Pabbly Connect. This integration ensures that your sales records are complete, even on days when no sales occur, providing a clear overview of your business performance.

Learn how to integrate HubSpot with ConvertKit using Pabbly Connect. This step-by-step tutorial guides you through adding HubSpot contacts as subscribers in ConvertKit. 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. Access Pabbly Connect for HubSpot and ConvertKit Integration

To start integrating HubSpot with ConvertKit, you will need to access Pabbly Connect. Begin by navigating to the URL Pabbly.com/connect. Here, you can either sign in if you are an existing user or sign up if you are new. Signing up is quick and takes less than two minutes.

Once signed in, you will reach the applications page. Click on Pabbly Connect to access the dashboard. On the right side, you will find the Create Workflow button. Click on it to initiate the integration process. A dialog box will appear asking you to name your workflow. For this integration, name it something like ‘Add HubSpot Contact to ConvertKit’.

---

2. Setting Up the Trigger in Pabbly Connect

The next step involves setting up the trigger application. For this integration, your trigger application will be HubSpot CRM. Click on it and select the trigger event as New Contact Added. This event will activate the workflow every time a new contact is created in HubSpot CRM.

• Select the trigger event as New Contact Added.
• Connect Pabbly Connect to your HubSpot account.
• Authorize the connection to allow data access.

After connecting, you will need to specify the output properties needed to create a contact. Essential fields include first name, last name, email address, and phone number. Once you have selected these properties, click on Save and Send Test Request to ensure everything is set up correctly.

---

3. Adding the Subscriber to ConvertKit

Now that you have set up the trigger, the next step is to set the action application, which will be ConvertKit. Click on ConvertKit and select the action event as Add Subscriber to a Form. This action will add the new HubSpot contact as a subscriber in ConvertKit.

To connect Pabbly Connect to ConvertKit, you will need to provide your API key and API secret. Log in to your ConvertKit account, go to Account Settings, and find your API key and secret under the Advanced section. Copy these credentials back to Pabbly Connect and click Save to establish the connection.

• Select the form where subscribers will be added.
• Map the output fields from HubSpot to ConvertKit.
• Click on Save and Send Test Request to verify the integration.

Upon successful mapping and testing, the new subscriber should appear in your ConvertKit account as an unconfirmed subscriber.

---

4. Confirming Subscriber Status in ConvertKit

Once the subscriber has been added to ConvertKit, they will receive an email asking them to confirm their subscription. This is an essential step to ensure that the subscriber is aware and consents to receiving communications. Check your ConvertKit account under the Subscribers section to see the new entry.

After the subscriber confirms their email, they will be moved to the confirmed subscribers list. This process not only automates the addition of HubSpot contacts but also ensures compliance with email marketing best practices.

To verify, you can create a new contact in HubSpot and check if the same appears in ConvertKit after the polling time of 10 minutes. This confirms that Pabbly Connect is working correctly to automate the entire process.

---

5. Real-Time Testing of the Integration

To ensure everything is functioning correctly, conduct a real-time test by creating a new contact in HubSpot. Enter the details such as email address, first name, and last name, and then click Create. Afterward, wait for the polling interval of 10 minutes.

Once the time has elapsed, refresh your ConvertKit subscribers list. You should see the new contact listed as an unconfirmed subscriber. This step verifies that Pabbly Connect is effectively linking HubSpot with ConvertKit.

After confirming the subscription via the email link, you can check again in ConvertKit to see the subscriber’s status change to confirmed. This successful integration demonstrates the power of Pabbly Connect in streamlining your marketing efforts.

---

Conclusion

Integrating HubSpot with ConvertKit using Pabbly Connect is a straightforward process that enhances your marketing automation. By following the steps outlined in this tutorial, you can efficiently add HubSpot contacts as subscribers in ConvertKit, ensuring seamless communication and engagement.

Learn how to integrate ThriveCart and MailerLite using Pabbly Connect to automate subscriber updates after a sale. Follow our detailed tutorial for step-by-step instructions. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To integrate ThriveCart and MailerLite, we will use Pabbly Connect. Begin by visiting the Pabbly Connect website. If you are a new user, you can sign up for free; existing users can simply sign in.

Once logged in, you will be directed to the dashboard. From here, locate the big blue button labeled ‘Create Workflow’. Click on it to start setting up your integration workflow.

---

2. Setting Up ThriveCart as the Trigger Application

In this step, we will configure ThriveCart as the trigger application in Pabbly Connect. Select ThriveCart from the list of applications and choose the trigger event as ‘Product Purchase’. This event will initiate the workflow whenever a product is purchased.

• Select ‘Connect’ to link your ThriveCart account.
• Create a new connection by generating an API key in your ThriveCart account.
• Paste the API key into Pabbly Connect and click ‘Save’.

After saving, you will need to select the specific product for which you want to track purchases. This ensures that the workflow is triggered correctly for the intended product.

---

3. Testing the ThriveCart Connection

Now that ThriveCart is set up, it’s time to test the connection through Pabbly Connect. You will need to make a test purchase to capture the data. Go to the ThriveCart dashboard, find your product, and proceed to checkout.

Fill in the required details such as first name, last name, and email address. Complete the order to simulate a purchase. Once the purchase is successful, return to Pabbly Connect to verify that the data has been captured correctly.

---

4. Configuring MailerLite as the Action Application

With the ThriveCart trigger tested, we can now configure MailerLite as the action application in Pabbly Connect. Select MailerLite and choose the action event ‘Create or Update Subscriber’. This action will ensure that the subscriber’s details are added or updated based on the purchase.

• Connect your MailerLite account by generating a new API token.
• Map the subscriber’s email and other details from the previous step.
• Select the appropriate group for the subscriber in MailerLite.

After mapping all the necessary fields, click on ‘Save and Send Test Request’ to ensure that the integration works as expected. You should see a confirmation that the subscriber has been added or updated successfully.

---

5. Final Verification of Integration Success

To confirm that the integration is functioning correctly, return to your MailerLite account and check the subscribers list. You should see the new subscriber added based on the test purchase made in ThriveCart.

Repeat the purchase process with different subscriber details to ensure that updates are reflected accurately in MailerLite. This demonstrates the seamless integration capabilities of Pabbly Connect in automating subscriber management.

In conclusion, using Pabbly Connect to integrate ThriveCart and MailerLite streamlines the process of managing subscribers effectively. This automation saves time and enhances productivity by ensuring that subscriber information is always up-to-date.

Conclusion

This guide summarizes the key points and helps you understand the essential features and benefits of using this tool.

---

Learn how to create Sendpulse subscribers from emails using Pabbly Connect in this step-by-step tutorial. Integrate Gmail and Sendpulse seamlessly! 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 Email Integration

To create Sendpulse subscribers from emails, start by accessing Pabbly Connect. This powerful integration platform allows you to automate workflows between various applications. Begin by signing into your Pabbly Connect account to reach the dashboard.

Once logged in, locate the blue ‘Create Workflow’ button on the right side of the dashboard. Click this button to initiate the process. You will then be prompted to name your workflow; for this tutorial, name it ‘Create Sendpulse Subscribers from Emails’ and click on ‘Create’ to proceed.

---

2. Setting Up the Trigger in Pabbly Connect

In this step, you’ll set up the trigger using Pabbly Connect. The trigger for this workflow will be the Email Parser feature. This feature allows Pabbly Connect to capture incoming emails that will trigger the creation of a new subscriber in Sendpulse.

• Copy the webhook URL provided by Pabbly Connect.
• Set up your Gmail account to forward emails to this webhook URL.
• Ensure that the Email Parser is waiting for a response.

After copying the webhook, go to your Gmail settings, navigate to the ‘Forwarding and POP/IMAP’ tab, and add the webhook URL as a forwarding address. Confirm the forwarding by entering the verification code sent to your Gmail. Once set up, any email sent to this address will be captured by Pabbly Connect.

---

3. Filtering Emails for Subscribers

Once your trigger is set up, the next step in Pabbly Connect is to filter the incoming emails. This ensures that only emails with specific criteria are processed. In this case, you want to filter emails based on their subject line.

• Set the filter to check if the subject equals ‘New Subscriber’.
• Only emails with this subject will trigger the next action in the workflow.

To set this up, select the filter option in Pabbly Connect and configure it to continue only if the subject matches ‘New Subscriber’. This step is crucial to ensure that irrelevant emails do not create unnecessary subscribers in Sendpulse.

---

4. Adding Subscribers to Sendpulse

Now that your emails are filtered, it’s time to add subscribers to Sendpulse using Pabbly Connect. In this step, you will map the extracted data from the email into the fields required by Sendpulse.

Choose the Sendpulse application as your action step and select the ‘Add Subscriber’ event. Connect your Sendpulse account by entering the API ID and secret from your Sendpulse account settings. Once connected, you can proceed to map the subscriber details such as name, email, and phone number from the filtered email data.

After mapping the required fields, click on ‘Save and Send Test Request’. If everything is set up correctly, you will receive a confirmation that a new subscriber has been added to your Sendpulse list. This confirms that your workflow is functioning as intended, allowing seamless integration between Gmail and Sendpulse through Pabbly Connect.

---

Conclusion

Using Pabbly Connect, you can easily automate the process of creating new Sendpulse subscribers from incoming emails. This integration not only saves time but also ensures that your subscriber list is always up to date. By following the steps outlined in this tutorial, you can effectively manage your email subscriptions with minimal manual effort.

Learn how to automate Salesforce contact creation from MySQL using Pabbly Connect. Follow this detailed step-by-step guide for seamless integration. 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. Setting Up Pabbly Connect for MySQL to Salesforce Integration

To create Salesforce contacts from MySQL, you first need to set up Pabbly Connect. This integration allows you to automate the process of adding new contacts to Salesforce whenever a new row is added to your MySQL database. Start by signing up for a free Pabbly Connect account, which can be done in just a few minutes.

Once you are on the Pabbly Connect dashboard, click on ‘Create Workflow’ and name your workflow, for example, ‘MySQL to Salesforce’. After naming your workflow, click on ‘Create’ to access the workflow setup page.

---

2. Connecting MySQL to Pabbly Connect

The next step is to connect your MySQL account to Pabbly Connect. In the trigger window, select MySQL as your application. From the trigger event dropdown, choose ‘New Row in a Table’. Click on ‘Connect’ and then select ‘Add New Connection’.

Here, you will need to enter your MySQL database credentials including username, password, host, database name, and port. After entering the required details, click on ‘Save’. If you have an existing connection, you can use that instead. Once connected, select the table from which you want to fetch new rows, and specify the unique column (usually an ID column) that identifies each row uniquely.

• Select your MySQL application in Pabbly Connect.
• Choose ‘New Row in a Table’ as the trigger event.
• Enter the required MySQL database details.
• Select the table and unique column.

After saving your connection, click on ‘Save and Send Test Request’ to verify that the connection is successful. If successful, you should see the details of the most recent row added to your MySQL table in the response.

---

3. Creating a Salesforce Contact Using Pabbly Connect

Now that your MySQL database is connected to Pabbly Connect, the next step is to create a contact in Salesforce. Scroll down to the action window and select Salesforce as your application. Choose ‘Create Record’ as the action event and click on ‘Connect’.

To connect your Salesforce account, click on the ‘Connect with Salesforce’ button. If you are already logged into Salesforce, Pabbly Connect will detect your account. Click ‘Allow’ to complete the connection. After connecting, select the Salesforce object as ‘Contact’. You will then need to map the fields from MySQL to Salesforce, such as the first name, last name, mobile number, and email.

• Select Salesforce as the action application.
• Choose ‘Create Record’ as the action event.
• Map the required fields from MySQL to Salesforce.

After mapping all necessary fields, click on ‘Save and Send Test Request’. If everything is set up correctly, you will receive a positive response, confirming that the contact has been created in Salesforce.

---

4. Verifying the Integration Between MySQL and Salesforce

To ensure that the integration between MySQL and Salesforce via Pabbly Connect is functioning correctly, log into your Salesforce account and navigate to the Contacts section. You should see the newly created contact with the details you mapped from MySQL.

This verification step is crucial to confirm that the automation is working as intended. Each time you add a new row in your MySQL database, the same details should automatically create a new contact in Salesforce. This seamless integration saves time and reduces manual entry errors.

For further testing, you can add additional rows in your MySQL database. Each new entry should trigger the Pabbly Connect workflow, creating corresponding contacts in Salesforce. This demonstrates how effectively Pabbly Connect automates the process.

---

5. Conclusion

In this tutorial, we explored how to create Salesforce contacts from MySQL using Pabbly Connect. By following the steps outlined, you can automate the process of adding new contacts to Salesforce whenever a new row is added to your MySQL database. This integration not only saves time but also enhances data accuracy.

Utilizing Pabbly Connect for such automation tasks can significantly streamline your workflow, making it easier to manage contacts across platforms. If you have any questions or need assistance, feel free to reach out for support.

Learn how to create tasks in ClickUp for bookings scheduled in OnceHub using Pabbly Connect. Follow our step-by-step tutorial for seamless integration. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

---

1. Introduction to Pabbly Connect for OnceHub and ClickUp Integration

Pabbly Connect is an automation platform that allows you to integrate multiple applications seamlessly. In this tutorial, we will explore how to create a task in ClickUp for bookings scheduled in OnceHub using Pabbly Connect. This integration helps streamline your workflow by automatically creating tasks whenever a new booking is made.

To get started, sign up for a free account on Pabbly Connect. Once you have access to the dashboard, you can begin setting up your workflow to connect OnceHub and ClickUp. This automation will save you time and ensure that all booking details are captured accurately.

---

2. Setting Up Pabbly Connect for OnceHub Integration

To set up the integration, first log into your Pabbly Connect account. Click on the ‘Create Workflow’ button and name your workflow, for example, ‘OnceHub to ClickUp’. After naming your workflow, click on the ‘Create’ button to proceed. using Pabbly Connect

• Select OnceHub as the trigger app.
• Choose the trigger event as ‘Booking Scheduled’.
• Connect your OnceHub account by entering the API key.

After connecting OnceHub, you will set up the webhook URL that Pabbly Connect will use to receive data about new bookings. This ensures that every time a booking is made, the details will be captured and sent to ClickUp automatically.

---

3. Creating a Task in ClickUp Using Pabbly Connect

Once you have set up the trigger for OnceHub, the next step is to create a task in ClickUp. In the action window of Pabbly Connect, search for ClickUp and select it as the action app. Choose the action event as ‘Create Task’. using Pabbly Connect

Connect your ClickUp account by entering the API token. After connecting, specify the workspace and space where you want the task to be created. You will also need to select the folder and list within ClickUp where the task will be added.

• Map the task name to include the name of the person who booked the appointment.
• Add a description that includes booking details and notes.
• Set the due date and start date based on the booking time.

By mapping these fields, every new booking will automatically generate a corresponding task in ClickUp with all relevant details, ensuring that nothing is overlooked.

---

4. Formatting Date and Time for Bookings in Pabbly Connect

When creating tasks, it is essential to format the date and time correctly. Since OnceHub sends the booking time in UTC, you will need to convert it to your local timezone, such as Asia/Kolkata. Use the DateTime Formatter feature in Pabbly Connect to handle this conversion. using Pabbly Connect

To format the date and time, add an action step in Pabbly Connect for DateTime Formatter. Select the action event as ‘Format Date with Time Zone’. Map the start date and time received from OnceHub and specify the format you want to convert it to.

Choose the original format of the date and time from the dropdown. Select the desired output format, such as timestamp in milliseconds. Set the timezone to Asia/Kolkata for accurate scheduling.

This step ensures that the tasks created in ClickUp reflect the correct local time for your bookings, making it easier to manage appointments effectively.

---

5. Verifying the OnceHub and ClickUp Integration

After setting up the integration, it is crucial to verify that everything works as expected. You can do this by making a test booking in OnceHub and checking if a task is created in ClickUp with the correct details. using Pabbly Connect

Once you make a booking, go back to Pabbly Connect and check the response in the workflow. If the integration is successful, you should see the booking details reflected in the ClickUp task. This includes the task name, description, and scheduled times.

To verify, simply refresh your ClickUp workspace and navigate to the specified list. You should see a new task created with all the relevant information from the booking. This confirms that your integration is functioning correctly, allowing for seamless task management.

---

Conclusion

In this tutorial, we explored how to use Pabbly Connect to integrate OnceHub with ClickUp for automated task creation. By following these steps, you can streamline your booking process and ensure that every appointment is tracked efficiently. This integration not only saves time but also enhances productivity by automating routine tasks.

Learn how to automate adding new Zenler users to Microsoft Excel using Pabbly Connect with this detailed step-by-step tutorial. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

---

1. Introduction to Pabbly Connect for Zenler Integration

Pabbly Connect is an essential tool for automating workflows, enabling you to integrate Zenler with Microsoft Excel seamlessly. This tutorial will guide you through the steps to automatically add new Zenler users to Microsoft Excel using Pabbly Connect.

By following this process, you can ensure that every new enrollment in Zenler is tracked in your Excel sheet without any manual effort. Let’s start by accessing Pabbly Connect and setting up our workflow.

---

2. Setting Up Your Pabbly Connect Workflow

To begin, log into your Pabbly Connect account. If you don’t have one, you can create a free account in just a few minutes. Once logged in, navigate to your dashboard and click on the blue button labeled ‘Create Workflow’.

Next, provide a name for your workflow, such as ‘Add New Zenler Users to Microsoft Excel Automatically’, and click on ‘Create’. You will see two boxes representing the trigger and action. The trigger is the event that starts the workflow, while the action is what happens as a result.

• Click on the trigger box and select Zenler as the application.
• Choose the trigger event: ‘When a New Enrollment Occurs’.
• Copy the provided webhook URL for the next steps.

After copying the webhook URL, head back to your Zenler account, open the course you want to track, and navigate to the automation tab. Here, you will set up the webhook to send data to Pabbly Connect.

---

3. Configuring Zenler to Send Data to Pabbly Connect

In your Zenler account, find the course you want to automate. Click on the ‘Automation’ tab, then edit the automation rules. Add a new rule for enrollment and select the event to send a webhook.

Paste the webhook URL you copied from Pabbly Connect. Give this action a name, such as ‘Collect Student Data’, and save the changes. Make sure to apply this automation to existing students as well.

• Select ‘Enroll’ action in Zenler to trigger the webhook.
• Confirm that the action is live and ready to capture new enrollments.
• Return to Pabbly Connect and click on ‘Capture Webhook Response’ to test the setup.

Once the webhook is successfully set up, you will be ready to capture user data every time a new student enrolls in the selected course.

---

4. Adding New User Data to Microsoft Excel

Now that Pabbly Connect is capturing the new enrollment data from Zenler, the next step is to add this data to Microsoft Excel. In your Pabbly Connect workflow, select Microsoft Excel as the action application. using Pabbly Connect

Choose the action event ‘Add Row to Worksheet’. If this is your first time connecting to Excel, you will need to authenticate your account. Otherwise, select your existing connection and proceed.

Select the workbook where you want to add the new user data. Map the fields from Zenler to your Excel sheet, such as Name, Email, Course ID, and Enrollment Date. Click on ‘Save and Send Test Request’ to verify that the data is added correctly.

Once you have confirmed that the data is being sent to Microsoft Excel, you can refresh your Excel sheet to view the newly added user data.

---

5. Finalizing Your Automation with Pabbly Connect

With the integration complete, every time a new user enrolls in your Zenler course, their details will automatically populate in your Microsoft Excel sheet. This automation saves you time and ensures accurate record-keeping.

To finalize, test the entire workflow by enrolling a new user in your Zenler course. Check your Microsoft Excel sheet to confirm that the details have been captured correctly. With Pabbly Connect, you can automate this process effortlessly, allowing you to focus on other important tasks.

In summary, Pabbly Connect provides a powerful solution for integrating Zenler and Microsoft Excel, streamlining your workflow and enhancing productivity. Now you can sit back and let Pabbly Connect handle the tedious tasks of data entry for you.

---

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of adding new Zenler users to Microsoft Excel. By following the steps outlined, you can ensure efficient data management and save valuable time. Automate your workflows today with Pabbly Connect!

Learn how to send conditional SMS using Pabbly Connect to integrate Google Forms with Twilio. Step-by-step guide for seamless automation. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To send SMS when a condition is met, first access Pabbly Connect. This platform allows seamless integration between Google Forms and Twilio for sending SMS. If you don’t have an account, create a free one to get started.

Once logged into Pabbly Connect, navigate to the dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. Give your workflow a descriptive name, such as ‘Send Conditional SMS to Customers’.

---

2. Setting Up Google Forms as the Trigger

In this step, you will set Google Forms as the trigger application in Pabbly Connect. Select ‘Google Forms’ from the list of applications and choose the trigger event ‘New Response Received’. This allows the workflow to begin whenever a new form submission is made.

• Select the appropriate Google account linked to your forms.
• Authorize Pabbly Connect to access your Google Forms.
• Choose the specific form you want to monitor for responses.

After setting up the trigger, Pabbly Connect will provide a webhook URL. Copy this URL as you will need to integrate it into your Google Form’s settings to forward responses to Pabbly Connect.

---

3. Configuring Google Sheets for Data Collection

Next, you will configure Google Sheets to collect the responses from your Google Form. Open the associated Google Sheet and ensure it is ready to receive data. The data will be sent to Pabbly Connect through the webhook URL you copied earlier.

To link Google Sheets with Pabbly Connect, install the Pabbly Connect Webhooks add-on. Go to the Add-ons menu, search for the Pabbly Connect Webhooks, and follow the installation prompts. Once installed, paste the webhook URL into the add-on settings, specifying the column that will trigger the data transfer.

---

4. Creating Conditional SMS with Twilio

Now, set up Twilio as the action application in Pabbly Connect. Choose ‘Twilio’ and select the action event ‘Send SMS’. This allows you to send SMS messages based on the conditions you define.

• Connect your Twilio account using your Account SID and Auth Token.
• Define the message body, including placeholders for dynamic data from the Google Form.
• Specify the sender number from your Twilio account.

In this step, you will also set up conditions using the router feature in Pabbly Connect. This allows you to send different messages based on the city selected in the Google Form. Create conditions for cities like Kerala, Manali, and Northeast, ensuring the correct brochure link is included in each SMS.

---

5. Testing the Integration and Workflow

After setting everything up, it’s crucial to test the integration. Submit a test response through your Google Form and check if the SMS is sent correctly based on the selection. For example, if ‘Kerala’ is selected, the SMS should confirm the selection and provide a brochure link.

Monitor the responses in Pabbly Connect and ensure that the SMS sent matches the expected output. If adjustments are needed, revisit the router settings to tweak the conditions or message content.

Once testing is complete and everything functions as intended, you can sit back and let Pabbly Connect automate the SMS sending process for all future form submissions.

---

Conclusion

This guide detailed how to use Pabbly Connect to integrate Google Forms and Twilio for sending conditional SMS messages. By following these steps, you can automate responses efficiently and enhance customer engagement.