Automatically Get WhatsApp Notification When Multiple Products Go Out of Stock Using Pabbly Connect

Learn how to automatically receive WhatsApp notifications for out-of-stock products using Pabbly Connect, Google Sheets, and WTI. Follow these detailed steps to set it up.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To set up automatic WhatsApp notifications for out-of-stock products, the first step is accessing Pabbly Connect. Start by going to the Pabbly website where you can sign in if you already have an account or sign up for free if you’re new. This will only take a couple of minutes and allows you to utilize 100 free tasks every month.

Once signed in, navigate to the dashboard. Here, you’ll find the option to create a new workflow. Click on the ‘Create Workflow’ button, name your workflow ‘Alert When Multiple Products Go Out of Stock’, and select the folder where you want to save it. This setup is essential as it lays the foundation for your integration process using Pabbly Connect.

2. Setting Up Triggers in Pabbly Connect

After creating your workflow in Pabbly Connect, the next step is to set up a trigger. In this case, you will use the ‘Schedule by Pabbly’ feature. This allows you to schedule your workflow to run daily. Click on the trigger section and select the Schedule option.

• Choose the frequency as ‘Every Day’.
• Set the time for the workflow to execute, such as 11:00 AM.

Once these details are entered, click on ‘Save’. This will ensure that your workflow checks for out-of-stock products every day at the specified time, making the process efficient and automated using Pabbly Connect.

3. Integrating Google Sheets with Pabbly Connect

Next, you will need to add Google Sheets as an action application in your Pabbly Connect workflow. This is where your product stock details are stored. Click on the action section and select Google Sheets, then choose the action event as ‘Lookup Spreadsheet Row V2’. This action will help you find the stock values of your products.

Connect your Google Sheets account by clicking on ‘Add New Connection’ and authorizing access. You will then select the spreadsheet named ‘Stock Details’ and the specific sheet where your product data is stored. Map the relevant columns to ensure that Pabbly Connect retrieves the correct stock information.

4. Transforming Data with Pabbly Connect

Once you have the stock data from Google Sheets, the next step is to transform this data using Pabbly Connect. You will utilize the ‘Data Transformer’ tool to format the retrieved data into a more usable format. Select the action as ‘Line Itemizer’ to convert the data into a comma-separated format.

• Map the output from the previous step to the line item field.
• Click on ‘Save and Send Test Request’ to check the results.

This transformation prepares the data for the next step where you will send alerts via WhatsApp. The use of Pabbly Connect here is crucial as it allows for seamless data manipulation before sending notifications.

5. Sending WhatsApp Notifications Using Pabbly Connect

Finally, to send WhatsApp notifications when products go out of stock, you will need to set up the WhatsApp API through the WTI application in Pabbly Connect. Create a new action step and select WTI, then choose the action event as ‘Send Template Message’. Connect your WTI account by providing the API endpoint and access token.

Map your WhatsApp number and select the approved template for the alert message. The template should include placeholders for the product names that are out of stock. After mapping all necessary details, click on ‘Save and Send Test Request’ to confirm that the notifications are sent correctly.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automatically receive WhatsApp notifications when multiple products go out of stock. By integrating Google Sheets and WTI, you can effectively manage your inventory and stay updated in real-time. Implementing this setup can significantly enhance your business operations.