Data merging mechanism

This automation simplifies data integration coming from two different systems. Although the datasets differ in structure and level of detail, they share common core attributes. The process takes this data, generated by a common service and intended for banking institutions, standardizes it into a single format, removes incompatible fields, and outputs it into a centralized database such as Google Sheets or Airtable. Throughout the process, service-specific constraints were followed to ensure no disruptions to existing workflows.