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
- Access to SendApp and go to the section Profile.
- A QR Code which you will need to scan with your phone using the desired WhatsApp account.
- 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
- Sign in to your account Zapier.
- Click on "Make a Zap".
- In the search bar, search Google Sheets and select it as "Trigger App."
- 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
- Select the account Google To which you want to link Zapier.
- On the next screen, choose the spreadsheet and the CSV template you have prepared.
- Test the connection to make sure Zapier can access your data correctly.
Step 6: Add Sendapp as an Action App
- After configuring the Trigger, click on "Add Action" and look for SendApp.
- Select action "Send a WhatsApp message.".
- Enter theAccess Token and theAccess ID you previously obtained from your Sendapp account.
Step 7: Configure Sendapp Action.
- In the field telephone number, select the option corresponding to the "Phone Number" column of the CSV template.
- Choose Type: text To send a text message.
- Create a custom message using data from the Google sheet. You can use the names and messages preset in the columns of the sheet.
- 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!