Integrating Google Sheets and AI Sensei Using Pabbly Connect: A Step-by-Step Guide

Learn how to automate WhatsApp notifications for Google Sheets updates using Pabbly Connect and AI Sensei. This guide covers all steps in detail. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin, access Pabbly Connect by visiting its official website. If you are a new user, you can sign up for free, which includes 100 free tasks every month. Existing users can simply log in to their accounts.

Once logged in, you’ll see all available applications. Click on the ‘Access Now’ button for Pabbly Connect to open the dashboard. Here, you can create workflows that will automate tasks between applications like Google Sheets and AI Sensei.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button located in the top right corner. A dialog box will prompt you to name your workflow and select a folder. Name it something descriptive, like ‘Send WhatsApp Message on Status Update in Google Sheets via AI Sensei.’

• Enter a descriptive workflow name.
• Select a folder to save your workflow, for example, ‘WhatsApp Automations.’

After naming and selecting a folder, click the ‘Create’ button. This will set up your workflow, which consists of a trigger and an action. The trigger detects changes in Google Sheets, while the action sends WhatsApp messages via AI Sensei.

3. Setting Up the Trigger in Google Sheets

For the trigger step, select Google Sheets as the application. The trigger event should be set to ‘New or Updated Spreadsheet Row.’ This means that whenever a stock status is updated in Google Sheets, Pabbly Connect will capture that change.

Once you select the trigger application and event, Pabbly Connect will provide a webhook URL. Copy this URL, as you will use it to connect Google Sheets with Pabbly Connect. Open your Google Sheets, go to the ‘Extensions’ menu, and search for the Pabbly Connect Webhook add-on to install it.

4. Connecting Google Sheets to Pabbly Connect

After installing the Pabbly Connect Webhook, go back to your Google Sheets. Under the ‘Extensions’ menu, find Pabbly Connect Webhook and click on ‘Initial Setup.’ Paste the webhook URL you copied earlier into the designated field. Set the trigger column, which is the column where data will be updated, typically the final column where stock status is recorded.

• Paste the webhook URL in the setup window.
• Specify the trigger column (e.g., Column F).
• Click on the ‘Submit’ button to save the setup.

After completing the setup, return to Pabbly Connect and check the workflow. It should indicate that it is waiting for a webhook response. Now, update a stock status in your Google Sheets to test if the connection works.

5. Setting Up the Action to Send WhatsApp Messages

Once the trigger is successfully set, the next step is to configure the action. For this, select ‘WhatsApp by AI Sensei’ as the application and choose the action event ‘Send Template Message.’ This allows you to send pre-defined messages to your staff when stock updates occur.

When prompted, connect your WhatsApp by AI Sensei account using your API key. This key is available in your AI Sensei account under the API key section. After connecting, specify the campaign name and the recipient’s mobile number where the WhatsApp message will be sent.

Enter the API key to connect WhatsApp by AI Sensei. Specify the campaign name and recipient’s mobile number. Map the variables from Google Sheets to the message template.

After setting up the action, click on ‘Save and Test Request’ to ensure everything is functioning correctly. If successful, you will receive a WhatsApp message with the inventory update details, confirming that the integration between Google Sheets and AI Sensei via Pabbly Connect is complete.

Conclusion

This tutorial illustrates how to automate WhatsApp notifications for updates in Google Sheets using Pabbly Connect and AI Sensei. With these steps, you can keep your team informed in real-time about inventory changes, enhancing efficiency in your operations.