Watch Step By Step Video Tutorial Below





1. Setting Up Pabbly Connect for WhatsApp Integration

To automate WhatsApp video messages, you first need to set up Pabbly Connect. This platform allows you to create workflows that connect Google Sheets with WhatsApp. Start by logging into your Pabbly Connect account and clicking on the ‘Create Workflow’ button.

Choose the quick builder option to streamline the process. Enter the prompt “connect Google Sheet to Pabbly Connect Flow” to initiate the automation setup. Pabbly Connect will analyze your request and ask you to select a trigger, which in this case is “New or Updated Spreadsheet Row” from Google Sheets.

2. Configuring Google Sheets for Automation

Next, you need to prepare your Google Sheets to work with Pabbly Connect. This involves adding customer data such as names, WhatsApp numbers, and video URLs. Ensure that your sheet has a designated trigger column where new entries will be added.

  • Open Google Sheets and create a new spreadsheet.
  • Add columns for customer name, WhatsApp number, product interest, and video URL.
  • Ensure the trigger column is set to the last column of your data.

Once your sheet is set up, return to Pabbly Connect to connect it via webhooks. Copy the provided webhook URL and install the Pabbly Connect Webhooks add-on in Google Sheets. This will allow you to link your Google Sheets with Pabbly Connect.

3. Configuring Webhooks in Google Sheets

After installing the Pabbly Connect Webhooks add-on, you need to configure it to communicate with Pabbly Connect. Click on the add-on, select “Initial Setup,” and paste the webhook URL you copied earlier.

Set the trigger column to the designated column (e.g., column F) in your Google Sheets. Click on the “Send Test” button to verify the connection. If set up correctly, you should see a confirmation message indicating the test data was sent successfully to Pabbly Connect.

Ensure that the “Send on Event” option is active; this is crucial for the webhook to function properly. Once confirmed, click on the “Submit” button to finalize your webhook setup.

4. Integrating WhatsApp with Pabbly Connect

Now that your Google Sheets is linked to Pabbly Connect, the next step is to set up WhatsApp integration. For this, you can use either Pabbly Chatbot or WhatsApp Cloud API. Select Pabbly Chatbot as your action application.

To create a connection, click on the “Connect” button and enter your API token from the Pabbly Chatbot dashboard. This token allows Pabbly Connect to send messages on WhatsApp on your behalf.

  • Navigate to the settings option in your Pabbly Chatbot dashboard.
  • Copy your API token from the API and Webhook section.
  • Paste the token into Pabbly Connect to establish the connection.

After connecting, you will map the WhatsApp number and video URL from your Google Sheets data to ensure personalized messages are sent to each customer. This mapping is essential for the automation to work correctly.

5. Testing the WhatsApp Automation

With everything set up, it’s time to test the automation. Click on the “Save and Send Request” button in Pabbly Connect after mapping the necessary fields. This action will trigger the WhatsApp message.

Check your WhatsApp account to confirm receipt of the video message. The message should include personalized content based on the data from your Google Sheets. If successful, this means the integration is working as intended.

Lastly, ensure that the toggle for your workflow is enabled in Pabbly Connect. If this toggle is off, your workflow will not function in the future. This automation can be reused for multiple customers without additional setup.

Conclusion

This tutorial demonstrates how to use Pabbly Connect to automate sending WhatsApp video messages through Google Sheets. By following these steps, you ensure seamless communication with your customers, enhancing your business efficiency.