Author: Pabbly Team

Step 1: Sign up to Pabbly Connect

Start the procedure to notify your team members about new Shopify orders automatically by visiting the Pabbly Connect website. Simply, click on the ‘Sign-Up Free‘ button here. Next, either use your existing Google credentials for a direct sign-up or simply make a new registration by filling the form.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After logging in, click on the ‘Access Now’ button of the software ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Shopify and Telegram Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Shopify to Telegram integration & to do this click the ‘Create Workflow’ button available on the top-right of the screen.

(b) Name the Workflow

Give a name to the workflow for example Shopify To Telegram. Then, click on the ‘Create’ button.

Step 4: Setting Trigger for Shopify to Telegram Integration

For trigger set up, you’ll need to set a condition on the new Shopify orders and the respective action using Pabbly Connect.

(a) Select Application you want to integrate

When you are done with naming the workflow, a page opens up asking for the trigger condition.

Pick the ‘Shopify’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Copy Webhook URL

Select the event as ‘New Order’ & then click on ‘Copy’.

Step 5: Connecting Shopify to Pabbly Connect

(a) Go to Your Shopify Settings

After successfully logging into your Shopify store, click the ‘Settings’ option available at the bottom left corner in the left-vertical menu.

(b) Select Notification Option

From all the Shopify settings, select the notification option.

(c) Click the Create Webhook Button

On the next page, head directly to the bottom of the page on the ‘Webhooks’ section & click on ‘Create Webhook’.

(d) Select Event & Paste Webhook URL

Next, select the Event as ‘Order Creation’, Format as ‘JSON’ and pasted the copied Webhook URL. Lastly, click on ‘Save Webhook’.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Shopify and Telegram integration. So, let’s test the Shopify trigger by making a test order.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Place an Order on Your Shopify Store

Now, go back to the Shopify store and make a test order for any product. Remember to complete the order until your order is confirmed.

(c) Check and Save the Trigger API Response

Check the Shopify trigger API response for the entered order entries.

Step 7: Setting Action for Shopify to Telegram Integration

Now, we have gathered the Shopify order data. So, let’s perform the Telegram action step. After that, a message will be delivered automatically whenever a new order is made.

(a) Select Application you want to Integrate

Click on the plus button available next to your Shopify trigger window.

Select the app to integrate as ‘Telegram Bot’.

(b) Select Event & Connect with Telegram

Next, select the action event as ‘Send a Text Message or a Reply’.

Lastly, click the ‘Connect’ button.

Step 8: Connecting Telegram to Pabbly Connect

Our next step is to establish a connection between Telegram and Pabbly Connect. For this first, sign in to your Telegram account.

(a) Click on the BotFather Link

In the connection window that slides in from the right, click on the given BotFather link. You can also type ‘BotFather’ in your Telegram App search to access BotFather.

(b) Click Start on BotFather Chat

Next, in the BotFather chat window, click the ‘START’ button.

(c) Create a New Bot

Create a new bot by typing ‘/newbot’ command and then hit enter or click on the send icon.

(d) Name Your Created Bot

Next, it’ll ask you for a bot name. So, type a bot name that you want to assign to the recently created bot & then click ‘Send’.

(e) Enter a Bot Username

Lastly, enter a username for the created bot. The username must end with the suffix ‘bot’.

(f) Copy the Token

You’ll get a token for the created bot, simply select & copy the token.

(g) Paste the Token

Paste the copied token in the Pabbly Connect connection window and then click ‘Save’.

(h) Create Telegram Group

Now, create a group on your Telegram account and add members as well as the created bot to the group. Lastly, promote the bot to admin privilege.

(i) Copy Chat ID

In the URL, the digit sequence after ‘=’ to ‘-‘ is the chat ID. Copy these digits. To know more about the Chat ID, you can read the help text given below the Telegram action ‘Chat ID’ field.

(j) Paste Chat ID & Create Message

Now, paste the Chat ID with the prefix ‘-100’ for a private channel message.

Also, draft a message by combining the trigger response and plain text. To use the response values, simply place your cursor in the ‘Text Message’ field and select the value from the gathered trigger response.

(k) Send Test Request

Now, click on ‘Save & Send Test Request’.

(l) Check & Save the Action Response

Certainly, you can check the Telegram API response in the action window. And, if there’s been 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 Telegram message on the connected group. Also, make another test order on your Shopify shop to test the workflow.

Step 1: Sign up to Pabbly Connect

Start the procedure to send Telegram messages on form submissions automatically by visiting the Pabbly Connect website. Simply, click on the ‘Sign-Up Free‘ button here. Next, either use your existing Google credentials for a direct sign-up or simply make a new registration by filling the form.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After logging in, click on the ‘Access Now’ button of the software ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Typeform and Telegram Integration

(a) Start with a New Workflow

Further, start with creating a workflow forTypeform to Telegram integration & to do this click the ‘Create Workflow’ button available on the top-right of the dashboard screen.

(b) Name the Workflow

Now, name the workflow in the window that pops up as per the integration or use-case (for instance: Typeform To Telegram etc). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Typeform to Telegram Integration

For trigger set up, you’ll need to set up a trigger condition on the new Typeform entry and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming the workflow, a page will open up bearing the trigger window settings.

Pick the ‘Zoom’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Connect

Select the event as ‘New Entry’ & then click on ‘Connect’.

Step 5: Connecting Typeform to Pabbly Connect

(a) Connect with Typeform

