Author: Nitin Maheshwari

Learn how to seamlessly integrate MS Excel with ActiveCampaign using Pabbly Connect for automatic contact addition. 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 MS Excel with ActiveCampaign, start by accessing Pabbly Connect. This platform enables seamless automation between various applications. You can reach Pabbly Connect by visiting Pabbly.com/connect, where you can create a free account to begin your automation journey.

Once you have signed in, you will land on the Pabbly Connect dashboard. Here, you can easily create workflows to automate tasks such as adding contacts from MS Excel to ActiveCampaign. This eliminates the need for manual data entry, streamlining your processes significantly.

---

2. Creating a Workflow in Pabbly Connect

After accessing your dashboard, the next step is to create a new workflow. Click on the ‘Create Workflow’ button and name it something like ‘MS Excel to ActiveCampaign Automation’. This will help you identify the workflow later. using Pabbly Connect

• Click on ‘Create’ to start setting up your automation.
• You will see two boxes: Trigger and Action.
• Select ‘Microsoft Excel’ as the trigger application.

In the trigger event options, select ‘Add Row in Worksheet’. This means that every time a new row is added in your Excel sheet, it will trigger the action to add a contact in ActiveCampaign. This setup is crucial for automating your contact management.

---

3. Connecting MS Excel to Pabbly Connect

Now, it’s time to connect your MS Excel account to Pabbly Connect. Click on ‘Add New Connection’ and follow the prompts to link your Microsoft account, ensuring you select the OneDrive account where your Excel file is stored.

Once connected, select the workbook from your OneDrive that contains your contacts. In this case, choose the ‘All Subscribers List New’ workbook. Pabbly Connect will then fetch the available worksheets, allowing you to select the specific sheet you want to use for your automation.

---

4. Setting Up ActiveCampaign in Pabbly Connect

After configuring MS Excel, the next step is to set up ActiveCampaign within Pabbly Connect. In the action application, select ‘ActiveCampaign’ and choose the action event as ‘Create Contact’. This will allow you to automatically add contacts to your ActiveCampaign CRM.

• You will need to connect your ActiveCampaign account by entering your API key and URL.
• To get these details, log into ActiveCampaign, go to Settings, and then Developer.
• Copy the API URL and key, and paste them into Pabbly Connect.

This connection ensures that every new contact added in Excel will automatically be created in ActiveCampaign, allowing you to manage your contacts effectively.

---

5. Mapping Data from Excel to ActiveCampaign

In this final step, you will map the data from your Excel sheet to the corresponding fields in ActiveCampaign. Use the dropdown options to map the email address, full name, and phone number from the previous step’s data.

For instance, if your Excel sheet contains the full name in a single field, you can map that to the name field in ActiveCampaign. Once all relevant fields are mapped correctly, click on ‘Save and Send Test Request’ to ensure that the automation works as intended.

If successful, you will see the new contact appear in your ActiveCampaign account, confirming that Pabbly Connect has successfully automated the process of adding contacts from MS Excel.

---

Conclusion

Using Pabbly Connect to integrate MS Excel with ActiveCampaign allows for seamless automation of contact management. This process eliminates manual entry and ensures your CRM is always up to date with the latest contacts. By following these steps, you can efficiently manage your contacts and enhance your email marketing efforts.

Learn how to post Slack channel messages from new Microsoft Excel rows using Pabbly Connect. Step-by-step guide 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 Excel and Slack Integration

To begin the process of posting Slack channel messages from new Microsoft Excel rows, you need to access Pabbly Connect. Start by navigating to the Pabbly Connect website at Pabbly.com/connect. Here, you will find options to sign in or sign up for free.

If you are a new user, sign up by clicking on the ‘Sign Up for Free’ button. This process is quick and grants you 100 free tasks upon account creation. Existing users can simply sign in to their account. Once logged in, you will be directed to the dashboard of Pabbly Connect.

---

2. Creating a Workflow in Pabbly Connect

After accessing your Pabbly Connect dashboard, locate the ‘Create Workflow’ button on the right side of the screen. Click on it to initiate the workflow setup. A dialog box will prompt you to name your workflow; for this integration, you can name it ‘MS Excel to Slack Integration’.

