Automatically Get WhatsApp Notifications for Out of Stock Products Using Pabbly Connect

Learn how to set up automated WhatsApp notifications for out-of-stock products using Pabbly Connect, Google Sheets, and Wati. Follow this detailed tutorial for seamless integration.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To set up automatic WhatsApp notifications for out-of-stock products, we will use Pabbly Connect as our integration platform. Start by visiting the Pabbly website, where you can either sign up for a free account or log in if you already have one.

Once logged in, navigate to the dashboard and locate the option to access Pabbly Connect. Click on the ‘Access Now’ button to enter the workflow section where you can create a new workflow.

2. Creating a Workflow in Pabbly Connect

In this step, we will create a workflow that alerts us when multiple products go out of stock. Click on the ‘Create Workflow’ button and name your workflow accordingly, for example, ‘Alert When Multiple Products Go Out of Stock’. Select the folder where you want to save this workflow. using Pabbly Connect

Now you will see two main sections: Trigger and Action. The Trigger is what starts the workflow, and the Action is what happens as a result. For our trigger, we will use the ‘Schedule by Pabbly’ feature to run this workflow daily at a specified time.

• Select ‘Schedule by Pabbly’ as the trigger application.
• Set the frequency to ‘Every Day’.
• Choose the time you want the workflow to run, e.g., 11:00 AM.

After setting this up, click on ‘Save’ to finalize the trigger settings.

3. Connecting Google Sheets to Pabbly Connect

Next, we will connect our Google Sheets to Pabbly Connect to fetch stock details. Add a new action step and select ‘Google Sheets’ as the action application. For the action event, choose ‘Lookup Spreadsheet Row V2’ to find out-of-stock items.

To establish the connection, click on ‘Add New Connection’ and sign in to your Google account. Grant the necessary permissions to allow Pabbly Connect to access your Google Sheets. After successfully connecting, select the specific spreadsheet that contains your product stock details.

• Choose the spreadsheet named ‘Stock Details’.
• Set the lookup value to ‘Out’ to find products that are out of stock.
• Specify the lookup column as Column D, which contains stock values.

Toggle the response to advanced format and click on ‘Save and Send Test Request’ to ensure everything is working correctly.

4. Formatting Data and Sending WhatsApp Notifications

After retrieving the out-of-stock product details, we will format this data for our WhatsApp notification. Add another action step and select ‘Data Transformer’ from Pabbly Connect. Choose ‘Line Itemizer’ as the action event to convert the product data into a readable format.

Map the line item array from the previous Google Sheets response and click on ‘Save and Send Test Request’. This will prepare the data for the WhatsApp message. Next, we will use the ‘Text Formatter’ feature to clean up the data and remove any unnecessary brackets or commas.

Select the output from the Data Transformer as input for the Text Formatter. Specify the characters to replace, such as brackets and commas. Map the cleaned-up product names for the WhatsApp message.

Once formatted, set up the final action using Wati to send the WhatsApp notification. Select ‘Wati’ as the action application and choose ‘Send Template Message’ as the action event. Connect your Wati account by providing the API endpoint and access token.

5. Finalizing the Workflow and Testing

In this final step, we will finalize our workflow in Pabbly Connect. Set up a router to handle notifications for both multiple products and single products. Create two routes: one for multiple products and another for single product notifications.

For the multiple products route, set a filter to check if the product names contain multiple entries. For the single product route, set a condition to check if there’s only one product out of stock. Each route will send a WhatsApp message using the previously created Wati action.

Map your WhatsApp number and select the appropriate template for the message. Test each route to ensure notifications are sent correctly. Click on ‘Save’ to finalize the workflow.

Now, your workflow is set up to automatically notify you via WhatsApp whenever products go out of stock, helping you manage your inventory effectively.

Conclusion

By following this tutorial, you can successfully set up automatic WhatsApp notifications for out-of-stock products using Pabbly Connect. This integration not only saves time but also ensures you stay informed about your inventory status. Automate your stock management today!