Learn how to automatically send messages with image links on WhatsApp using Pabbly Connect and Google Sheets. Step-by-step tutorial included. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.
Watch Step By Step Video Tutorial Below
1. Setting Up Pabbly Connect for Google Sheets and WhatsApp Integration
To start sending image links on WhatsApp automatically, first access Pabbly Connect. This automation tool allows you to integrate various applications seamlessly. Begin by signing up for a free account on the Pabbly website, where you’ll receive free automation tasks every month.
After signing in, you will see the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button to initiate your automation setup. Name your workflow something like ‘Google Sheets Image Links on WhatsApp’ and click on the ‘Create’ button to proceed.
2. Configuring the Trigger with Google Sheets
The next step involves setting up the trigger in Pabbly Connect. For this automation, the trigger will be a new or updated row in Google Sheets. Search for the Google Sheets application and select the trigger event as ‘New or Updated Spreadsheet Row’. This will generate a webhook URL essential for connecting your Google Sheets.
- Search for Google Sheets in Pabbly Connect.
- Choose the trigger event as ‘New or Updated Spreadsheet Row’.
- Copy the provided webhook URL for integration.
After copying the webhook URL, open your Google Sheets where you will enter the contact details and image links. It’s recommended to use an incognito window if using multiple Google accounts to avoid issues. Install the Pabbly Connect Webhooks add-on from the Google Workspace Marketplace, refresh your spreadsheet, and access the add-on to complete the connection setup.
3. Completing the Initial Setup in Google Sheets
Once the Pabbly Connect Webhooks add-on is installed, click on the ‘Extensions’ menu in your Google Sheets, then navigate to ‘Pabbly Connect Webhooks’ and select ‘Initial Setup’. Here, paste the webhook URL you copied earlier and specify the trigger column where the image link will be placed.
For instance, if your data starts from column A with the contact name, column B with the WhatsApp number, and column C with the image link, set column C as your trigger column. After setting this up, click on the ‘Send Test’ button to send data from your spreadsheet to Pabbly Connect for testing.
- Open ‘Initial Setup’ in the add-on.
- Paste the webhook URL and set the trigger column.
- Click ‘Send Test’ to send data to Pabbly Connect.
After sending the test data, check your Pabbly Connect workflow to ensure the data has been captured successfully. This confirms that the connection between Google Sheets and Pabbly Connect is working as intended.
4. Setting Up WhatsApp Action in Pabbly Connect
Now that the trigger is configured, the next step is to set up the action to send messages via WhatsApp. In your Pabbly Connect workflow, click on the action step and select the WhatsApp Business Solution Provider application. Choose the event ‘Send WhatsApp Template Message’ for sending messages.
Connect to your WhatsApp account by entering the required details, including the API key from your WhatsApp provider. Map the WhatsApp number from the test data captured earlier. Ensure to prepend a ‘+’ sign to the number as it won’t be included in the data by default. Then, select the template code you have created in your WhatsApp account for sending messages.
Select the WhatsApp Business Solution Provider in the action step. Choose ‘Send WhatsApp Template Message’ as the event. Map the WhatsApp number and template code.
Once all fields are mapped correctly, click on ‘Save and Send Test Request’ to send a test message. You should receive a message on WhatsApp confirming that your automation is set up correctly. This process showcases how Pabbly Connect efficiently automates sending messages with image links.
5. Finalizing the Automation Process
With the action set up, the last step is to finalize your automation process. Go back to your Google Sheets and ensure that the ‘Send on Event’ option is checked in the Pabbly Connect Webhooks add-on. This setting ensures that every time you add a new row with contact details and an image link, the workflow is triggered automatically.
Test your setup by adding a new row with a name, WhatsApp number, and an image link in Google Sheets. Once you add the details, a message will automatically be sent to the specified WhatsApp number with the image link included. This demonstrates the power of Pabbly Connect in automating communication and enhancing productivity.
After setting this up, you won’t need to perform any manual actions. Whenever you enter new data into your Google Sheets, Pabbly Connect will handle the rest, sending messages automatically without any coding required.
Conclusion
In this tutorial, we explored how to use Pabbly Connect to automatically send messages with image links on WhatsApp using Google Sheets. By setting up triggers and actions, you can streamline your communication process effectively. This automation saves time and enhances customer interaction, making it a valuable tool for businesses.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Check out Pabbly Connect – Automate your business workflows effortlessly!
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!