• Click on ‘Create’ to proceed.
• This will lead you to a new window with trigger and action events.

In this window, you will set Microsoft Excel as your trigger application. Select the trigger event as ‘New Row in Worksheet’. This event will activate your workflow every time a new row is added to your Excel spreadsheet.

---

3. Connecting Microsoft Excel to Pabbly Connect

Next, you need to connect your Microsoft Excel account to Pabbly Connect. Click on the ‘Connect’ button after selecting Microsoft Excel as the trigger application. Here, you will be prompted to add a new connection.

Select your Microsoft Excel account and grant permission for Pabbly Connect to access it. After successful authorization, choose the specific workbook where your data is stored. For this example, select the workbook named ‘Slack Messages’ and the worksheet titled ‘Demo’.

---

4. Setting Up Slack to Receive Messages

Now that your Excel connection is established, it’s time to set up Slack as the action application. Choose Slack and select the action event as ‘Send Channel Message’. Click on the ‘Connect’ button to link your Slack account to Pabbly Connect.

• Choose the token type as ‘User’ for sending messages.
• Authorize Pabbly Connect to access your Slack workspace.
• Select the specific Slack channel where messages will be posted.

Once the channel is selected, you will need to map the data received from Excel to the message format for Slack. This involves selecting the message content that you want to send to your Slack channel.

---

5. Testing the Integration Between Excel and Slack

After setting up your workflow, it’s crucial to test the integration. Click on the ‘Save and Send Test Request’ button in Pabbly Connect. This will send a test message to your selected Slack channel.

Check your Slack channel to verify if the message was received successfully. For example, you might see a message saying, ‘Hello team, we have been given the permission to go ahead with this project. Congratulations!’ This confirms that your integration is functioning correctly.

Keep in mind that the trigger checks for new data every 8 hours, meaning any new rows added to your Excel sheet will be sent to Slack after this interval. This one-time setup will allow for ongoing automation without further intervention.

---

Conclusion

Integrating Microsoft Excel with Slack through Pabbly Connect allows you to automate message posting seamlessly. By following the steps outlined, you can ensure that your team stays updated with the latest information from Excel. This integration enhances communication and efficiency within your team.

Learn how to create records in Airtable from Microsoft Excel using Pabbly Connect. This tutorial covers the exact steps to automate your workflow seamlessly. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

---

1. Accessing Pabbly Connect for Integration

To start integrating Microsoft Excel with Airtable, the first step is to access Pabbly Connect. You can do this by typing ‘Pabbly.com/connect’ in your browser. This will take you to the landing page of the platform.

Once on the landing page, you will see options to either sign in or sign up for free. If you are a new user, signing up is quick and provides you with 100 free tasks. After signing in, navigate to the dashboard to begin creating your workflow.

---

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, you will find a tab labeled ‘Create Workflow’. Click on this to initiate the process. A dialog box will prompt you to name your workflow; for this integration, you might name it ‘MS Excel to Airtable Integration’. After naming, click on ‘Create’ to proceed. using Pabbly Connect

• Click on ‘Create Workflow’ in the dashboard.
• Name the workflow appropriately, such as ‘MS Excel to Airtable Integration’.
• Click ‘Create’ to set up the workflow.

After creating the workflow, you will see options for setting up a trigger and an action. The trigger will be Microsoft Excel, and the action will be Airtable. This setup will allow you to automate the process of transferring data from Excel to Airtable.

---

3. Setting Up Microsoft Excel as Trigger

Now that you have created your workflow, the next step is to set Microsoft Excel as the trigger application. Click on the trigger application option and select Microsoft Excel from the list. using Pabbly Connect

For the trigger event, choose ‘New Row Added’. This means that the workflow will activate every time a new row is added to your Excel sheet. Click on ‘Connect’ to establish a connection between Pabbly Connect and your Microsoft Excel account.

• Select Microsoft Excel as the trigger application.
• Choose ‘New Row Added’ as the trigger event.
• Click ‘Connect’ to link your Excel account.

