Financial reporting on n8n: bank APIs, Google Sheets, Airtable

Goal: Automate the aggregation of financial data from two API sources (bank simulation) and synchronize them with Google Sheets and Airtable for further analysis and reporting.

Contribution: Created a workflow in n8n. It retrieves data from two Mockaroo APIs, combines, edits, and transforms them. One branch of the process cyclically processes and writes/updates data in Google Sheets. The other branch limits the number of records, aggregates them, and sends them to Airtable via PATCH HTTP request for updating/creating records.

Success: The prototype demonstrates n8n's ability to efficiently collect, process, and distribute data between different services, ensuring their relevance in Google Sheets and Airtable.