Callback to google sheet parameter

[_aMiCiCi_]

Hello guys, I would need to carry out a call back of the contacts present on google sheet which are added in real time with the cfd.
Do you have any suggestions how I can create this specific function?

In a nutshell, I receive the lead from external sources, I insert it on google sheet and immediately the call must start.

Please help me on the forum I couldn't find any threads about it.

Joseph

 

[edossantos]

I'm not sure what API you can use to read the google sheet. This looks like a dialer, that needs to get the numbers to call from that spreadsheet. You can check these guides:
https://www.3cx.com/docs/cfd-creating-outbound-dialer/
https://www.3cx.com/docs/cfd-predictive-dialer/

But you will need to get the numbers to call from a different place..... If you don't find a suitable API which you can invoke from the CFD, something you might try is adding that data to a database instead, and then the CFD app can query the database.

 

[Evolute IT]

You might want a PHP script of some sort between the CFD and the Google Docs API for Sheets. Much easier to control/process the data.

 

[VoIPTools]

I do not know what programming resources you have available, but I would create a web interface for managing your contacts. When you add a new contact, have the web application perform the following steps:

1. Save the data to Google
2. Make the phone call using our REST API.

MakeCall is one of our free APIs that does not require a license.

 

[_aMiCiCi_]

@edossantos
II think I understand what you mean, I insert data into a database by assigning a specific tag and then theoretically route the call, do you have a more practical example of cfd for subsequent actions beyond the database call?

@VoIPTools
Could you also privately send me the link of your free MakeCall service?

So I can have a look at the service?

I haven't figured out how to put the data online.

Do you mean a hidden web page and bring up the page?

Thank you
------

I have no problems putting and recalling data in the database or google sheet, what is not yet clear to me is how to route the outgoing call of the cfd even seeing the demo examples which however all point to local csv.

 

[edossantos]

@edossantos
II think I understand what you mean, I insert data into a database by assigning a specific tag and then theoretically route the call, do you have a more practical example of cfd for subsequent actions beyond the database call?

Here you have many CFD examples, for different purposes:
https://www.3cx.com/docs/manual/call-flow-designer-manual/