After clicking on ‘Connect’, you will be prompted to log into your Microsoft account. Grant the necessary permissions to allow Pabbly Connect to access your Excel data. Once connected, select the workbook and worksheet where your data is stored.

---

4. Setting Up Airtable as Action Application

With Microsoft Excel set as the trigger, the next step is to configure Airtable as the action application. Click on the action application option and select Airtable. Then, choose ‘Create Record’ as the action event. using Pabbly Connect

Pabbly Connect will prompt you to connect to your Airtable account. For this, you will need your Airtable API key, which can be found in your Airtable account settings. Copy the API key and paste it into Pabbly Connect to establish the connection.

Select Airtable as the action application. Choose ‘Create Record’ as the action event. Paste your Airtable API key to connect.

After establishing the connection, you will need to select the base and the table where you want to create the records. Map the fields from your Excel data to the corresponding fields in Airtable to ensure accurate data transfer.

---

5. Testing the Integration

Once you have set up both the trigger and action applications, it is time to test the integration. In Pabbly Connect, click on ‘Save and Send Test Request’ to send a test record from Excel to Airtable. using Pabbly Connect

If everything is set up correctly, you should see the new record appear in your Airtable base. To ensure the automation works in real-time, add a new row in your Excel sheet and check if the data reflects in Airtable after the polling time.

Note that Microsoft Excel has a polling time of eight hours, meaning it checks for new data every eight hours. Therefore, after adding a new row, you may need to wait for this duration to see the changes in Airtable.

---

Conclusion

Using Pabbly Connect, you can seamlessly integrate Microsoft Excel with Airtable to automate record creation. This tutorial has covered all the steps to set up the integration, ensuring that every new row added in Excel is reflected in Airtable. By following these steps, you can enhance your workflow efficiency and save time on manual data entry.

Learn how to automate SMS sending on webinar registrations using Pabbly Connect, WebinarKit, and Twilio in this step-by-step tutorial. 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. Accessing Pabbly Connect for SMS Automation

To send SMS notifications for webinar registrations, the first step is to access Pabbly Connect. Type the URL Pabbly.com/connect to reach the landing page.

Upon arrival, you will see options to sign in or sign up for free. Existing users can sign in, while new users need to sign up, which only takes a couple of minutes. After signing up, you will receive 100 free tasks to start automating your workflows.

---

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard and click on the ‘Create Workflow’ button. A dialog box will prompt you to name your workflow.

For this integration, name the workflow something like ‘WebinarKit to Twilio’ to indicate that you will be connecting WebinarKit with Twilio. After naming, click on ‘Create’ to proceed.

• Name your workflow appropriately.
• Click on ‘Create’ to initiate the workflow.

This will take you to a new window where you will set up the trigger and action for your workflow. The trigger application will be WebinarKit, and the action application will be Twilio.

---

3. Setting Up the WebinarKit Trigger

In Pabbly Connect, select WebinarKit as your trigger application. Next, choose the trigger event as ‘New Webinar Registration’. This event will initiate the workflow whenever a new registration occurs.

Upon selecting the trigger event, you will receive a webhook URL. This URL acts as a bridge connecting Pabbly Connect with WebinarKit. Copy this URL as you will need to paste it into your WebinarKit settings.

• Select ‘New Webinar Registration’ as the trigger event.
• Copy the generated webhook URL for later use.

Now, head over to your WebinarKit account to paste this webhook URL into the appropriate settings for your webinars.

---

4. Configuring the WebinarKit Webhook

In your WebinarKit account, locate the webinar you want to integrate. Click on ‘Edit Webinar’ and scroll down to the ‘Webhooks’ section. Here, paste the webhook URL you copied from Pabbly Connect.

After pasting the URL, click on ‘Complete’ to finalize the changes. This step ensures that your WebinarKit is now linked to Pabbly Connect, allowing it to send registration data automatically.

Paste the webhook URL in the Webhooks section of your webinar settings. Click ‘Complete’ to save the webhook configuration.

Now, return to Pabbly Connect to test the webhook connection by performing a mock registration.

---

5. Testing the Registration and Sending SMS via Twilio

