Learn how to efficiently send over 100 promotional messages on WhatsApp using Pabbly Connect and AI Sensei. Step-by-step tutorial included. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below


1. Setting Up Pabbly Connect to Integrate Google Sheets with AI Sensei

To send over 100 promotional messages on WhatsApp, we need to use Pabbly Connect to integrate Google Sheets with AI Sensei. First, open your browser and navigate to Pabbly Connect’s homepage. If you don’t have an account, click on the ‘Sign Up for Free’ button to create one. This process only takes a couple of minutes and gives you 100 free tasks every month.

Once you have logged in, you will see a dashboard with various apps. Click on the ‘Access Now’ button under Pabbly Connect. This will take you to the workflow creation area where you can begin setting up your integration.


2. Creating a New Workflow in Pabbly Connect

In this section, you will create a new workflow in Pabbly Connect to automate sending messages. Click on the ‘Create Workflow’ button, and a pop-up window will appear. Name your workflow something descriptive, like ‘Send 100+ Promotional Messages on WhatsApp using AI Sensei,’ and click on ‘Create’.

Now you will see two sections: Trigger and Action. The trigger is the event that starts the workflow, and the action is what happens as a result. For this setup, you need to select Google Sheets as your trigger application. Set the trigger event to ‘New or Updated Spreadsheet Row’ to ensure that any new contact added will initiate the process.

  • Select Google Sheets as your trigger application.
  • Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
  • Click on ‘Connect’ to link Google Sheets with Pabbly Connect.

After setting the trigger, you will need to copy the webhook URL provided. This URL acts as a bridge between Google Sheets and Pabbly Connect. Paste this URL in your Google Sheets extension settings to establish the connection.


3. Connecting Google Sheets to Pabbly Connect

Next, you need to connect your Google Sheets to Pabbly Connect. Open your Google Sheets and navigate to the Extensions menu. If you have the Pabbly Connect add-on installed, select it. If not, go to ‘Add-ons’ and click on ‘Get Add-ons’ to find and install the Pabbly Connect add-on.

Once installed, refresh your Google Sheet. Go back to Extensions, select Pabbly Connect, and then click on ‘Initial Setup’. Here, paste the webhook URL you copied earlier. You will also need to specify the trigger column, which is typically the last column where data will be entered.

  • Paste the webhook URL in the Initial Setup of Pabbly Connect.
  • Specify the trigger column for data entry.
  • Click ‘Send Test’ to ensure the connection is working properly.

After completing the initial setup, your Google Sheet will be linked with Pabbly Connect, and you can start sending promotional messages as new contacts are added.


4. Setting Up AI Sensei for WhatsApp Messaging

Now that you have connected Google Sheets with Pabbly Connect, the next step is to set up AI Sensei for sending WhatsApp messages. In your Pabbly Connect workflow, select AI Sensei as the action application. Choose the action event as ‘Send Template Message’ to send customized messages to your contacts.

To connect AI Sensei with Pabbly Connect, you will need to enter your API key. Log in to your AI Sensei account, navigate to the ‘Manage’ section, and generate a new API key if you don’t have one. Copy this key and paste it into the API key field in Pabbly Connect.

Select AI Sensei as the action application. Choose ‘Send Template Message’ as the action event. Enter your API key from AI Sensei.

After configuring the action settings, you can now map the contact details received from Google Sheets to the message template. This includes the contact’s name, phone number, and any images you want to send. Make sure the image URLs are publicly accessible for successful delivery.


5. Sending Promotional Messages to Contacts

With everything set up, you can now send promotional messages to your contacts using Pabbly Connect and AI Sensei. To do this, make sure your campaign is live in AI Sensei and that your workflow in Pabbly Connect is active. You can now add new contact details to your Google Sheet.

Each time you add a new contact, the information will be sent to AI Sensei via Pabbly Connect, and a promotional message will be sent out automatically. You can also send all existing contacts a message by selecting the ‘Send All Data’ option in the Pabbly Connect extension menu in Google Sheets.

Ensure your campaign is live in AI Sensei. Add new contacts to your Google Sheet to trigger messages. Use the ‘Send All Data’ option to message existing contacts.

This automation allows you to efficiently manage your marketing campaigns and reach a larger audience without manual effort, leveraging the power of Pabbly Connect and AI Sensei.


Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to seamlessly integrate Google Sheets with AI Sensei for sending over 100 promotional messages on WhatsApp. By following these steps, you can automate your marketing efforts, ensuring timely communication with your audience.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.