How to Get Real-Time Stock Alerts on WhatsApp from Google Sheets Using Pabbly Connect

Learn how to receive real-time stock alerts on WhatsApp through Google Sheets using Pabbly Connect. Follow our step-by-step guide for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Google Sheets for Stock Prices

To get real-time stock alerts on WhatsApp, you first need to set up Google Sheets. Using the Pabbly Connect integration, you can automate fetching stock prices from the National Stock Exchange.

Open Google Sheets and enter the following formula to fetch stock prices:

• Type `=GOOGLEFINANCE(‘TATAMOTORS’, ‘price’)` to get the current price of Tata Motors.

Once you have this setup, you can easily update the stock symbols to fetch prices for other companies. Ensure the sheet is ready for integration with Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

Now, let’s create a workflow in Pabbly Connect to automate the process. Start by logging into your Pabbly Connect account and clicking on the ‘Create Workflow’ button.

Provide a name for your workflow, such as ‘Get Real-Time Stock Price Alerts on WhatsApp’. Next, choose a trigger. In this case, select the ‘Schedule’ feature from Pabbly Connect, allowing you to run the workflow daily.

• Select the time for the alert, e.g., 10:00 AM.
• Click on ‘Save’ to schedule your workflow.

This setup ensures that your stock prices are fetched daily at the specified time using Pabbly Connect.

3. Fetching Data from Google Sheets

After setting the schedule, the next step involves fetching the stock data from Google Sheets using Pabbly Connect. Choose Google Sheets as the action application.

Select the action event as ‘Get Row’ and connect your Google Sheets account. After connecting, specify the spreadsheet name where your stock prices are stored.

Enter the range of data you want to fetch, e.g., A2:B5. Click on ‘Save and Send Test Request’ to confirm the connection.

This process enables Pabbly Connect to access your stock prices directly from Google Sheets, ready for the next step.

4. Sending Alerts to WhatsApp

Next, set up WhatsApp to receive the stock alerts. In Pabbly Connect, choose Interact as the action application and select ‘Send WhatsApp Template Message’ as the action event.

Connect your Interact account by providing the secret key. After connecting, fill in the required fields, including your phone number and a predefined message template.

Use a template name like ‘Leads Update’ to get approval from WhatsApp. Map the variables to include stock names and prices in your message.

This setup allows Pabbly Connect to send automated WhatsApp messages with real-time stock updates.

5. Testing and Optimizing the Workflow

Finally, after setting up everything, it’s crucial to test your workflow. Click on ‘Save and Send Test Request’ to verify that your WhatsApp receives the stock alerts correctly.

Make sure to replace any dummy phone numbers with your actual WhatsApp number. This step ensures that you will receive real-time stock alerts directly on your device.

Monitor the alerts to ensure they are sent at the scheduled time. Adjust the template or variables as needed for clarity and effectiveness.

With this final check, your integration using Pabbly Connect is complete, and you can enjoy automated stock alerts on WhatsApp.

Conclusion

Using Pabbly Connect, you can seamlessly integrate Google Sheets with WhatsApp for real-time stock alerts. This automation allows for efficient monitoring of stock prices without manual intervention, ensuring you stay updated effortlessly.