How to Pass Contacts from Google Sheets to SendPulse Mailing Lists and Send Messages via a Chatbot

The Integromat service has changed its website address, design and name to Make. The integration options remain the same, but the design may differ from the screenshots shown in the article.

You can integrate SendPulse chatbots with other services to request information via Make. In this article, we will explain how to pass contacts from Google Sheets and send messages to subscribers in messengers via chatbot.

With the help of such a scenario, you can check the personal information of a client or give it out to a user. You can identify a user (for whom the data is written in one row and one of the columns is identified) using any data in your chatbot and Google Sheets — subscriber ID, contact information, and more.

This article covers integration with Google Sheets using Make. Still, you can also get data from Google Sheets directly with only the Google Sheets API and SendPulse tools. Read more: "How to Transfer Data from Google Sheets to Chatbots."

How to Get Started

Log into your Make account, and click the + Create a new scenario button to start creating a scenario.

You can choose which services to connect — in this case, we want SendPulse and Google Sheets — using the search or find and add them directly in the constructor. Click the Continue button in the upper right corner.

How to Get Information from Google Sheets

Click on the block with the question mark in the center of the screen and select the "Google Sheets" block — this block starts the flow.

Select the "Watch Rows" action.

Connect your Google Account, select the spreadsheet, sheet, and columns that you want to pass.

How to Pass a Record from Google Sheets to Your SendPulse Mailing List

Click on "Add another module" next to the "Google Sheets" block. Choose "SendPulse."

Select the "Create / Update a Contact" action.

Click the Add button, connect your SendPulse account using your username and password.

Select the mailing list you want to pass contacts to.

Select an email address and phone number from the cells in the previous block of tables that will be added to the mailing list.

Additionally, you can add custom variables.

You need to create custom variables in the mailing list to appear in the block.

Click the OK button.

You can also set up filters to only pass contacts that have certain variables. To add a filter, click on the line between the "Google Sheets" and "SendPulse" blocks and set a condition.

You can also add additional blocks and send other API requests using the "SendPulse" block, customizing the scenario to suit your needs.

How to Set up an Automation 360 Flow

Go to the "Automations" section and click "Create new automation." Select the "Add subscriber" trigger. Then, select the mailing list to which contacts from Make will be added.

You can add additional filters to send a message, depending on whether the contact has a value in general or a specific value for a variable.

Add the "Messenger" block. Choose the time you want to complete the action, the bot, and the action: send a message or start a flow.

Please note that the recipient must be subscribed to the chatbot from which you will send them the message and have an email or phone number in the "Audience" of your chatbot.

Click the Apply button and the Save and launch button.

Save and Run

Before saving and exiting, ensure that everything works correctly.

Click the Run once button and a contact to connect the Google spreadsheet. If you have configured everything correctly, green check marks will appear under the Google Sheets and SendPulse blocks.

You can also click on the number above the block to view the received information transmitted to the next block.

To activate the scenario, move the toggle switch to the "ON" position.

How to View the Scenario History

Navigate to the scenario you need. You will have access to a diagram of all blocks with their execution history.

Click on the required block to view information about it. You will have access to all the information on the block: what values ​​it received and transmitted, further.

If any of the blocks have not been executed, they will be highlighted in red, and when pressed, the reason for the error and a hint on how to fix it will be displayed. Note that the entire scenario may pause and not execute until the error is resolved; operations will be queued.

If you have any questions about configuration or scenario failures, you can contact Make support.

Last Updated: 15.03.2023