Introduction
Automate your communication through Whatsapp using SendApp is Google Sheets è possibile grazie a Pabbly, an automation tool that simplifies workflows between different applications. In this guide, we will show you how to integrate Sendapp with Google Sheets using Pabbly to automatically send WhatsApp messages whenever new data is added to the spreadsheet.
Step 1: What you need
Before you start, make sure you have:
- An account Sendapp Cloud active.
- An account Pabbly (you can sign up at Pabbly).
- Access to Google Sheets con il plugin per l’integrazione Pabbly installato.
Step 2: Installare l’Integrazione Pabbly nel Foglio di Google
- Open Google Sheets and go to Extensions > Add Additional Components.
- Search for and install the add-on Pabbly Connect.
- Copia il Webhook che fornirà Pabbly, e seleziona la colonna Trigger
Step 3: Create a Pabbly Account and Configure Workflow
- Sign in or register for your account Pabbly on pabbly.com.
- Click on Create Workflow To create a new workflow.
- Give your workflow a name, e.g. "Sendapp to Google Sheets Automation".
Step 4: Configure the Trigger in Pabbly
- In the Workflow you just created, select Google Sheets as Trigger App.
- Choose the trigger "New Spreadsheet Row", che si attiverà quando viene aggiunta una nuova riga al tuo foglio di Google.
- Pabbly ti fornirà un Webhook URL. Copy this URL into the extension you downloaded in the Google sheet
Step 5: Add the Webhook to the Google Sheet
- Back to top Google Sheets, go to Extensions > Pabbly Connect.
- Paste the Webhook URL provided by Pabbly in the Google sheet configuration.
- Salva e chiudi la configurazione. Ogni nuova riga inserita nel foglio invierà i dati al webhook di Pabbly.
Step 6: Perform the Submission Test
- Add a new row in the Google sheet with the data to be sent via Sendapp (e.g., phone number, message, etc.).
- Go to Pabbly and click on Webhook test to make sure the data is received correctly.
Step 7: Add Sendapp as an Action in the Workflow.
- After configuring the trigger, click on Add Action and select Sendapp as the Action App.
- Connect your Sendapp account by entering the Access Token and Instance ID, which pure from your Sendapp profile by scanning the QR Code With the WhatsApp app.
Step 8: Configurare i Dettagli dell’Azione Sendapp
- In the Phone Number field, select the phone number from the Google sheet.
- Set Message Type to Text.
- Structure the custom message using the fields in the d sheetthe Google, such as name and other specific information.
- Click on Save & Send Test Request To test sending the message.
Step 9: Activate Workflow
- If the test is successful, click Save and then Enable Workflow.
- From now on, every time you add a new row in the Go sheet.ogle, Sendapp invierà automaticamente un messaggio WhatsApp al destinatario.
Conclusion
Connect SendApp to Google Sheets via Pabbly ti permette di automatizzare la tua comunicazione su WhatsApp senza sforzi manuali. Questo flusso di lavoro è perfetto per gestire in modo efficiente la tua lista di contatti e inviare messaggi personalizzati con facilità. Segui questi semplici passaggi per iniziare e scopri quanto può essere utile questa automazione nel tuo business!