Templates / Track SaaS spend from email invoices with AgentMail, JigsawStack and Postgres

Track SaaS spend from email invoices with AgentMail, JigsawStack and Postgres

Unknown

by Stephan Koning ✓ · 28 views · created 2026-04-12 · Invoice Processing, AI Summarization

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This workflow has 49 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Postgres and Redis Advanced (community). It also calls api.cloud.llamaindex.ai and api.jigsawstack.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).

Configure Extensions & Triggers (Postgres): run a query
Extract Attachment Payload (Code): runs custom JavaScript code
Download Email Attachment (HTTP Request): calls an HTTP API
Configure Enumerations (Postgres): run a query
Acquire Pipeline Job (Postgres): run a query
Download PDF File (HTTP Request): calls an HTTP API
Set Up Vendors Table (Postgres): run a query
Parse Acquire Result (Code): runs custom JavaScript code
Upload PDF to LlamaCloud (HTTP Request): calls api.cloud.llamaindex.ai (POST)
Set Up Documents Table (Postgres): run a query

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

Services it uses

PostgresRedis Advanced (community)

HTTP calls to: api.cloud.llamaindex.ai, api.jigsawstack.com

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Check that @franknitty69/n8n-nodes-redis-advanced is verified or supports 3.0 (used in Redis Advanced Processing).

Nodes used (13)

HTTP Requestn8n-nodes-base.httpRequest
Switchn8n-nodes-base.switch
Postgresn8n-nodes-base.postgres
Webhookn8n-nodes-base.webhook
Coden8n-nodes-base.code
Ifn8n-nodes-base.if
Execute Sub-workflown8n-nodes-base.executeWorkflow
Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
Waitn8n-nodes-base.wait
Manual Triggern8n-nodes-base.manualTrigger
Stop and Errorn8n-nodes-base.stopAndError
Redis Advanced@franknitty69/n8n-nodes-redis-advanced.redisAdvanced
Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger

From the author

WHAT you need 1. Jigsaw API key for image processing, I use this as a gatekeeper/second pair of eyes. 3. LINK to their website https://jigsawstack.com/ 6. SECOND A postgress DATABASE (I use Supabase) 8. LlamaCloud for the parsing (you can replace this with…
Excerpt from Stephan Koning's description on n8n.io.

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

Track SaaS spend from email invoices with AgentMail, JigsawStack and Postgres

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (13)

From the author

Get the weekly “what broke” email