To test the integration, perform a mock registration through the registration link provided by WebinarKit. Fill in the necessary details, such as first name, email address, and mobile number, and click on ‘Register Now’.

Once the registration is complete, go back to Pabbly Connect and set up Twilio as the action application. Choose the action event ‘Send SMS Message’. Connect your Twilio account by entering the required credentials such as Account SID and Authorization Token.

Select Twilio as the action application. Choose ‘Send SMS Message’ as the action event. Enter your Twilio Account SID and Authorization Token to connect.

After setting up Twilio, configure the SMS message body, including the registrant’s name and webinar details. Finally, click on ‘Save and Send Test Request’ to send a test SMS. If everything is set up correctly, you will receive the SMS confirming the registration.

---

Conclusion

This tutorial demonstrated how to send SMS notifications on webinar registrations using Pabbly Connect with WebinarKit and Twilio. By following the steps outlined, you can easily automate your webinar registration notifications.

Utilizing Pabbly Connect streamlines the integration process, ensuring that your registrants receive timely SMS updates. Start automating your webinar notifications today!

Learn how to automate WhatsApp notifications for WooCommerce orders using Pabbly Connect. Step-by-step guide to set up your integration seamlessly. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Pabbly Connect for WooCommerce Notifications

To start sending WhatsApp notifications for WooCommerce orders, you’ll need to set up Pabbly Connect. First, access the Pabbly Connect landing page and sign up for a free account. This will allow you to create automated workflows without any coding.

Once logged in, navigate to the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button to begin. Name your workflow appropriately, such as ‘WooCommerce Order Notifications on WhatsApp,’ and click ‘Create’ to proceed.

---

2. Connecting WooCommerce to Pabbly Connect

In this section, you will connect WooCommerce as the trigger application in Pabbly Connect. Search for WooCommerce in the trigger application section and select it. Choose the trigger event as ‘New Order Created’. This setup will allow you to capture new orders automatically.

• Select WooCommerce as the trigger application.
• Choose ‘New Order Created’ as the trigger event.
• Copy the generated webhook URL.

After copying the webhook URL, go to your WordPress dashboard. Navigate to WooCommerce settings, click on the ‘Advanced’ tab, and then click on ‘Webhooks’. Here, add a new webhook by pasting the copied URL into the delivery URL field. Set the status to active and select the event ‘Order Created’. Save the webhook to complete the connection.

---

3. Capturing Order Data in Pabbly Connect

With WooCommerce connected, it’s time to capture the order data in Pabbly Connect. Click on the ‘Recapture Webhook Response’ button in the Pabbly Connect interface. This will start listening for new order data from WooCommerce.

To test this, create a test order in your WooCommerce store. Once the order is placed, return to Pabbly Connect and check if the order details have been captured. You should see information such as order ID, customer name, and product details displayed in the response.

---

4. Connecting WhatsApp to Send Notifications

Next, you will set up WhatsApp as the action application in Pabbly Connect. Search for WhatsApp and select the action event as ‘Send Template Message’. Connect to the WhatsApp Cloud API by entering your permanent access token, phone number ID, and business account ID.

• Select WhatsApp as the action application.
• Choose ‘Send Template Message’ as the action event.
• Enter your WhatsApp Cloud API details.

After connecting, select the message template you created for order confirmations. Map the customer’s WhatsApp number and other dynamic fields such as product name and delivery date to personalize the message.

---

5. Testing the Integration and Finalizing

Finally, test the integration by sending a test message to the customer’s WhatsApp number using Pabbly Connect. Click on ‘Save and Send Test Request’ to check if the message is delivered correctly. Ensure that the message contains all the mapped fields.

If everything is set up correctly, you should receive a confirmation message on WhatsApp indicating that the order has been successfully placed. This automation will run in the background, sending notifications for all future orders automatically.

---

Conclusion

By utilizing Pabbly Connect, you can seamlessly integrate WooCommerce with WhatsApp to automate order notifications. This setup enhances customer communication and streamlines your order management process.

Learn how to send and receive WhatsApp messages using Pabbly Connect and WhatsApp Cloud API in this detailed step-by-step tutorial. 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. Setting Up Pabbly Connect for WhatsApp Integration

