Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

Skip to main content
MarketingWhatsapp

Automate Whatsapp with Pabbly

by September 23, 2024#!30Tue, 19 Nov 2024 11:45:43 +0100+01:004330#30Tue, 19 Nov 2024 11:45:43 +0100+01:00-11Europe/Rome3030Europe/Rome202430 19am30am-30Tue, 19 Nov 2024 11:45:43 +0100+01:0011Europe/Rome3030Europe/Rome2024302024Tue, 19 Nov 2024 11:45:43 +010045114511amTuesday=4159#!30Tue, 19 Nov 2024 11:45:43 +0100+01:00Europe/Rome11#November 19th, 2024#!30Tue, 19 Nov 2024 11:45:43 +0100+01:004330#/30Tue, 19 Nov 2024 11:45:43 +0100+01:00-11Europe/Rome3030Europe/Rome202430#!30Tue, 19 Nov 2024 11:45:43 +0100+01:00Europe/Rome11#No Comments

 

Introduction

Automate your communication through Whatsapp using SendApp is Google Sheets is possible thanks to Pabbly, an automation tool that simplifies workflows between different applications. In this guide, we will show you how to integrate Sendapp with Google Sheets using Pabbly to automatically send WhatsApp messages whenever new data is added to the spreadsheet.

Step 1: What you need

Before you start, make sure you have:

  • An account Sendapp Cloud active.

 

 

  • An account Pabbly (you can sign up at Pabbly).

 

 

 

  • Access to Google Sheets With the Pabbly integration plugin installed.

 

Step 2: Install the Pabbly Integration in Google Sheet.

  • Open Google Sheets and go to Extensions > Add Additional Components.

 

 

  • Search for and install the add-on Pabbly Connect.

 

 

  • Copy the Webhook that Pabbly will provide, and select the Trigger column

Step 3: Create a Pabbly Account and Configure Workflow

  • Sign in or register for your account Pabbly on pabbly.com.

 

 

  • Click on Create Workflow To create a new workflow.

 

 

 

  • Give your workflow a name, e.g. "Sendapp to Google Sheets Automation".

Step 4: Configure the Trigger in Pabbly

  • In the Workflow you just created, select Google Sheets as Trigger App.

 

 

 

  • Choose the trigger "New Spreadsheet Row", which will be triggered when a new row is added to your Google sheet.

 

 

  • Pabbly will provide you with a Webhook URL. Copy this URL into the extension you downloaded in the Google sheet

 

Step 5: Add the Webhook to the Google Sheet

  • Back to top Google Sheets, go to Extensions > Pabbly Connect.
  • Paste the Webhook URL provided by Pabbly in the Google sheet configuration.
  • Save and close the configuration. Each new row entered in the sheet will send data to the Pabbly webhook.

Step 6: Perform the Submission Test

  • Add a new row in the Google sheet with the data to be sent via Sendapp (e.g., phone number, message, etc.).
  • Go to Pabbly and click on Webhook test to make sure the data is received correctly.

Step 7: Add Sendapp as an Action in the Workflow.

  • After configuring the trigger, click on Add Action and select Sendapp as the Action App.

 

 

  • Connect your Sendapp account by entering the Access Token and Instance ID, which pure from your Sendapp profile by scanning the QR Code With the WhatsApp app.

Step 8: Configure Sendapp Action Details.

  • In the Phone Number field, select the phone number from the Google sheet.
  • Set Message Type to Text.
  • Structure the custom message using the fields in the d sheetthe Google, such as name and other specific information.
  • Click on Save & Send Test Request To test sending the message.

 

Step 9: Activate Workflow

  1. If the test is successful, click Save and then Enable Workflow.
  2. From now on, every time you add a new row in the Go sheet.ogle, Sendapp will automatically send a WhatsApp message to the recipient.

 

Conclusion

Connect SendApp to Google Sheets via Pabbly allows you to automate your communication on WhatsApp without manual effort. This workflow is perfect for efficiently managing your contact list and sending personalized messages with ease. Follow these simple steps to get started and see how useful this automation can be in your business!

Leave a Reply