Skip to main content

Integration Integromat.com (Make.com) with Google Sheets

In this guide, you will learn how to install our WhatsApp Business API integration in Make and send messages using a database from Google Sheets.

1. After registering with Make, you need to install our app https://www.make.com/en/hq/app-invitation/80e6a64b2b12c4476413627b22551fb7 

ChatArchitect.com for WhatsApp app invitation page with Install button highlighted

Make app installation dialog with organization selected and Install button

 
2. Then go to the "Scenarios" tab and click on the "+Create a new scenario" button

Make Scenarios page with Create a new scenario button highlighted

2. Press on this "Plus" button

Make new scenario canvas with Add module button highlighted

3. Search "Google Sheets"

Make app picker with Google Sheets search result highlighted

4. Then choose "Google Sheets" and choose trigger "Watch Rows"

Make Google Sheets modules with Watch New Rows trigger highlighted

5. Add your Google Account

Make Google Sheets Watch New Rows module with Create a connection button

6. Choose "Connection"; "Drive"; "Spreadsheet ID" and "Sheet Name";
After that press "Save" button

Make Google Sheets Watch New Rows settings with spreadsheet fields and Save button

7. Then you need to press "Add module" and choose our integration ChatArchitect.com for WhatsApp and choose "Send a Text"

Make scenario canvas with Google Sheets module and Add module option

Make app picker with ChatArchitect WhatsApp Send a Text action highlighted

8. Select "Create a connection" -> add your APP ID and APP SECRET;
After that press "Save" button

Make ChatArchitect WhatsApp connection form with App Key and Secret fields

 9. Choose destination from your table;
In the text field you need to enter the text of the template that you want to send;
Highly Structured Message: Yes
and press "Save" button

Make WhatsApp Send a Text settings with Destination, Text and Highly Structured Message fields

10. Test your connection by using "Run once" button

Make scenario with Google Sheets and ChatArchitect modules and Run once button

11. If the message was successfully delivered to your test numbers, you can include "Scheduling" and add numbers to the table (It is important to add numbers for mailing after activating "Scheduling", because Make works to add rows to the table)

Make scenario with scheduling toggle set to Every 15 minutes


Google Sheets recipient table with phone number and contact name columns

To be noted: Make will work on new numbers within 15 minutes❗️