To connect Typeform with Pabbly connect, you only need to click on the ‘Connect with Typeform’ button that came along with a window that slides in from the right.

Authorize the connection by allowing the account permissions.

(b) Select Form & Send Test Request

Next, select the form that you want to connect with Pabbly Connect.

If you haven’t created a form, then first create a form and then click the refresh button next to the form field.

Lastly, click on ‘Save & Send Test Request’.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Typeform and Telegram integration. So, let’s test the Typeform trigger by submitting a test form.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Submit a Test Form

Now, go back to your the created form and make a test submission. For this, simply open the form in a new tab and fill all the required information and lastly submit.

(c) Check and Save the Trigger API Response

Check the Typeform trigger API response and click on ‘Save’.

Step 7: Setting Action for Typeform to Telegram Integration

Now, we have gathered the Typeform data. So, let’s perform the action step. After that, a message will be delivered automatically whenever a new form submission happens.

(a) Select Application you want to Integrate

Click on the plus button available next to your Typeform trigger window.

Select the app to integrate here as ‘Telegram Bot’.

(b) Select Event & Connect with Telegram

Next, select the event as ‘Send a Text Message or a Reply’.

Lastly, click the ‘Connect’ button.

Step 8: Connecting Telegram to Pabbly Connect

Our next step is to connect Telegram with Pabbly Connect. For this first, log in to your Telegram account.

(a) Click on the BotFather Link

In the Pabbly Connect connection window that slides in from the right. Click on the BotFather link or simply type ‘BotFather’ in your Telegram App search.

(b) Click Start on BotFather Chat

Next, click the ‘START’ button.

(c) Create a New Bot

Create a new bot by typing ‘/newbot’ and then hit Enter/send button.

(d) Name Your Created Bot

Next, it asks you for a bot name. So, type a bot name that you want to give to the recently created bot & then hit the send.

(e) Enter a Bot Username

Lastly, enter a username for the created bot that ends with a suffix ‘bot’.

(f) Copy the Token

You’ll get a token for the created bot, simply select and copy it.

(g) Paste the Token

Paste the copied token in the connection window and then click ‘Save’.

(h) Create Telegram Group

Now, create a group on the connected Telegram account, add members, also add the created bot and promote it to admin.

(I) Copy Chat ID

In the URL, digit sequence from ‘s’ to underscore is the chat ID. Copy these digits. To more about the Chat ID, you can also refer to the help text bellow the Telegram action ‘Chat ID’ field.

(j) Paste Chat ID & Create Message

Now, paste the Chat ID with the prefix ‘-100’ for a private channel message.

Also, create a message using the combination of the trigger response and plain text. To use the response values, simply click on the ‘Text Message’ area and select the value from the gathered trigger response.

(k) Send Test Request

Now, click on ‘Save & Send Test Request’.

(l) Check & Save the Action Response

Certainly, you can check the Telegram response in the action window. And, if there’s been 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 Telegram message on the connected group.

Step 1: Sign up to Pabbly Connect

Initiate the procedure to send Zoom meeting invite via SMS automatically by visiting the Pabbly Connect website. Click on the ‘Sign-Up Free‘ button available on the top-right corner of the home page. Next, either use your existing Gmail credentials to make a direct sign-up or simply fill out the registration form provided.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After logging in, click on the ‘Access Now’ button of the service ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Zoom and Twilio Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Zoom to Twilio integration & to do this click the ‘Create Workflow’ button available on the top-right corner of the dashboard.

(b) Name the Workflow

Now, name the workflow in the window that pops up as per the integration or use-case (for instance: Zoom To Twilio, Zoom integration etc). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Zoom to Twilio Integration

First, we’ll need to set up a trigger condition on every new Zoom registrant entry and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming the workflow, a window will open up along with the trigger settings.

Select the ‘Zoom’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Copy the Webhook URL

Also, pick the event as ‘Configure Webhook’ & then click on ‘Copy’.

Step 5: Connecting Zoom to Pabbly Connect

(a) Go to Zoom Account Integrations

To connect Zoom with Pabbly Connect, sign in to your Zoom account. Then, click on the ‘Advanced’ option available in the left verticle menu.

After that, click on the ‘Integration’ option.

(b) Go to Zoom App Marketplace

Next, click on ‘Go to App Marketplace’.

Also, click on the ‘Agree’ button, when a Zoom term of use dialogue box opens up.

(c) Click on Build App

On the next page, pick the ‘Develop’ option available on the top horizontal menu.

Then, choose the ‘Build App’ option from the drop-down menu.

Again, if the Zoom – Terms of Use dialogue open up click on the ‘Agree’ button.

(d) Click on ‘Create’ Under JWT App Type

Next, click on ‘Create’ available under the Zoom ‘JWT’ app type.

Then, name the App as per your choice in the ‘Create a JWT App’ window that opens up like Zoom App, Starfield Tutorial etc.

(e) Add Basic Information of the App

Add all the required basic information for the created app and then click on the ‘Continue’ button.

(f) Add the Event

Next, click on the ‘Feature’ option from the menu and then toggle on the ‘Event Subscription’ option.

Lastly, click on the ‘Add new event subscription’ button.

(g) Paste the Webhook URL & Add Event

Now, name the subscription as per your need and paste the copied Pabbly Connect trigger webhook URL.

Then, click on the ‘Add Events’ button.

(h) Select Event

Under the Event Type – ‘Meeting, select the ‘Meeting Registration has been created’ option from the ‘. Then, click on ‘Done’.

(I) Save the Zoom Event Settings

