How to Add Kit Subscribers in Google Sheets & Send WhatsApp Messages using Pabbly Connect

Learn how to automate adding Kit subscribers in Google Sheets and sending WhatsApp messages using Pabbly Connect in this detailed tutorial. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To automate the process of adding Kit subscribers in Google Sheets and sending WhatsApp messages, you will need to access Pabbly Connect. Start by visiting the Pabbly Connect homepage by typing ‘Pabbly.com/connect’ in your browser. If you are a new user, click on ‘Sign Up for Free’ to create an account, which provides you with 100 free tasks monthly to explore the platform.

Once logged in, navigate to the dashboard where you can create new workflows. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Add Kit Subscribers in Google Sheets and Send WhatsApp Message’. This step sets the foundation for your automation process using Pabbly Connect.

Setting Up the Trigger with Kit

The first step in your workflow is to set up the trigger using Kit, the email marketing application. In Pabbly Connect, select Kit as your trigger application and choose the event ‘New Form Subscriber’. This ensures that the workflow activates whenever a new subscriber signs up through your Kit form.

Next, click on ‘Connect’ to establish the connection. You will need to add a new connection by entering your API key and secret from your Kit account. These can be found in the Account Settings under the Developer section. Once connected, select the specific form you want to use for capturing subscriber details.

• Select ‘New Form Subscriber’ as the trigger event.
• Connect your Kit account using the API key and secret.
• Choose the form that captures subscriber details.

After saving the trigger setup, test the connection by submitting a dummy form entry. If successful, Pabbly Connect will capture the subscriber’s details, allowing you to proceed with the next steps of your automation.

Adding Subscribers to Google Sheets

With the trigger set, the next step is to add the captured subscriber details to Google Sheets. Select Google Sheets as your action application in Pabbly Connect and choose the action event ‘Add New Row’. This action will record each new subscriber’s information in your designated spreadsheet.

Connect to Google Sheets by signing in with your Google account and granting Pabbly Connect the necessary permissions. Select the spreadsheet where you want to store subscriber data, and map the fields such as first name, last name, email, and mobile number from the previous trigger response.

• Choose ‘Add New Row’ as the action event.
• Map the fields from the Kit subscriber response to the corresponding columns in Google Sheets.
• Click ‘Save and Send Test Request’ to verify the setup.

Upon successful completion of this step, Pabbly Connect will ensure that each new subscriber is automatically recorded in your Google Sheets, creating a systematic record for your e-commerce business.

Sending WhatsApp Messages Using AiSensy

After successfully adding subscribers to Google Sheets, the final step is to send personalized WhatsApp messages to each subscriber using AiSensy. In Pabbly Connect, select WhatsApp by AiSensy as your action application and choose the action event ‘Send Template Message’.

To connect, you will need to enter your AiSensy API key, which can be found in your AiSensy account under the API Keys section. Once connected, you will need to specify the campaign name and the mobile number of the subscriber. Remember to include the country code when entering the mobile number.

Select ‘Send Template Message’ as the action event. Map the subscriber’s mobile number and first name into the message template. Click ‘Save and Send Test Request’ to confirm the message is sent.

Upon successful testing, Pabbly Connect will automatically send a WhatsApp message to each new subscriber, thanking them for joining and informing them about your business offers.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding Kit subscribers to Google Sheets and sending WhatsApp messages. This integration streamlines your communication and record-keeping, enhancing your e-commerce operations effectively.