Introduction
Automating processes is essential for saving time and increasing productivity. In this guide, we'll show you how to connect SendApp, our powerful software marketing on WhatsApp, to Google Sheets using ZapierThis will allow you to automatically send WhatsApp messages 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 will be displayed 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 sending messages via Google Sheets, you need to create a CSV templateThis template will contain the information that Sendapp will use to send WhatsApp messages. Make sure 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 whenever 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 It's a simple and powerful way to automate your marketing on WhatsAppThis allows you to send messages to your customers without any manual effort, improving efficiency and communication. Try creating your first one today. Zap and discover how this automation can simplify your workflow!