This package performs a simple sync between the data in our database with the Horizon CRM Airtable.
It fetches all the projects from the database including the fields that other teams would use in reaching out to those projects and for improving the platform by making (data) educated decisions for focuses and changes.
The flow is simple:
- Connect to the database
- Query all the projects
- Map the project data to the fields wanted by the CRM users
- Send the data in batches of 10 to the Airtable with typecasting enabled and with the merge field being the project's account ID - source