Lastly, click on the ‘Save’ button and then click on ‘Continue’ in the next window.

Make sure to confirm the setup success after looking at the ‘Your App is Activated on the account’ message.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Zoom and Twilio integration. So, let’s test the Zoom trigger by adding a test registrant.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Go to Zoom Meetings

Now, go back to your Zoom account & create a test meeting registration. For this first, go to the ‘Meetings’ option available in the Zoom menu. Then, go to the ‘Upcoming’ tab under meeting options available in the secondary horizontal menu available.

(c) Schedule a Meeting

Then, click on the ‘Schedule a Meeting’ button under the Upcoming meeting tab.

(d) Add Meeting Details

Next, enter all the required details for the meeting such as Topic, Description, When, Duration, Time Zone etc.

(e) Save the Meeting Details

Toggle the host & participants option to ‘On’ and click on the ‘Save’ button.

(f) Click on the Registration Link

Then, click on the ‘Registration Link’ available for the meeting.

On the registration form, you’ll notice that there are only a limited number of fields.

And as we want to send an invite on SMS hence the phone number is a must.

So, let’s add some more fields to the registration form.

(g) Edit the Zoom Registration Form

Now, go back to the crated Zoom registration form, scroll down to the bottom of this page and then click on ‘Edit’.

(h) Go to Questions & Check Form Fields

In the window that pops up next, select the ‘Questions’ option.

Then, pick all the required fields for your registration form such as ‘Phone’.

Also, mark the ‘Phone’ field as ‘Required’, so that a registrant can’t leave it blank.

Lastly, click on the ‘Save All’ button.

(i) Register on Zoom

Now, fill in all the test details in the registration form and then click on ‘Register’.

(j) Check & Save Trigger API Response

Check the trigger API response and click on ‘Save’.

Step 7: Setting Action for Zoom to Twilio Integration

Now, as we have gathered all the data from Zoom registration. We can proceed to use this data to perform our Twilio action. After that, an SMS will be sent automatically to every new registrant.

(a) Select Application you want to Integrate

Click on the plus button available next to your Zoom trigger window.

Select the app to integrate here as ‘Twilio’.

(b) Select Event & Connect with Twilio

Next, select the event as ‘Send SMS Message’.

Lastly, click the ‘Connect’ button.

Step 8: Connecting Twilio to Pabbly Connect

Our next step is to connect Twilio with Pabbly Connect. For this first, log in to your Twilio account.

(a) Copy SID & Token

After logging into your Twilio account, go to the ‘Settings’ option from the menu. There you’ll find the SID and token. You can simply copy & paste the SID as well as the token on the Pabbly Connect connection window. To copy the token first, click on the ‘Eye’ icon to make it visible.

(b) Paste the Copied SID & Token

Next, paste the copied SID & token in the connection window. Finally, click on ‘Save’.

(c) Map Fields

After establishing a connection successfully, you’ll see fields like the body of the SMS, sender number, recipient number etc. Map the gathered trigger API response within these fields.

To map a value from the response, simply place your cursor into the field and find & click select the response value.

(d) Send Test Request

Similarly, you can also map the message field. Also, you can use a combination of the response values & plain text to draft a message.

Further, click on the ‘Save & Send Test Request’ button to send an SMS.

(d) Check & Save Response

Certainly, you can check the Twilio response status in the action window. And, if there is some error while sending the data then the window will start showing you the error.

Finally, save the action API’s response.

Step 9: Check Response on SMS

You can check the SMS invite on the mentioned phone number.

Step 1: Sign up to Pabbly Connect

Begin the procedure to send Zoom invite on WhatsApp automatically by visiting the Pabbly Connect website. Click on the ‘Sign-Up Free‘ button available on the top-right corner of the home page. Next, either use your existing Gmail credentials to make a direct sign-up or simply make registration by filling the form provided.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After logging in, click on the ‘Access Now’ button of the service ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Zoom and WhatsApp Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Zoom to WhatsApp integration & to do this click the ‘Create Workflow’ button available on the top-right corner of the dashboard.

(b) Name the Workflow

Now, name the workflow in the window that pops up as per the integration or use-case (for instance: Zoom To WhatsApp, Zoom integration etc). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Zoom to WhatsApp Integration

For trigger set up, you’ll need to set up a trigger condition on the new Zoom registrant entry and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming the workflow, a page will open up bearing the trigger window settings.

Pick the ‘Zoom’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Copy the Webhook URL

Select the event as ‘Configure Webhook’ & then click on ‘Copy’.

Step 5: Connecting Zoom to Pabbly Connect

(a) Go to Zoom Account Integrations

To connect Zoom with Pabbly connect, log in to your Zoom account. Then, click on the ‘Advanced’ option present in the left verticle menu.

After that, click on ‘Integration’.

(b) Go to Zoom App Marketplace

Next, click on the ‘Go to App Marketplace’ button.

Also, click on ‘Agree’, when a Zoom term of use dialogue box opens up.

(c) Click on Build App

On the next page, click on the ‘Develop’ option available on the top horizontal menu.

Then, select the ‘Build App’ option from the drop-down menu that opens next.

Again, if the Zoom – Terms of Use dialogue open up click on ‘Agree’.

(d) Click on ‘Create’ Under JWT App Type

Next, click on the ‘Create’ button available under the ‘JWT’ app type.

Then, name the App as per your choice in the ‘Create a JWT App’ window that opens up such as Zoom App, Starfield Tutorial etc.

