​​In this tutorial, we’ll guide you through the process of sending WhatsApp messages directly from Google Sheets. This integration uses the WhatsApp API and can be completed in a few simple steps. Follow along to automate your messaging workflow!

How to Send WhatsApp Messages from Google Sheets

There are 2 ways to do this - Method 1 involves a tedious setup using google sheets and WhatsApp API links, while Method 2 is a completely automated one, via Heltar.

Method 1 - Google Sheets Setup via API Link

Step 1: Download WhatsApp

Visit WhatsApp’s download page and install the application compatible with your operating system. Alternatively, you can use WhatsApp Web in your browser.

  • Open WhatsApp on your mobile device.
  • Scan the QR code displayed on your desktop to connect your account.

Step 2: Create a Google Sheets Workbook

Prepare your Google Sheets workbook to organize your recipient details. Include the following columns:

  1. Name
  2. Phone Number
  3. Message

💡 Tip: For phone numbers, include the area code. Use this format to prevent errors: +(Area Code)(10 digit number)

Step 3: Create Dynamic Messages

To personalize your messages, you can use a formula that dynamically references other cells.

  • Example formula:
    • A2 refers to the column containing recipient names.
    • Adjust the formula to suit your message (= "Hey " &A2& ". We hope you are doing great. Checkout our brand new collection!")

Drag the formula down to apply it to all rows in your sheet.

Next, create clickable links to send messages using the WhatsApp API.

  • Use this formula in the Hyperlink column:  =hyperlink("https://api.whatsapp.com/send?phone=" &D2& "&text=" &E2,"Click to Send")
  • D2: Cell containing the phone number.
  • ​E2: Cell containing the dynamic message.
  • F2: Text displayed as the clickable link.

Drag this formula down to create hyperlinks for all rows.

Step 5: Send Messages

Click on the "Click to Send" hyperlink for the desired row. This will open the WhatsApp application or web interface.

  • Grant browser permissions to open WhatsApp.
  • Review the pre-filled message in the WhatsApp chat.
  • Press the Send button to dispatch the message. 


Method 2 - Using a WhatsApp Business API Provider i.e. Heltar

This method helps us overcome the limitations of the above mentioned method. Unlike the regular google sheets method, which is extremely tedious, Heltar allows your business to send bulk messages efficiently without a risk of getting banned. It enables seamless communication, whether for customer support, or for marketing campaigns. All you have to do is upload your google sheet on our platform!

Setting up and using the WhatsApp Business API for bulk messaging can significantly streamline your business communication, Here’s how you can do it:

Registration and Verification

 First, register with a WhatsApp Business Solution Provider (BSP) like Heltar- Best WhatsApp Business API. This step involves submitting your business details and verifying your Facebook Business Manager account.

Creating Message Templates

WhatsApp requires pre-approved message templates for bulk messaging to ensure compliance. These templates can include messages from across categories - marketing, utility, service, or authentication. They should be clear, non-spammy, and valuable to the recipient.

Launching Campaigns

After setting up the API and templates with Heltar, you can start sending bulk messages to your customers. The API enables you to automate message delivery, personalize content, and schedule campaigns for optimal engagement.

This way you also get access to an interface (Heltar's CRM) to tag, attribute, and keep a track of whatever is being sent from your business account, hence simplifying communication.

If you are interested in getting access to this method, explore more here.

At Heltar, we specialize in providing businesses with the tools and expertise to leverage WhatsApp Business API to its fullest. Here’s what sets us apart:

  • Affordable Solutions: Our pricing is transparent and competitive.

  • Enhanced Delivery Rates: We optimize message delivery for maximum impact.

  • Streamlined Workflows: Simplify customer communication with our intuitive tools.

  • Tailored Integration: Seamlessly integrate with platforms like CleverTap for advanced automation.

Try Heltar Today

Start with our free trial and experience the difference in service and support. Choose Heltar for a straightforward, feature-rich approach to WhatsApp Business communications and Bulk Messaging that won't strain your budget.

Get Started Now and Simplify Your Business Communications!