Are you searching for a way to automatically send examination results on WhatsApp directly from Google Sheets?
Well If yes then you’ve landed on the correct place. As in this article, I’m going to automate this with the easiest procedure. Also, this process won’t require any coding or programming. I’ll be using Pabbly Connect service to establish a connection between Google Sheets and WhatsApp for this particular automation.
Pabbly Connect is an integration tool to connect applications and automate routine or manual tasks in real-time.
Furthermore, this process will be just a one-time setup. After that, the created workflow will take care of this WhatsApp message automation.
Why Choose This Method Of Integration?
In contrast with other integration services-
- Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
- Create “Unlimited Workflows” and smoothly define multiple tasks for each action
- As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
- Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
- Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE
Before starting the procedure, let’s discuss a little bit about the software involved. Google Sheets is an online spreadsheet program available for Free. Whereas, WhatsApp is a messenger application by Facebook.
By integrating Google Sheets with WhatsApp we are going to auto-send examination results on WhatsApp from Google Sheets directly. This way, a message will be sent automatically for every row/data added on Google Sheets.
Also, you can watch the video tutorial below for this integration.
Additionally, I’ve also added the template for this integration. It can help you get started more quickly. To use the workflow template, you can simply click on the image given below. Moreover, you can also check out the Marketplace to search for more integrations & apps.
Now, buckle up as we’re going to discover the Google Sheets and WhatsApp integration.
Step 1: Sign up to Pabbly Connect
Begin the procedure to auto send examination results on WhatsApp from Google Sheets by visiting the Pabbly Connect website. Click on the ‘Sign-Up Free‘ button available on the page. Next, feed in your existing Gmail credentials or simply register via new sign-up.
Step 2: Access Pabbly Connect
After successfully logging in to the system, click on the ‘Access Now’ button of the software ‘Connect’ amongst all the other Pabbly applications.
Step 3: Workflow for Google Sheets and WhatsApp Integration
(a) Start with a New Workflow
Further, start with creating a workflow for Google Sheets to WhatsApp integration & to do this click the ‘Create Workflow’ button available on the dashboard.
(b) Name the Workflow
A box will pop open asking for the workflow name. Name the workflow as per the integration or use-case (for instance: Google Sheets to WhatsApp etc). Lastly, click on the ‘Create’ button.
Step 4: Setting Trigger for Google Sheets to WhatsApp Integration
First, you’ll need to set up a trigger on the new Google Sheets entry and then its respective action using Pabbly Connect.
(a) Select Application you want to integrate
After naming your workflow, you can select a trigger. Choose the ‘Google Sheets’ app from the drop-down choices.
(b) Select Event & Copy Webhook URL
Next, select the trigger event as ‘New Spreadsheet Row’ & then click on ‘Copy’ to copy the webhook URL.
Step 5: Connecting Google Sheets to Pabbly Connect
(a) Create a Google Sheet & Click on Addons
First, create a new spreadsheet and then enter values associated within multiple columns such as name, roll number, percentage, phone number etc.
Next, click on the ‘Add-ons’ option from the sheet menu & then select the ‘Get Add-ons’ option from the menu that open up.
(b) Search for Pabbly Connect Webhook
In the Google Workspace Marketplace, search for Pabbly Connect Webhook. Next, click on Pabbly Connect Webhook that appears as a search result.
(c) Install Pabbly Connect Webhook
Once you access the webhook, install it by clicking the ‘Install’ button.
(d) Initial Setup
After successfully installing the addon, again go to the add-ons menu option and then click on ‘Initial Setup’ under the installed Pabbly Connect Webhook options.
Step 6: Test the Response in Pabbly Connect Dashboard
As we can see, we are done setting up the trigger for Google Sheets and WhatsApp integration. So, let’s test the Google Sheets trigger by sending a test request.
(a) Capture Webhook Response
To test the trigger first, click the ‘Capture Webhook Response’ button available in the trigger window.
(b) Paste the Copied Webhook URL & Click on ‘Send Test’
Next, paste the copied webhook URL in the ‘Webhook URL’ field of your spreadsheet’s addon settings.
Remember to mention the ‘Trigger Column’ value such as A, B, C, D, E etc. This value depends upon the column up to which you want to share the spreadsheet data.
Lastly, click the ‘Send Test’ button to send a test request.
(c) Check & Save the Trigger API Response
Check your data in the trigger response window & save this data.
Step 7: Setting Action for Google Sheets to WhatsApp Integration
Now, as we have gathered all the data to send a message on WhatsApp from Google Sheets. We can proceed to use this data to perform our action. After that, a message will be sent for every sheet entry automatically. We can not send bulk message directly so I’m using Chat API to accomplish this.
(a) Select Application you want to Integrate
Click on the plus button available next to your Google Sheets trigger window.
Select the app to integrate here as ‘Chat API’.
(b) Select Event & Connect with Chat API
Next, select the event as ‘Send Message’.
Lastly, click the ‘Connect with Chat API’ button.
Step 8: Connecting Chat API to Pabbly Connect
Our next step is to connect Chat API with Pabbly Connect. For this first, log in to your Chat API account.
(a) Copy API URL & Token
After logging into your Chat API account, your API URL & token will be visible. Simply, copy this API URL & token one by one.
(b) Paste the Copied Chat API URL & Token
Next, paste the copied API URL & token in the connection window. Finally, click on ‘Save’.
(c) Map Fields & Send Test Request
After establishing a connection successfully, you’ll see fields like phone number and message. Map the gathered trigger API response within these fields.
You can map a value by clicking the menu button (three horizontal lines) next to a field. Then, search for an appropriate field value and select it.
Similarly, you can also map the message field. Also, you can use a combination of the response values and plain text to draft a message.
Further, click on the ‘Save & Send Test Request’ button to send the message.
(d) Check & Save Response
Certainly, you can check the Chat API’s response in the action window. And, if there is some error while sending the data then the window will start showing you an error.
Finally, save the action API’s response.
Step 9: Check Response in WhatsApp
Lastly, check the WhatsApp message on the mentioned phone number.
To sum up, this was all about ‘How to send examination results on WhatsApp from Google Sheets’. Consequently, after completing the step by step procedure, you will end up sending WhatsApp messages automatically from Google Sheets.
In the meantime, you can opt Pabbly Connect for FREE with all its premium features to automate your routine tasks.
Share your feedback on this integration in the comment section below.