Sure! This is the big picture:
We do receive a lot of Facebook Ads Leads. We have the details for name, telephone and Email. We might have 50 new contacts everyday. These 50 new contacts need to be phoned and after that followed.
So, in order to make things easier, we want to have the new thirds information introduced automatically into the dolibarr database.
We have the option for a daily “manual” importation, but we would prefer to do it automatically, for example, each time a new leads is added in facebook.
We are currently exporting some information from our thirds to Mailchimp automatically using “integromat” service and SQL queries. Right now we would like to try something similar but in “reverse” way: Instead of exporting the data, doing an importation directly to the dolibarr DB.
The “steps” would be:
- New lead is created in facebook.
- Integromat receives the info and syncs with dolibarr DB.
- An SQL query or command is used, to introduce automatically the lead info into dolibarr DB.
As soon as we don´t want to corrupt the dolibarr DB, we would like to know if there is any problem adding new “thirds” using SQL. Might affect the DB structure? Should we take care of any ID? Focus on special table?
Any advise would be appreciate.