(e) Add Basic Information of the App

Add all the required information for the created app and then click on ‘Continue’.

(f) Add Event

Next, click on ‘Feature’ from the menu and then toggle the ‘Event Subscription’ option.

Lastly, click on ‘Add new event subscription’.

(g) Paste the Webhook URL & Add Event

Now, name the subscription and paste the copied webhook URL.

Then, click on ‘Add Events’.

(h) Select Event

Select the ‘Meeting Registration has been created’ option from the Event Type – ‘Meeting’. Then, click on ‘Done’.

(I) Save the Zoom Event Settings

Lastly, click on ‘Save’ and then click on the ‘Continue’ button in the next window.

Make sure to confirm the setup success after looking at the ‘Your App is Activated on the account’ message.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Zoom and WhatsApp integration. So, let’s test the Zoom trigger by adding a test registrant.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Go to Zoom Meetings

Now, go back to your Zoom account and create a meeting registration. For this, go to the ‘Meetings’ option from your Zoom account’s menu. Then. go to the ‘Upcoming’ tab under meeting options available in the horizontal menu available.

(c) Schedule a Meeting

Then, click on the ‘Schedule a Meeting’ button under the Upcoming meetings.

(d) Add the Meeting Details

Next, enter all the required details to make a registration such as Topic, When, Duration, Time Zone etc.

(e) Save the Meeting Details

Toggle the Host and Participants option to ‘On’ and click on ‘Save’.

(f) Click on the Registration Link

Now, click on the ‘Registration Link’.

On the registration form, you’ll see there are only a limited number of fields.

And as we want to send an invite on WhatsApp hence the phone number is a must.

So, we’ll simply add some more fields to the registration form.

(g) Edit the Zoom Registration Form

Now, go back to your Zoom registration form, scroll down to the bottom of the page and click on ‘Edit’.

(h) Go to Questions & Check Form Fields

In the window that pops up next, click on the ‘Questions’ option.

Then, select all the required fields for your registration form such as ‘Phone’.

Also, mark it as ‘Required’, so that a registrant can not leave it blank.

Lastly, click on ‘Save All’.

(i) Register on Zoom

Fill in all the details in the registration form and then click on ‘Register’.

(j) Check and Save Trigger API Response

Check the trigger API response and click on ‘Save’.

Step 7: Add Data Transformer

This is an advance step, as in the next step when we’ll be performing the action step, it will ask for an encoded URL.

(a) Select Application you want to Integrate

Select the Choose App field as ‘Data Transformer by Pabbly’ and the action event as ‘Base64 Encode’. Then, click on ‘Connect’.

(b) Map Join URL

Place your cursor in the field named ‘Data’ and search as well as map the join URL gathered from the trigger response.

After mapping the URL, click on the ‘Save & Send Test Request’ button.

Lastly, check the response status as ‘Success’.

Step 8: Setting Action for Zoom to WhatsApp Integration

Now, as we have gathered all the data from Zoom. We can proceed to use this data to perform our WhatsApp action. After that, the link will be sent 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 Zoom trigger window.

Select the app to integrate here as ‘Chat API’.

(b) Select Event & Connect with Chat API

Next, select the event as ‘Send Link’.

Lastly, click the ‘Connect’ button.

Step 9: 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.

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 10: Check Response in WhatsApp

Lastly, check the WhatsApp message on the mentioned phone number.

Step 1: Sign up to Pabbly Connect

Begin the procedure to add new Zoom registrants to Google Sheets automatically by visiting the Pabbly Connect website. Click on the ‘Sign-Up Free‘ button available on the top-right corner of the home page. Next, either use your existing Gmail credentials to make a direct sign-up or simply make registration by filling the form provided.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After logging in, click on the ‘Access Now’ button of the service ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Zoom and Google Sheets Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Zoom to Google Sheets integration & to do this click the ‘Create Workflow’ button available on the top-right corner of the dashboard.

(b) Name the Workflow

Now, name the workflow in the window that pop up as per the integration or use-case (for instance: Zoom To Google Sheets, Zoom integration etc). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Zoom to Google Sheets Integration

For trigger set up, you’ll need to set up a trigger condition on the new Zoom registrant entry and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming the workflow, a page will open up bearing the trigger window settings.

Pick the ‘Zoom’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Copy the Webhook URL

Select the event as ‘Configure Webhook’ & then click on ‘Copy’.

Step 5: Connecting Zoom to Pabbly Connect

(a) Go to Zoom Account Integrations

To connect Zoom with Pabbly connect, log in to your Zoom account. Then, click on the ‘Advanced’ option present in the left verticle menu.

After that, click on ‘Integration’.

(b) Go to Zoom App Marketplace

Next, click on the ‘Go to App Marketplace’ button.

Also, click on ‘Agree’, when a Zoom term of use dialogue box opens up.

(c) Click on Build App

On the next page, click on the ‘Develop’ option available on the top horizontal menu.

Then, select the ‘Build App’ option from the drop-down menu that opens next.

Again, if the Zoom – Terms of Use dialogue open up click on ‘Agree’.

(d) Click on ‘Create’ Under JWT App Type

Next, click on the ‘Create’ button available under the ‘JWT’ app type.

Then, name the App as per your choice in the ‘Create a JWT App’ window that opens up such as Zoom App, Starfield Tutorial etc.

(e) Add Basic Information of the App

Add all the required information for the created app and then click on ‘Continue’.

(f) Add Event

Next, click on ‘Feature’ from the menu and then toggle the ‘Event Subscription’ option.

