Skip to main content

Introduction

Automating processes is key to saving time and increasing productivity. In this guide we will show you how to connect SendApp, il nostro potente software di marketing su WhatsApp, a Google Sheets using Zapier. This will allow you to send WhatsApp messages automatically whenever you add new rows to your Google Sheet.

Step 1: Choose Sendapp's Plan

First of all, you will have to choose the plan of SendApp That's right for you. You can opt for a demo plan or for one for a fee. After activating the plan, you will need to link your WhatsApp account.

 

Step 2: Connect your WhatsApp Account

  1. Access to SendApp and go to the section Profile.
  2. A QR Code which you will need to scan with your phone using the desired WhatsApp account.
  3. Once the scan is complete, the screen will show theAccess Token and theAccess ID. This data will be needed to link your Sendapp account to Zapier.

 

Step 3: Create the CSV Template for Google Sheets

To automate the sending of messages via Google Sheets, it is necessary to create a CSV template. This template will contain the information that will be used by Sendapp to send WhatsApp messages. Make sure that the CSV file includes columns such as:

  • Telephone number
  • Recipient's name
  • Personalized message

Step 4: Create a New Zap in Zapier

  1. Sign in to your account Zapier.
  2. Click on "Make a Zap".
  3. In the search bar, search Google Sheets and select it as "Trigger App."
  4. Choose the trigger "New Spreadsheet Row", which will be activated every time you add a new row to the sheet.

Step 5: Configure the Google Sheet

  1. Select the account Google To which you want to link Zapier.
  2. On the next screen, choose the spreadsheet and the CSV template you have prepared.
  3. Test the connection to make sure Zapier can access your data correctly.

Step 6: Add Sendapp as an Action App

  1. After configuring the Trigger, click on "Add Action" and look for SendApp.
  2. Select action "Send a WhatsApp message.".
  3. Enter theAccess Token and theAccess ID you previously obtained from your Sendapp account.

Step 7: Configure Sendapp Action.

  1. In the field telephone number, select the option corresponding to the "Phone Number" column of the CSV template.
  2. Choose Type: text To send a text message.
  3. Create a custom message using data from the Google sheet. You can use the names and messages preset in the columns of the sheet.
  4. Click on Continued.

 

Step 8: Conduct the Test

Before activating Zap, run a test to make sure the WhatsApp message is sent correctly via Sendapp. Add a new row in the Google sheet and observe if the message is sent with the right data.

Step 9: Activate your Zap

If everything works as expected, click on "Turn on Zap". Now, whenever you add a new row to your Google Sheet, Sendapp will automatically send a personalized WhatsApp message to the recipient.

 

Conclusion

Connect SendApp to Google Sheets via Zapier è un modo semplice e potente per automatizzare il tuo marketing su WhatsApp. Questo ti permette di inviare messaggi ai tuoi clienti senza alcuno sforzo manuale, migliorando l’efficienza e la comunicazione. Prova oggi stesso a creare il tuo primo Zap and find out how this automation can simplify your workflow!