To begin sending and receiving WhatsApp messages, you first need to set up your account with Pabbly Connect. Start by visiting the Pabbly Connect landing page, where you can create a free account by clicking the ‘Sign Up Free’ button. This will allow you to explore the automation capabilities offered by Pabbly Connect.

Once you have created your account, log in to access the dashboard. From here, you can create a new workflow specifically tailored for WhatsApp messaging. Click on the ‘Create Workflow’ button, provide a suitable name for your workflow, such as ‘WhatsApp Messages’, and then click on the ‘Create’ button to proceed.

---

2. Configuring WhatsApp Cloud API with Pabbly Connect

In this section, you will connect your WhatsApp number through the WhatsApp Cloud API using Pabbly Connect. To do this, you need to ensure that your WhatsApp number is linked to the Cloud API. Follow the instructions provided in the Pabbly Connect platform to access the WhatsApp Cloud API.

• Search for the WhatsApp Cloud API option in Pabbly Connect.
• Select the trigger event as ‘Message Notifications’.
• Copy the generated webhook URL.

After copying the webhook URL, navigate to your Cloud API settings. Here, you will paste the webhook URL in the callback URL field and follow the verification process to ensure the connection is established successfully.

---

3. Testing the WhatsApp Integration

Once you have configured the WhatsApp Cloud API with Pabbly Connect, it’s time to test the integration. You can manually send a message to your WhatsApp number to verify that the messages are being captured in Pabbly Connect. This step is crucial to ensure that the automation workflow is functioning as expected.

After sending a test message, check your Pabbly Connect dashboard to see if the message data appears correctly. You should see details such as the sender’s phone number and the message content captured in the response section, confirming that the integration is live.

---

4. Saving Received Messages to Google Sheets via Pabbly Connect

To store the messages received on WhatsApp, you can integrate Google Sheets with Pabbly Connect. Start by adding a new action step in your workflow and select Google Sheets as the application. Choose the action event as ‘Add New Row’ to save each received message into a spreadsheet.

• Connect your Google account to Pabbly Connect.
• Select the Google Sheet where you want to save the messages.
• Map the message body field to the appropriate column in your sheet.

Once you have completed these steps, send a test request to ensure that the message is saved correctly in your Google Sheets. This integration allows you to keep a record of all messages received on WhatsApp for future reference.

---

5. Sending Messages via WhatsApp using Pabbly Connect

After successfully receiving and storing messages, you can also send messages through WhatsApp using Pabbly Connect. To do this, add another action step in your workflow and select the WhatsApp Cloud API again. This time, choose the action event as ‘Send Template Message’ or ‘Send Text Message’ based on your needs.

When using a template message, ensure that you have created and approved message templates in your Cloud API settings. Select the template you wish to use, and map the required fields such as recipient mobile number and any dynamic content you want to include in the message.

After mapping the necessary fields, click on ‘Save and Send Test Request’ to send a message through WhatsApp. This feature allows you to automate replies or send bulk messages efficiently, enhancing your communication capabilities.

---

Conclusion

In this tutorial, we explored how to send and receive WhatsApp messages using Pabbly Connect and the WhatsApp Cloud API. By following the steps outlined, you can easily set up your workflows to automate messaging tasks, store received messages in Google Sheets, and send replies effortlessly. Embrace the power of automation with Pabbly Connect to enhance your WhatsApp communication strategies.

Learn how to integrate Reddit with Instagram using Pabbly Connect to drive traffic effectively. Follow this detailed tutorial for step-by-step guidance. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

---

1. Setting Up Pabbly Connect for Instagram and Reddit Integration

To drive traffic from Reddit to Instagram, you first need to set up Pabbly Connect. This platform allows you to automate the process of sharing your Instagram posts on Reddit. Start by signing up for a free account on Pabbly Connect and logging into your dashboard.

Once logged in, create a new workflow by clicking on the ‘Create Workflow’ button. You can name this workflow something relevant, such as ‘Reddit to Instagram Automation’. This workflow will facilitate the integration between Instagram and Reddit through Pabbly Connect.