Lastly, click on ‘Add new event subscription’.

(g) Paste the Webhook URL & Add Event

Now, name the subscription and paste the copied webhook URL.

Then, click on ‘Add Events’.

(h) Select Event

Select the ‘Meeting Registration has been created’ option from the Event Type – ‘Meeting’. Then, click on ‘Done’.

(I) Save the Zoom Event Settings

Lastly, click on ‘Save’ and then click on the ‘Continue’ button in the next window.

Make sure to confirm the setup success after looking at the ‘Your App is Activated on the account’ message.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Zoom and Google Sheets integration. So, let’s test the Zoom trigger by adding a test registrant.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Go to Zoom Meetings

Now, go back to your Zoom account and create a meeting registration. For this, go to the ‘Meetings’ option from your Zoom account’s menu. Then. go to the ‘Upcoming’ tab under meeting options available in the horizontal menu available.

(c) Schedule a Meeting

Then, click on the ‘Schedule a Meeting’ button under the Upcoming meetings.

(d) Make a Registration

Next, enter all the required details to make a registration and then click ‘Save’.

(e) Click on the Registration Link

Now, click on the ‘Registration Link’.

(f) Register on Zoom

Fill in all the details in the registration form and then click on ‘Register’.

(g) Check and Save Trigger API Response

Check the trigger API response and click on ‘Save’.

Step 7: Setting Action for Zoom to Google Sheets Integration

Now, as we have gathered all the data from Zoom. We can proceed to use this data to perform our Google Sheets action. After that, the data will be added to your spreadsheet automatically.

(a) Create a Google Sheet

To save the registrants entries in a Google Sheet, create a dedicated Google Sheet with the column heads to enter the details such as Events, Name, Last Name, Email, Address, City, Zip Code, Phone, Country etc.

(b) Select Application you want to Integrate

Hit the plus button next to your Zoom trigger window.

Choose the app to integrate as ‘Google Sheets’ & event as ‘Add New Row’.

(c) Authorize Google Account

Next, click on the ‘Connect with Google Sheets’ button in the window that slides in from the right.

(d) Select Spreadsheet & Map Fields

Once the Google account authorization completes. Select your created spreadsheet and sheet. Also, map the spreadsheet fields with the response value stored.

To map a field value, click on that particular field. Then, select the response value that you want to map with that field. Similarly, map all the other required values.

(e) Send Test Request

After mapping all the field values, click on the ‘Save & Send Test Request’ to send a test request.

Step 8: Check Response in Google Sheets

Also, you can check the registrant entry on your connected Google Sheet.

Step 1: Sign up to Pabbly Connect

Begin the procedure to auto send WhatsApp messages to Mailchimp subscribers by visiting the Pabbly Connect website. Then, click on the ‘Sign-Up Free‘ button available at the top of the page. Next, either sign in using your existing Gmail account or simply register by filling the form.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After successfully logging in to the system, click on the ‘Access Now’ button of the service ‘Connect’ amongst all the other Pabbly applications.

Step 3: Workflow for Mailchimp and WhatsApp Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Mailchimp to WhatsApp integration & to do this click the ‘Create Workflow’ button available on the dashboard.

(b) Name the Workflow

A window will open up requesting the workflow name. Name this workflow as per the integration or use-case (for instance: Mailchimp to WhatsApp etc). Lastly, click on the ‘Create’ button available at the bottom of this window.

Step 4: Setting Trigger for Mailchimp to WhatsApp Integration

First, you’ll need to set up a trigger on the new Mailchimp subscriber 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 ‘Mailchimp’ from the drop-down choices.

(b) Select Event & Copy Webhook URL

Next, select the trigger event as ‘New Subscriber’ & then click on ‘Copy’ to copy the webhook URL.

Step 5: Connecting Mailchimp to Pabbly Connect

(a) Go to the Audience Dashboard Section

First, log in to your Mailchimp account then click on the ‘Audience dashboard’ option available in the left vertical menu.

(b) Click on ‘Manage Audience’

On the Audience page, click on the ‘Manage Audience’ button. Then, select the ‘settings’ option from the drop-down menu that opens up.

(c) Click on Webhooks

On the settings page, scroll down and click on ‘Webhooks’.

(d) Click on Create New Webhook

Next, click on the ‘Create New Webhook’ button available on the right side of the page.

(e) Paste Webhook URL

Paste the copied webhook URL in the ‘Callback URL’ field, select the update type and then click on ‘Save’.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for Mailchimp and WhatsApp integration. So, let’s test the Mailchimp trigger by creating a test subscriber.

(a) Capture Webhook Response

To test the trigger first, click the ‘Capture Webhook Response’ button available in the trigger window.

(b) Go to Add a Subscriber

Next, go to the ‘All contacts’ option from the left verticle menu. Then, select the ‘Add contacts’ option from the horizontal menu. Lastly, select the ‘Add a subscriber’ to add a test subscriber on Mailchimp.

(c) Fill in the Subscriber Data & Click on Subscribe Button

Fill in all the required form information such as first name, last name, address details etc then check the permission box and finally click on ‘Subscribe’.

(d) Check & Save the Trigger API Response

Check your data in the trigger response window & save this data.

Step 7: Setting Action for Mailchimp to WhatsApp Integration

Now, as we have all the data to send a message on WhatsApp from Mailchimp. We can use this data to perform our action. After that, a message will be sent for every subscriber entry automatically. We can not send bulk messages directly from WhatsApp 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 Mailchimp trigger window.

