Sync AWS billing invoices with FreeAgent and PostgreSQL tracking

by Pernille-AI · 66 views · created 2026-01-06 · Invoice Processing

What this workflow does

This workflow has 14 nodes and runs on a schedule (cron 30 0 3,4 * *). Along the way it connects Postgres. It also calls api.freeagent.com over HTTP.

How it runs

Trigger: On a schedule (cron 30 0 3,4 * *).

1. Calculate Last Month Date Range (Code): runs custom JavaScript code
2. Generate AWS Signature (Code): runs custom JavaScript code
3. Call AWS For Bills (HTTP Request): calls an HTTP API (POST)
4. Parse AWS Response (Code): runs custom JavaScript code
5. Filter By Date (Code): runs custom JavaScript code
6. Loop Over Invoices (Loop Over Items (Split in Batches)): loops over the items in batches
7. Check If Already Processed (Postgres): run a query
8. If: checks a condition and branches into true / false
9. Prepare FreeAgent Bill (Code): runs custom JavaScript code
10. Create FreeAgent Bill (HTTP Request): calls api.freeagent.com (POST)

…plus 3 more steps. See the full node list below.

Services it uses

Postgres

HTTP calls to: api.freeagent.com

Before you upgrade to n8n 3.0

Nodes used (6)

• Coden8n-nodes-base.code
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Postgresn8n-nodes-base.postgres
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Schedule Triggern8n-nodes-base.scheduleTrigger

From the author

Automatically retrieve AWS invoices and create corresponding bills in FreeAgent, marking them as paid. This workflow eliminates manual data entry for AWS billing. What It Does 1. Fetches invoices from AWS Invoicing API for the previous month 2. Filters…

View the original on n8n.io → Check your own copy