Skip to main content

 

Introduction

Automate your communication through Whatsapp using SendApp is Google Sheets is possible thanks to Pabbly, uno strumento di automazione che semplifica i flussi di lavoro tra diverse applicazioni. In questa guida, ti mostreremo come integrare Sendapp con Google Sheets usando Pabbly per inviare automaticamente messaggi Whatsapp ogni volta che vengono aggiunti nuovi dati nel foglio di calcolo.

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 With the Pabbly integration plugin installed.

 

Step 2: Install the Pabbly Integration in Google Sheet.

  • Open Google Sheets and go to Extensions > Add Additional Components.

 

 

  • Search for and install the add-on Pabbly Connect.

 

 

  • Copy the Webhook that Pabbly will provide, and select the Trigger column

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", which will be triggered when a new row is added to your Google sheet.

 

 

  • Pabbly will provide you with a 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.
  • Save and close the configuration. Each new row entered in the sheet will send data to the Pabbly webhook.

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: Configure Sendapp Action Details.

  • 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

  1. If the test is successful, click Save and then Enable Workflow.
  2. From now on, every time you add a new row in the Go sheet.ogle, Sendapp will automatically send a WhatsApp message to the recipient.

 

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!