Select the app to integrate here as ‘Chat API’.

(b) Select Event & Connect with Mailchimp

Next, select the event as ‘Send Message’.

Lastly, click the ‘Connect with Chat API’ button.

Step 8: Connecting Chat API to Pabbly Connect

Next, we’ll connect Chat API with Pabbly Connect to complete our action to send WhatsApp messages to Mailchimp subscribers. For this, log in to your Chat API account.

(a) Copy API URL & Token

Copy the Chat API’s API URL & token one by one.

(b) Paste the Copied Chat API URL & Token

Next, paste the copied API URL & token one by one in the connection window. Finally, click on ‘Save’.

(c) Map Fields & Send Test Request

After successfully establishing a connection between Pabbly Connect and Chat API, you’ll see fields like phone number and message. Map the trigger API response within these fields.

To map a value, place your cursor in the field. Then, search for an appropriate response value and select it.

Similarly, you can further map the message field. Also, you can use a combination of the response values as well as plain text to draft your message.

Lastly, click on the ‘Save & Send Test Request’ button to send a 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.

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.

Try Pabbly Connect for FREE

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.

Step 1: Sign up to Pabbly Connect

Begin the procedure to add form responses to Google Sheets by visiting the Pabbly Connect website. Click on the ‘Sign-Up Free‘ button available on the top right corner of the page. Next, either use your existing Gmail account or simply register via new sign-up.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Once you are successfully logged in, click on the ‘Access Now’ button of the software ‘Connect’ amongst all the other Pabbly applications.

Step 3: Workflow for Elementor and Google Sheets Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Elementor to Google Sheets integration & to do this click the ‘Create Workflow’ button available on the dashboard.

(b) Name the Workflow

A window will pop up asking for the workflow name. Name your workflow as per your integration or use-case (for instance: Elementor To Google Sheets ). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Elementor to Google Sheets Integration

First, you’ll need to set up a trigger on the new Elementor form entries and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming the workflow, a page will open up along with the trigger settings.

Pick the ‘Elementor Website Builder’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Copy Webhook URL

Select the event as ‘New Form Submission’ & then copy the webhook URL.

Step 5: Connecting Elementor to Pabbly Connect

(a) Open Form with Elementor

First, log in to your WordPress site where you are using the Elementor plugin. Then open the form in which you want to bring the automation in Elementor.

(b) Click on the Created Form

Next, click on the created form.

(c) Click on Action After Submit

Now, scroll to the bottom of the left verticle menu and click on the ‘Action After Submit’ option.

(d) Add Action Webhook

Next, select the ‘Webhook’ option from the Add Action drop-down.

(e) Paste the Webhook URL & Click on Update

Now, paste the copied webhook URL in the field given and then click ‘Update’.

Step 6: Test the Response in Pabbly Connect Dashboard

We are halfway through setting up the trigger for Elementor and Google Sheets integration. So, let’s test the Elementor trigger by making a test form entry.

(a) Capture Webhook Response

Don’t forget to click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Submit a Test Form

Now, open the connected form in a separate window and make a test entry.

Fill in all the required form fields and then click on ‘Send’.

(c) Check & Save the Trigger API Response

Check the sheet data in the trigger response window & save this data.

Step 7: Setting Action for Elementor to Google Sheets Integration

As we have gathered all the data to add form responses to Google Sheets. We can now proceed to use this data to perform our Google Sheets action. After that, all the form response will get automatically added on the connected Google Sheet.

(a) Create a Google Sheet

The very first step is to create a dedicated Google Sheet along with the columns values that we want to store from the form response.

(b) Select Application you want to Integrate

Hit the plus button next to your Elementor trigger.

Select the action app to integrate here as ‘Google Sheets’.

(c) Select Event & Connect with Google Sheets

Next, select the event as ‘Add New Row’.

Lastly, click the ‘Connect with Google Sheets’ button.

Step 8: Connecting Google Sheets to Pabbly Connect

Our next step is to connect Google Sheets with Pabbly Connect. For this first, authorize your Google account to connect.

(a) Authorize Google Account

An authorization window will open up next. Authorize your Google account to connect with Pabbly Connect by allowing the required permissions.

(b) Select Spreadsheet & Map Fields

Further, select the spreadsheet that you created and the sheet within. Also, map the required spreadsheet column values with the gathered response.

To map simply click on the menu button (three horizontal lines) next to any field.

After that, search and select the response value from the trigger response.

Similarly, map all the required fields.

(c) Send Test Request

Further, click on the ‘Save & Send Test Request’ button to add the response values in the spreadsheet.

(d) Check & Save Response

Certainly, you can check the Action API’s response in the action window. And, if there is some error while sending the data then the window will start showing you the error.

Finally, click on ‘Save’ to save the action API’s response.

Step 9: Check Response in Google Sheet

Also, you can check the form response’s entry on the connected Google Sheet.

Step 1: Sign up to Pabbly Connect

Begin the procedure to add new tasks to Google Sheets automatically by visiting the Pabbly Connect website. Click the ‘Sign-Up Free‘ button available on the home page. Next, either use your existing Gmail credentials or simply make registration via new sign-up.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After successfully logging in, click the ‘Access Now’ button of the software ‘Connect’ amongst all the Pabbly applications.

Step 3: Workflow for Asana and Google Sheets Integration

(a) Start with a New Workflow

Further, start with creating a workflow for Asana to Google Sheets integration & to do this click the ‘Create Workflow’ button available on the dashboard.