---

2. Configuring Instagram as the Trigger Application in Pabbly Connect

In this step, you will set Instagram as the trigger application in your Pabbly Connect workflow. Select Instagram for Business as your trigger application. The trigger event will check for new posts in your Instagram account every 10 minutes.

To configure this, choose the ‘New Media Posted in My Account’ option as the trigger event. Click on ‘Connect’ and then select ‘Add New Connection’. You will be prompted to log into your Instagram account, where you must authorize Pabbly Connect to access your Instagram data.

---

3. Testing the Instagram Connection in Pabbly Connect

After connecting, you need to test the Instagram connection in Pabbly Connect. Click on ‘Save and Send Test Request’. This action will retrieve the most recent post from your Instagram account. You should see details such as username, media type, media URL, and the caption of the post.

Once the data is captured, you can confirm that the connection is successful. The test data will include the link to your Instagram post, which will later be shared on Reddit. This step is crucial for ensuring that the automation works correctly.

---

4. Setting Up Reddit as the Action Application in Pabbly Connect

Next, you will set up Reddit as the action application. Search for Reddit in the Pabbly Connect interface and select the option to ‘Submit a Link Post’. Click on ‘Connect’ and then ‘Add New Connection’ to link your Reddit account.

You will need to authorize Pabbly Connect to access your Reddit account. After successful authorization, you will be prompted to fill in details for the new Reddit post, including the title, subreddit name, and the URL of your Instagram post. Ensure you map the caption from the previous step as the title of the Reddit post.

• Enter the title by mapping it from the Instagram post caption.
• Input the subreddit name where you want to share the post.
• Map the URL of the Instagram post from the trigger data.

After entering the required details, click on ‘Save and Send Test Request’ to check if the post is successfully submitted to Reddit. This will automate the sharing process, enhancing your Instagram traffic.

---

5. Finalizing the Automation and Driving Traffic

After successfully testing the Reddit connection, your automation setup is complete. With Pabbly Connect, every time you post on Instagram, the link to your post will automatically be shared in your specified Reddit community. This process requires no manual effort once set up.

This automation allows you to drive more traffic to your Instagram account through Reddit, effectively increasing your visibility. You can monitor the performance of your posts and adjust your strategy as needed to maximize engagement.

---

Conclusion

Using Pabbly Connect to integrate Reddit and Instagram allows you to automate the sharing of your Instagram posts, significantly driving traffic. Set up this workflow to enhance your online presence effortlessly.

Learn how to automate WhatsApp notifications for Razorpay payments with Pabbly Connect. Step-by-step guide for seamless integration. 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. Accessing Pabbly Connect for Razorpay WhatsApp Integration

To begin automating WhatsApp messages for Razorpay payments, you first need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect website. If you are new, click on ‘Sign Up Free’ to create an account quickly, or log in if you already have an account.

After signing in, you will be directed to the ‘All Apps’ page. Click on ‘Access Now’ under Pabbly Connect. This will take you to the Pabbly Connect dashboard where you can create a new workflow for the Razorpay integration.

---

2. Creating a Workflow in Pabbly Connect

Once in the Pabbly Connect dashboard, click on ‘Create Workflow’ and name your workflow, for instance, ‘Razorpay to WhatsApp’. This name will help you identify the workflow later. Upon creating the workflow, you will see two main sections: the Trigger and Action windows.

• Select the app as Razorpay in the Trigger window.
• Choose ‘Payment Captured’ as the Trigger Event.
• Copy the generated webhook URL from Pabbly Connect.

After copying the webhook URL, proceed to your Razorpay dashboard. Click on ‘Settings’ and then the ‘Webhook’ section. Here, add a new webhook by pasting the copied URL and selecting the event as ‘Payment Captured’. This establishes the connection between Razorpay and Pabbly Connect.

---

3. Testing the Razorpay and Pabbly Connect Integration

After setting up the webhook, it’s time to test the integration. You will need to make a test payment through your Razorpay payment page. Copy the payment page URL and paste it into a new browser tab. Fill in the payment details, including a dummy customer name, email, and WhatsApp number without the plus sign. using Pabbly Connect

