Automate WhatsApp Alerts for Bookstore Inventory with Pabbly Connect

Learn how to automate WhatsApp alerts for new book arrivals in your bookstore using Pabbly Connect and Google Sheets. Step-by-step tutorial included. 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. Setting Up Pabbly Connect for Bookstore Alerts

To automate WhatsApp alerts for new book arrivals, first, you need to set up Pabbly Connect. Start by logging into your Pabbly Connect account. If you don’t have an account, you can create one easily and enjoy 100 free automation tasks each month.

Once logged in, navigate to your dashboard and click on the ‘Create Workflow’ button. Name your workflow something descriptive, like ‘Send New Book Arrival Alerts on WhatsApp’. This will help you identify the workflow later. Click on the ‘Create’ button to proceed.

2. Trigger Setup with Google Sheets

The next step involves setting up a trigger in Pabbly Connect that will initiate the automation when a new book is added. Click on the trigger section, and from the ‘Choose App’ field, select ‘Google Sheets’. This is where your inventory will be managed.

• Select ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.
• Go to your Google Sheets and install the Pabbly Connect Webhooks add-on from the Extensions menu.

After installing the add-on, refresh your Google Sheet. In the Pabbly Connect Webhooks settings, paste the copied webhook URL and specify the trigger column that will activate the workflow. This ensures that whenever you update your inventory, the alert will be sent automatically.

3. Fetching Customer Data from Google Sheets

Now that the trigger is set, it’s time to fetch customer details from your Google Sheets. In Pabbly Connect, click on the action tab and again choose ‘Google Sheets’. This time, you will use the ‘Get Rows’ action to retrieve customer data.

Connect your Google Sheets account and select the appropriate spreadsheet and sheet where customer details are stored. Define the data range that covers the customer information you want to send alerts to. This will allow Pabbly Connect to pull the necessary data for sending WhatsApp messages.

• Select the spreadsheet containing customer details.
• Specify the data range, for example, A2 to C8.
• Save and send a test request to ensure data is fetched correctly.

After fetching the customer data, you can now proceed to send alerts to each customer individually.

4. Sending WhatsApp Alerts Using Pabbly Connect

The final step is to send alerts to customers via WhatsApp. To do this, you will need to add another action step in Pabbly Connect. Choose ‘360 Dialog’ as the app to send messages through WhatsApp. This app provides access to WhatsApp’s API needed for messaging.

Select ‘Send Template Message’ as the action event. Connect your 360 Dialog account by providing the API key and domain name obtained from your 360 Dialog account. This connection is necessary to send messages through WhatsApp.

Map the recipient’s mobile number from the iterator step. Select your approved message template from 360 Dialog. Map the dynamic fields such as book title, price, and publisher details to the message template.

After mapping the required fields, click on ‘Save and Send Test Request’ to verify that the messages are sent correctly to the customers. This will complete the workflow setup.

5. Conclusion

In this tutorial, we explored how to automate WhatsApp alerts for new book arrivals using Pabbly Connect and Google Sheets. By setting up a trigger in Pabbly Connect, fetching customer data, and sending alerts through WhatsApp, you can enhance customer engagement and improve sales in your bookstore.

With this automation, you only need to update your inventory in Google Sheets, and the alerts will be sent to your customers automatically, saving you time and effort. Start using Pabbly Connect today to streamline your bookstore operations!