(b) Name the Workflow

A window asking for the workflow name will pop up. Now, name the workflow as per the integration or use-case (for instance: Asana To Google Sheets). Lastly, click on the ‘Create’ button.

Step 4: Setting Trigger for Asana to Google Sheets Integration

At first, you’ll need to set up a trigger on the new Asana task entry and then its respective action using Pabbly Connect.

(a) Select Application you want to integrate

After naming your workflow, a page will open up carrying the trigger window settings.

Pick the ‘Asana’ app from the ‘Choose App’ drop-down choices.

(b) Select Event & Connect with Asana

Select the event as ‘New Task in Project’ & then click on ‘Connect with Asana’.

Step 5: Connecting Asana to Pabbly Connect

(a) Authorize Asana Account

To connect Asana with Pabbly connect, click on the ‘Connect with Asana’ button that appears within the window that slides in from the right.

Also, allow for the permissions required to connect your Asana account with Pabbly Connect.

(b) Select a Project & Send Test Request

After the authorization, select the Asana project that you want to connect with Pabbly Connect. And if you haven’t created the project on Asana yet then first, create a project on Asana and then click on the ‘Refresh’ button.

Once you are done selecting a project, click on the ‘Save & Send Test Request’ button.

Check the response of the connection in the API response.

Step 6: Test the Response in Pabbly Connect Dashboard

As we can see, we are done setting up the trigger for the Asana and Google Sheets integration. So, let’s test the Asana trigger by adding a test task.

(a) Capture Webhook Response

The first thing to do is, click on the ‘Capture Webhook Response’ button available in the Pabbly Connect trigger window.

(b) Add a Test Task

Now, go back to your Asana account and create a test task. To create a task, simply click on the ‘Add task’ button within the selected project. Name it and add details like Assignee, Due Date, Description etc.

Check the response for the test task creation, you won’t find any data directly coming into the response.

Step 7: Get Task Details

To get the detailed data for the Asana task, we can map the task id and then get the detailed data. But, if we directly get the data then at the end of this workflow, we’re still not able to get the data in the sheet. So at first, we must add a delay function to resolve this.

(a) Add Delay

To add a delay, simply click the plus button next to your trigger. Then, choose the app as ‘Delay’ and the delay value as ‘1’. Later, click on ‘Save & Send Test Request’.

(b) Get Task Details

Now, integrate asana again as an action to get the task details. Select the app as ‘Asana’ and the event as ‘Get a Task’. Lastly, click on ‘Connect with Asana’.

(c) Map Task ID & Send Test Request

Map the ‘Task ID’ from the trigger response.

Check the response, you can see all the test values in the response fields.

Step 8: Setting Action for Asana to Google Sheets Integration

Now, as we have gathered all the task data from Asana. We can proceed to use this data to perform our action. After that, the data will be added to Google Sheets automatically.

(a) Create a Google Sheet

To save the task entries in a Google Sheet, create a dedicated Google Sheet with the column heads to enter the task details.

(b) Select Application you want to Integrate

Hit the plus button next to your Asana ‘Get a Task’ action window.

Select the app to integrate here as ‘Google Sheets’ and event as ‘Add New Row’.

(c) Authorize Google Account

Next, click on the ‘Connect with Google Sheets’ button in the window that slides in from the right.

(d) Select Spreadsheet & Map Fields

Once the Google account authorization is completed. Select the spreadsheet and sheet. Also, map the spreadsheet fields with the response values.

To map a field value, click on the mapping button (i.e. button with three vertical lines) next to any particular field. Then, select the response value that you want to map with that field.

(e) Send Test Request

After mapping all the fields, click on the ‘Save & Send Test Request’.

Step 9: Check Response in Google Sheets

Also, you can check the task entries on your connected Google Sheets Account.

Step 1: Sign up to Pabbly Connect

Begin the procedure to send birthday cards wishes on WhatsApp from Google Sheets by visiting the Pabbly Connect website. On the home page, click the ‘Sign-Up Free‘ button and then either enter your existing Gmail credentials or simply fill up the signup form to register.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

After that, click on the ‘Access Now’ button of the service ‘Connect’ (as shown in the above image) amongst the various other Pabbly applications.

Step 3: Workflow for Google Sheets and WhatsApp Integration

(a) Start with a New Workflow

Start creating a workflow for this integration by clicking the ‘Create Workflow’ button.

(b) Name the Workflow

Now, you can name the workflow as per the integration or use-case (for instance: WhatsApp Birthday Messages From Google Sheets etc). Finally, click the ‘Create’ button available.

Step 4: Setting Trigger for Google Sheets to WhatsApp Integration

To automatically send birthday wishes on WhatsApp, first, you’ll need to set up a trigger on the Google Sheets entries and its respective action to send birthday wishes on WhatsApp using Pabbly Connect. But, the very first thing is to check for any birthdays daily.

(a) Select Application you want to integrate

After naming your workflow, a page will open up along with the trigger window settings.

Pick the ‘Schedule’ app from the ‘Choose App’ drop-down choices.

(b) Select Scenario, Time & Connect Click Save

Select the ‘Run Scenario’ field value as ‘Every day’.

Next, select the time as per URC format.

Step 5: Connecting Google Sheets to Pabbly Connect

Before conning the system with a Google Sheet first, create a Google Sheet with details of the person whom you want to auto-send birthday wishes.

(a) Create Google Sheet & Enter Values

