How to Send Bulk Christmas Wishes via SMS (Fast & Easy!)

Learn how to send bulk Christmas wishes via SMS using Pabbly Connect. This step-by-step tutorial guides you through the integration with Google Sheets and Twilio.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Sending Bulk SMS Wishes

To send bulk Christmas wishes via SMS, the first step is to access Pabbly Connect. Open your browser and navigate to pabby.com/connect. This will direct you to the Pabbly Connect homepage, where you have options to sign in or sign up for free.

If you’re a new user, select the ‘Sign up free’ option to create an account and receive 100 free tasks each month. Existing users can simply sign in to their accounts. Once signed in, click on ‘Access Now’ to reach the Pabbly Connect dashboard.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a new workflow to automate sending SMS wishes. Click on the ‘Create Workflow’ button, which prompts you to choose between the new beta and classic versions. For this tutorial, select the beta version for a faster experience.

• Click on the ‘Select’ button to proceed.
• Name your workflow ‘Send Bulk Christmas Wishes via SMS’.
• Choose a folder for your workflow, such as ‘Automations’.

Finally, click on the ‘Create’ button to finalize the setup of your workflow in Pabbly Connect.

3. Setting Up the Trigger with Google Sheets

The next step involves setting up a trigger in your newly created workflow. Since your customer data is stored in Google Sheets, select Google Sheets as the trigger app and choose the event ‘New or Updated Spreadsheet Row’. Click on ‘Connect’ to establish a connection.

You will receive a webhook URL, which is essential for connecting Google Sheets with Pabbly Connect. Copy this URL and head over to your Google Sheets. In Google Sheets, install the Pabbly Connect Webhooks add-on by navigating to Extensions > Add-ons > Get Add-ons and searching for ‘Pabbly Connect Webhooks’.

4. Configuring Google Sheets to Work with Pabbly Connect

After installing the Pabbly Connect Webhooks add-on, refresh your Google Sheets to see the new options. Click on Extensions > Pabbly Connect Webhooks > Initial Setup. Here, you will paste the webhook URL you copied earlier and specify the trigger column, which should be the final data column (e.g., Column C).

Once you have configured the settings, click on ‘Submit’. You will see a confirmation message indicating that the setup was successful. To test the connection, click on the ‘Send Test’ button, which will send data from your Google Sheets to Pabbly Connect.

• Ensure to turn on the ‘Send on Event’ option to capture new data automatically.
• Check the workflow in Pabbly Connect to confirm the successful data receipt.

With this setup, Pabbly Connect will now automatically capture any new rows added to your Google Sheets.

5. Sending SMS Wishes via Twilio through Pabbly Connect

The final step involves sending the SMS wishes to your customers using Twilio. In your Pabbly Connect workflow, add a new action step and select Twilio as the action app. Choose the event ‘Send SMS Message’ and click on ‘Connect’ to build the connection.

Provide the required details such as Account SID, Authorization Token, and your Twilio phone number. After entering these details, click ‘Save’. Next, input the SMS body, which can be personalized, and map the recipient’s number from the data received in the previous steps.

Finally, click on ‘Save and Send Test Request’. If successful, you’ll receive a confirmation message, and the SMS will be sent to the specified number. To send the same SMS to all customers, go back to your Google Sheets, click on Extensions > Pabbly Connect Webhooks, and select ‘Send All Data’. This will automate the process through Pabbly Connect.

Conclusion

In this tutorial, we explored how to send bulk Christmas wishes via SMS using Pabbly Connect. By following these steps, you can seamlessly integrate Google Sheets and Twilio to automate your festive greetings efficiently.