• Select the product and enter the required customer details.
• Use test card details to complete the payment.

Once the payment is processed, return to your Pabbly Connect dashboard. You should see the payment details captured in the response section. Ensure that the details reflect the correct customer information and payment amount.

---

4. Formatting the Payment Amount for WhatsApp Message

In the captured payment details, Razorpay may send the amount without decimals. To correct this, use the Number Formatter feature in Pabbly Connect. In the Action window, search for ‘Number Formatter’ and select ‘Perform Math Operation’ as the action event.

Map the amount received from Razorpay. Choose to divide the amount by 100 to format it correctly.

After setting this up, click on ‘Save and Send Test Request’. You should see the correctly formatted amount, which will be used in the WhatsApp message sent to the customer as confirmation.

---

5. Sending WhatsApp Messages via Pabbly Connect

Now that you have the correct payment amount, it’s time to send the WhatsApp message. Add another action step by searching for ‘WhatsApp Cloud API’ and select ‘Send Template Message’ as the action event. Connect your WhatsApp Cloud API account to Pabbly Connect using the required credentials.

Choose the approved template for the WhatsApp message. Map the recipient’s mobile number and the dynamic fields for customer name and payment amount.

After entering all the required details, click on ‘Save and Send Test Request’. If successful, a WhatsApp message will be sent to the customer confirming their payment. You can check the WhatsApp account to verify that the message has been received.

---

Conclusion

In this tutorial, we explored how to automate WhatsApp messages for Razorpay payments using Pabbly Connect. By following the steps outlined, you can ensure that your customers receive instant payment confirmations via WhatsApp, enhancing their experience and streamlining your payment process.

Learn how to integrate WooCommerce with WhatsApp for order notifications using Pabbly Connect. Follow this step-by-step tutorial for seamless automation. 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. Setting Up Pabbly Connect for WooCommerce

To receive notifications on WhatsApp for WooCommerce orders, you first need to set up Pabbly Connect. Begin by visiting the Pabbly Connect website and signing up for a free account if you haven’t already. Once you log in, you’ll be directed to the dashboard where you can create a new workflow.

Click on ‘Create Workflow’ and name it something relevant, such as ‘WooCommerce to WhatsApp’. This naming convention helps in identifying your workflow later. After naming your workflow, you will see a trigger window and an action window, which are essential for the automation process.

---

2. Triggering New Orders in WooCommerce

In the trigger window, search for ‘WooCommerce’ and select it. From the trigger event dropdown, choose ‘New Order Created’. This selection is crucial as it tells Pabbly Connect to initiate the workflow whenever a new order is placed in your WooCommerce store.

• Select the ‘New Order Created’ event.
• Copy the webhook URL provided by Pabbly Connect.
• Navigate to your WooCommerce settings to add this webhook.

Once you have copied the webhook URL, go to your WooCommerce store settings. Under WooCommerce, select ‘Settings’ and then click on the ‘Advanced’ tab. From there, access the ‘Webhooks’ section and add a new webhook using the copied URL. Make sure to set the status to active and select the topic as ‘Order Created’.

---

3. Testing the Integration with a Dummy Order

After setting up the webhook, it’s time to test if the integration works correctly. In your Pabbly Connect workflow, click on the ‘Recapture Webhook’ button. This will change the status to waiting for a webhook response. Now, go to your WooCommerce store and place a dummy order to trigger the webhook.

Fill in the required customer details and complete the order. Once the order is placed, Pabbly Connect will capture the order details through the webhook. You should see a response in your Pabbly Connect dashboard reflecting the order information.

---

4. Setting Up WhatsApp Notifications

Now that you have successfully captured the order details, the next step is to set up WhatsApp notifications. In the action window of your workflow, search for ‘WhatsApp Cloud API’ and select it. Choose the action event as ‘Send Template Message’. This action will allow you to send a WhatsApp message whenever a new order is created. using Pabbly Connect

• Connect to WhatsApp Cloud API using your account credentials.
• Select the message template you want to use for notifications.
• Map the order details to the respective fields in the template.

