Skip to main content
  1. Introduction

Automate the processes of sending WhatsApp messages via SendApp is Google Sheets using Make (formerly Integromat) allows you to efficiently manage your communication. In this guide we will show you how to create an integration between SendApp is Google Sheets to 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 Make: 

 

 

  • Access to Google Sheets it's a CSV template ready with the information you wish to use (such as phone numbers and messages).

 

 

Step 2: Create a New Scenario in Make

  • Sign in to your account Make and click on Create a new scenario.

 

  • Click on the symbol “+” To add the first module.

 

 

  • Search and select Google Sheets.

 

  • In the configuration, choose Drive: myDrive.

  • In the field Spreadsheet ID, select the CSV template You prepared in advance.

  • Select the sheet name (Sheet Name) that contains the data to be used.

 

  • Go ahead to configure the next modules.

Step 3: Add Sendapp as Second Module

  • Click on the symbol “+” To add the second module.

 

  • Search and select SendApp As an app to be linked.

 

  • Click on Add To link your Sendapp account.
  • Enter theAccess Token and theInstance ID, which you can obtain from your Sendapp profile by scanning the QR Code With the WhatsApp app.

Step 4: Configure Sendapp Fields

  • Once Sendapp is connected, in the Phone Number, select the phone number from the column in the CSV template that contains the phone numbers.
  • In the field Message Type, select Text.
  • In the field Message, create a custom message using the data in the Google sheet. For example, you can enter the names of the recipients and other specific information taken from the sheet.

Step 5: Conduct the Test

  1. After everything is configured, click on OK To save the scenario.
  2. Run a test to verify that everything is working correctly. Add a new row in the Google sheet and verify that the message is being sent correctly through Sendapp.

 

Step 6: Publish the Scenario

  • Once the test is successful, click on Publish To activate the scenario.
  • From now on, whenever you add a new row to your Google sheet, Sendapp will automatically send a personalized WhatsApp message to the corresponding phone number.

 

Conclusion

Connect SendApp to Google Sheets via Make is a simple and powerful process that allows you to automate communication via WhatsApp. This allows you to send personalized messages effortlessly, improving efficiency and saving time. Try this integration today and see how it can simplify your daily work.