Log in to your Google Sheets and create a spreadsheet for this purpose. Also, enter values like name, phone number, message, image URL, birth date etc.

(b) Select Application you want to integrate

Now, click on the plus ‘+’ button next to your trigger window. Then, select the ‘Google Sheets’ app from the choose app dropdown.

(c) Select Event & Connect with Google Sheets

Next, select the event as ‘Get Row(s)’ and click on the ‘Connect with Google Sheets’ button.

(d) Authorize Google Account

Further, authorize your Google account connection by allowing Pabbly Connect some specific permissions.

(e) Select Spreadsheet, Range and Send Test Request

After the authorization, select the spreadsheet that you created for this automation.

Next, specify the range from the spreadsheet up to which the automation will run. To mention the range value simply select the rows and column in your spreadsheet. When you select a particular range in spreadsheets it starts showing the range on the top left corner. Copy that range parameter and paste it here.

Lastly, click on the ‘Save & Send Test Request’ button.

(f) Toggle Response & Send Test Request

Here, you can see that the response is in a separate format. To gather this response together toggle the ‘Simple Response’ button and click ‘Save & Send Test Request’.

(g) Check and Save the API Response

At this point, the response value came into a JSON format. Simply, save this response.

Step 6: Add an Iterator

As of now, the trigger response is in a single JSON format. To separate it value-wise we must pass it through an iterator.

(a) Select Application you want to integrate

Click on the ‘+’ button next to your Google Sheet integration window. then, select the ‘Iterator’ option from the ‘Choose App’ field’s deop-down.

Finally, click on the ‘Save & Send Test Request’ button.

(b) Check & Save Iterator Response

Remember to save the iterator’s API response.

Step 7: Connect JSON Extractor

Up to the last iterator response, we’ve separated the response for a single row. Now to generate a message the values are required to be in plain text format. So, integrating a JSON extractor is required to do so.

(a) Select Application you want to integrate

Click on the plus button next to the iterator window. Then, pick the ‘JSON Extractor’ app. Also, select the ‘Extract JSON Data’ option from the ‘Action Event’ drop-down.

Lastly, click ‘Connect with JSON Extractor’.

(b) Map Iterator Response

Map the iterator response with the ‘Data’ field of the JSON extractor.

To map a value from the previous trigger/event’s response, click on the menu icon (three horizontal lines) next to a field.

Then, click select the Iterator response.

(c) Check and Save JSON Extractor Response

Check and save the JSON response.

Step 8: Add Date Time Formatter

Now, all the data is available for sending a message from the automation. We can now simply apply a condition to compare the current date with the person’s birthdate. But, to compare two values that must be into the same format.

(a) Select Application you want to integrate

Now, integrate a Date/time Formatter for formatting the current date. To do so, simply select the ‘Date/time Formatter’ in the Choose App drop-down and ‘Current Date’ option from the Action Event drop-down.

Lastly, click on the ‘Connect with Date/Time Formatter’ button.

(b) Select Date Format & Send Test Request

After connecting with the Date/Time Formatter, select a format for your current date to convert into.

Keep the ‘Include time in response’ field value as ‘False’ and click on ‘Save & Send Test Request’ button.

(c) Format the Birthdate

Now, integrate the Date/time Formatter for the birthdate. For this select the ‘Format Date Only’  event rest of the procedure is similar to the current date.

(d) Map the Birthdate

Map the birthdate from the JSON Extractor response.

Step 9: Compare Current Date with Birthdate

Now, as both the dates are in the same format. We can apply a comparison between them. So first lest split the date in day and month.

(a) Select Application you want to Integrate

Select the ‘Text Formatter’ app from the Choose App drop-down and ‘Split Text’ option from the ‘Action Event’ options. Click on ‘Connect with test Formatter.

(b) Map Current Date, Place Separator Value & Send Test Request

We want to separate the date value from the ‘/’ separator that why first, we’ll map the formatted current date in the ‘text to Split’ field. Next, place a ‘/’ symbol in the separator field and the ‘All’ option from the Segment Index options.

Lastly, click on the ‘Save & Send Test Request’ button.

Save the formatted response and repeat this step for the birthdate as well.

(c) Select Application you want to Integrate

For sending a wish on the birthday first let’s compare the dates. For this, integrate a filter.

(d) Map Values for Comparision

When you choose the filter option from the choose app field options. A value comparison will become visible. Map the current day with the birthday and the current month with the birth month along with the condition in between as ‘Equal To’.

Lastly, click the ‘Save & Send Test Request’ button.

Step 10: Setting Action for Google Sheets to Whatsapp Integration

Now, as we have gathered all the data to send birthday wishes on WhatsApp from Google Sheets. We can proceed to use this data to perform our action. After that, a message will be auto-sent on WhatsApp for every person listed on your spreadsheet.

(a) Select Application you want to Integrate

Now, we’ll use the ‘Chat API’ to send a WhatsApp message. So, select the ‘Chat API’ option from the Choose App drop-down. Also, select the event as ‘Send File’ and then click on ‘Connect with Chat API’.

(b) Copy Chat API URL & Token

Further, go to your Chat API account and copy the API URL and token.

(c) Paste API URL & Token

Paste the copied API URL and token in the Pabbly Connect connection window.

(d) Map the Required Fields & Message Body

Map all the required fields such as phone number, event and caption. Also, draft a message using the response value and plan test.

Finally, click ‘Save’ to save the action API’s response.

Step 11: Check Response in WhatsApp

Also, you can check the birthday wish on Whatsapp.