Learn how to send WhatsApp messages without saving numbers using Pabbly Connect. This detailed tutorial walks you through the integration process step-by-step. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below


1. Access Pabbly Connect to Start Automation

To send WhatsApp messages without saving numbers, you first need to access Pabbly Connect. Open a new tab in your browser and navigate to Pabbly.com/connect. If you are a new user, click on ‘Sign up for free’ to get started with 100 tasks free every month. Existing users can simply click on ‘Sign in’ to access their dashboard.

Once signed in, you will see all Pabbly applications. Click on Pabbly Connect and then select ‘Access Now’. From here, click on ‘Create Workflow’ to begin setting up your automation. Enter a name for your workflow, select a folder, and click on ‘Create’. This will bring you to the workflow builder, where you can set up triggers and actions for your WhatsApp messaging automation.


2. Set Up Google Sheets as Trigger in Pabbly Connect

In this step, you will set up Google Sheets as the trigger application in Pabbly Connect. Click on the ‘Add Trigger’ button and search for ‘Google Sheets’. Select it, then choose the event ‘New or Updated Spreadsheet Row’ and click on ‘Connect’. A webhook URL will be generated, which you need to copy and paste into your Google Sheets.

  • Open Google Sheets and navigate to Extensions > Add-ons > Get Add-ons.
  • Search for ‘Pabbly Connect Webhooks’ and install it.
  • Refresh your Google Sheets to see the Pabbly Connect option.
  • Go to Pabbly Connect Webhooks > Initial Setup and paste the webhook URL.

After pasting the webhook URL, specify the trigger column (e.g., column D) where your lead details are stored. Click on ‘Submit’ to complete the setup. Once configured, you will see a message indicating that the setup is successful, and it will be waiting for a webhook response.


3. Test the Connection in Pabbly Connect

Now that you have set up Google Sheets as the trigger, it’s time to test the connection using Pabbly Connect. Click on the ‘Send Test’ button in your Google Sheets to send a test response to Pabbly Connect. You should see a success message confirming that test data has been sent successfully.

Return to your Pabbly Connect workflow, and you will see that the response has been captured. This response will include details such as the lead’s first name, last name, phone number, and email address, confirming that the integration between Google Sheets and Pabbly Connect is working correctly.


4. Send WhatsApp Messages Using Pabbly Connect

Next, you will set up the action to send WhatsApp messages through Pabbly Connect. Click on ‘Add New Action Step’ and search for ‘WhatsApp Cloud API’. Select it and choose the event ‘Send Template Message’. Click on ‘Connect’ and enter your WhatsApp Cloud API credentials, including the token, phone number ID, and WhatsApp Business Account ID.

  • You can find these details in the WhatsApp Cloud API documentation.
  • Map the phone number from the previous step to send messages dynamically.
  • Select the template ID you created for your WhatsApp messages.

After entering all required information, click on ‘Save and Send Test Request’. You should receive a confirmation that the automated WhatsApp message has been sent successfully. Now, you can open your WhatsApp to see the message received.


5. Send All Data to WhatsApp Using Pabbly Connect

To send messages to all leads at once, you can use the ‘Send All Data’ feature in Pabbly Connect. Go back to your Google Sheets, click on Extensions > Pabbly Connect Webhooks, and select ‘Send All Data’. This action will trigger the workflow in Pabbly Connect and send automated WhatsApp messages to all leads listed in your sheet.

Once you click on ‘Send All Data’, Pabbly Connect will process the leads and send messages to each contact without needing to save their numbers. This feature is perfect for sending festive wishes or promotional messages to multiple contacts simultaneously. Ensure that the ‘Send on Event’ option is enabled in your Pabbly Connect settings to automatically send messages for future entries in your Google Sheets.


Conclusion

In conclusion, using Pabbly Connect, you can effortlessly send WhatsApp messages without saving numbers. By integrating Google Sheets with WhatsApp Cloud API, you can automate your messaging process and reach out to your leads instantly. Try this powerful automation for your business today!

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