ENG
  • ENG
  • RUS

Integration Zapier with Google Sheets

Last update: 16.12.2022

1. After registering with Zapier, you need to go to the "My apps" tab and find "Google sheets" in the search box, click on the "Connect" button below

323f0e0004ef8ba5fb5209754f6fd6b4.png

2. In the window that opens, select the desired Google account

667a0b509da4c0b1b8a5e5cce99bb778.png

3. Return to "My apps", in the search bar find our application ChatArchitect.com, click "Connect"

1a0079d5eccf48a525f36e0064e5fdfd.png

4. In the window that opens write your APP ID and APP SECRET
 

7937c3d48296f53e2509f708cadb4716.png

5. We return to the main Zapier page, click +Create zap

f1c1cb8bc141486c46b6210a4159ea90.png

6. To configure the Trigger in the search we are looking for Google sheets,

787078dfb7b588bd0a905c1d155dc9b9.png

7. In the "Event" select New Spreadsheet Row, then you will need to select a Google account, after selecting an account, you will need to choose which table Zapier will take data from. 

63b3e0a15122eb70efa881b302f58a12.png
57495b859575b123f4954345aec62524.png

8. Next, select "Spreadsheet A/B" (most often, in Spreadsheet Row A it will be possible to pull up only the phone number. In Spreadsheet Row B, you can pull up the number and name

22d9a79def3548bccbfbbb36242acf1f.png

9. Next, in the action we select our application and select "Event", in our case it is Send a Text

2224de1a494c44f844da5995834cfd4c.png

10. Next, select our account in chatarchitect and go to the "Set up action" setting. In "Destination" we select data from your table, in the Text tab - write the text of your template, in isHSM - True. After that, conduct a test send and you can start the mailing list.

e7de517729508c8de75169ab6095ff42.png



11.We add numbers to the table after we have activated ZAP!!!

b1ad4182ea65a6b393bf7ce0c720cfdb.png

12. Add numbers to the table, ZAP will work on them within 15 minutes

8d560b3478f7794b16955aa61675f718.png



!!! Zapier works by adding a new column to the table, i.e. in order for it to send out mailings to the numbers you need, they must be added to the table only after activating Zap !!!

Was this article helpful?