After connecting to the WhatsApp Cloud API, you will need to select a message template that you have created and approved on the WhatsApp platform. This template will contain dynamic fields that will be populated with order details from WooCommerce, such as product name, quantity, and customer information.

---

5. Final Testing and Verification of Automation

With the WhatsApp notification setup complete, it’s time to test the entire automation process. Place another dummy order in your WooCommerce store. After placing the order, check your WhatsApp account for the notification.

If everything is set up correctly, you should receive a WhatsApp message containing the order details. This confirms that Pabbly Connect is successfully facilitating the integration between WooCommerce and WhatsApp for order notifications. Make sure to monitor the integration for any issues.

---

Conclusion

In this tutorial, we explored how to use Pabbly Connect to receive WhatsApp notifications for WooCommerce orders. By following the steps outlined above, you can automate the process and stay updated on new orders seamlessly. This integration not only saves time but also enhances customer engagement through timely notifications.

Learn how to send emails with attachments from MS Excel using Pabbly Connect. Follow this step-by-step tutorial to automate your email sending process efficiently. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

---

1. Access Pabbly Connect to Start Email Automation

To send emails with attachments from MS Excel, you first need to access Pabbly Connect. This tool allows you to automate workflows between applications like Excel and Outlook seamlessly. Begin by visiting the official Pabbly website.

As a new user, click on the ‘Sign Up for Free’ button to create your account. If you are an existing user, simply log in to your account. Once logged in, navigate to the Pabbly Connect dashboard.

---

2. Create a Workflow in Pabbly Connect

After accessing Pabbly Connect, you need to create a workflow to automate the email sending process. Click on the ‘+’ icon to create a new workflow and name it ‘Send Email with Attachment from MS Excel’. This name should reflect the purpose of your automation.

Now, in the trigger window, select ‘Microsoft Excel’ as your application. Choose the trigger event as ‘New Row in a Worksheet’. This selection allows Pabbly Connect to monitor your Excel sheet for any new entries.

• Select ‘Connect’ and then ‘Add New Connection’.
• Authorize Pabbly Connect to access your Microsoft Excel account.
• Choose the specific workbook and worksheet that contains your email data.

Once the connection is established, save and send a test request to capture the latest data from your Excel sheet. This step ensures that Pabbly Connect can retrieve the necessary details for sending emails.

---

3. Map Data for Sending Emails

With Pabbly Connect set up to receive data from MS Excel, the next step is to configure the action to send emails. In the action window, select ‘Microsoft Office 365’ as your application and choose ‘Send Mail’ as the action event. This setup allows Pabbly Connect to send emails through your Outlook account. using Pabbly Connect

Click on ‘Connect’ and then ‘Add New Connection’ to link your Office 365 account. Authorize the connection by allowing Pabbly Connect to access your Outlook information. Once connected, you can start mapping the email content.

• Map the subject line and body content from the Excel trigger response.
• Include the recipient’s email address from the Excel data.
• Attach any necessary files using the attachment link from the Excel sheet.

Once you have mapped all the required fields, click on ‘Save and Send Test Request’ to send a test email. This action verifies that your setup is functioning correctly.

---

4. Test the Real-Time Integration

After successfully sending a test email, you can check if the integration works in real-time. Go back to your Excel sheet and enter new customer details. Include all necessary information such as name, email address, subject, body message, and attachment link.

Once you have added this new entry, return to your Outlook account and refresh the inbox. Since Pabbly Connect uses a polling mechanism, it may take a few moments for the email to appear. Be patient as it checks for new entries every few minutes.

When the email arrives, open it to confirm that all details, including the attachment, are correctly displayed. This step ensures that your integration between MS Excel and Outlook via Pabbly Connect is working as expected.

---

5. Conclusion: Automate Your Email Process with Pabbly Connect

In this tutorial, you learned how to send emails with attachments from MS Excel using Pabbly Connect. By following the steps outlined, you can automate the process of emailing customers directly from your Excel sheet. This integration not only saves time but also enhances your workflow efficiency.

Utilizing Pabbly Connect allows you to streamline communications and ensure timely delivery of important documents. Start automating your email processes today and experience the benefits of integration!