CTWA ads phone numbers to google sheets

[Prashanth]

Hi,

I need help building automation with pabbly involving CTWA ads, wati & Google sheets.

We run CTWA ads (click to WhatsAPP ads) on Meta - both facebook and Instagram. Now, when a lead clicks the WhatsApp button on the ads, it will open their personal WhatsApp and sent the pre defined templated message to the our business number. We are using WATI CRM to manage the business WhatApp and the messages ppear in our WATI inbox.

Our requirement is to receive the CTWA leads names and phone numbers on a Google sheet - similar to how pabbly fetches the Facebook form leads to Google sheets. Please guide on how to build this automation using pabbly.

 

[ArshilAhmad]

Hi @Prashanth,

Are you using WATI to capture the CTWA leads?

 

[Prashanth]

Hi @Prashanth,

Are you using WATI to capture the CTWA leads?

yes, we are using WATI to capture CTWA leads

 

[ArshilAhmad]

I assume the leads are added as contacts to your WATI account. If so, you can set up WATI as your trigger step by following the steps in the video shared below.

Watch the video shared below to understand how you can set up Google Sheets as your action application for adding data.