Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start automating back in stock alerts, you first need to access Pabbly Connect. Simply type ‘pabyt.com/connect’ in your browser. This platform is essential for connecting various applications without any coding experience.

After reaching the landing page, you’ll see options to sign in or sign up. If you’re a new user, click on ‘Sign up for free’ to create an account, which provides you with 100 free tasks monthly. Existing users can click on ‘Sign in’ to log into their accounts.

2. Creating a New Workflow in Pabbly Connect

Once logged in, navigate to the dashboard of Pabbly Connect. Here, you can create a new workflow by clicking on the ‘Create Workflow’ option. You can choose to create from scratch or use the AI workflow builder for ease.

  • Select ‘Create from Scratch’ for a manual setup.
  • Alternatively, use AI to generate the workflow based on simple prompts.

For this tutorial, we’ll use the AI workflow builder. Enter a prompt like “connect Google Sheets with Chatflow for sending WhatsApp messages automatically”. This sets the foundation for your automation.

3. Setting Up Google Sheets Integration

After creating the workflow, specify the trigger event in Google Sheets. Choose the option for a new or updated row in the spreadsheet to initiate the workflow. This ensures that whenever a product’s stock status changes, a notification is sent.

Next, select the action in Pabbly Chatflow to send a template message. This predefined message will inform customers about the product’s availability. Click ‘Create’ to finalize the workflow setup.

  • Copy the webhook URL provided by Pabbly Connect.
  • In Google Sheets, go to Extensions > Get Add-ons, and install Pabbly Connect Webhooks.

After installing, paste the copied webhook URL in the initial setup of the add-on. Set the trigger column for status updates, which will send data to Pabbly Connect whenever a change occurs.

4. Filtering Conditions for Notifications

To ensure that notifications are only sent when products are back in stock, you need to apply a filter condition in Pabbly Connect. This step is crucial for preventing unnecessary alerts for out-of-stock items.

Click on the plus sign to add a filter step. Set the label to the product status and specify that the condition should be “equal to” in stock. This way, the workflow will only proceed if the product is available.

After setting the filter, you can proceed to send WhatsApp messages via Pabbly Chatflow. This integration ensures that your messages are sent securely without the risk of being blocked, making it ideal for bulk notifications.

5. Sending WhatsApp Messages to Customers

With the workflow set up and filters applied, the final step is to send WhatsApp messages to customers. In Pabbly Chatflow, select the action to send a template message. You will need an API token from your Pabbly Chatflow account to establish this connection.

Map the customer’s WhatsApp number from the previous response to ensure the message is sent to the correct recipient. Select the template that you created for stock alerts, ensuring it includes personalized details like the customer’s name and product information.

After saving the settings, click on ‘Send Test Request’ to verify that the message is sent correctly. Once confirmed, your automation is complete, and customers will receive timely updates whenever products are back in stock.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate back in stock alerts via WhatsApp effectively. By integrating Google Sheets and Pabbly Chatflow, you can ensure your customers are promptly notified, enhancing your sales potential.