Automate cross-border tax compliance with Google Sheets, PostgreSQL and Slack alerts

by Cheng Siong Chin ✓ · 53 views · created 2025-12-17 · Invoice Processing, AI Summarization

What this workflow does

This workflow has 23 nodes and runs on a schedule (every day at 02:00). Along the way it connects Gmail, Google Drive, Postgres and Slack.

How it runs

Trigger: On a schedule (every day at 02:00).

1. Workflow Configuration (Edit Fields (Set)): sets 11 fields: revenueApiUrl, taxConsultantEmail, auditFolderId…
2. Fetch Revenue Transactions (HTTP Request): calls an HTTP API
3. Retrieve Historical Tax Data (Postgres): run a query
4. Extract Transaction Data (Edit Fields (Set)): sets 6 fields: transactionId, country, revenue…
5. Split Transactions for Processing (Split Out): splits a list into separate items
6. Merge Historical Trends (Edit Fields (Set)): sets 3 fields: historicalData, currentMetrics, comparisonPeriod
7. Identify Tax Obligations by Country (Code): runs custom JavaScript code
8. Filter: keeps only the items that match a condition
9. Generate Predictive Tax Forecast (Code): runs custom JavaScript code
10. Apply Tax Rules by Jurisdiction (Code): runs custom JavaScript code

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

Services it uses

GmailGoogle DrivePostgresSlack

Before you upgrade to n8n 3.0

Nodes used (13)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Aggregaten8n-nodes-base.aggregate
• Gmailn8n-nodes-base.gmail
• Google Driven8n-nodes-base.googleDrive
• Filtern8n-nodes-base.filter
• Ifn8n-nodes-base.if
• Postgresn8n-nodes-base.postgres
• Summarizen8n-nodes-base.summarize
• Slackn8n-nodes-base.slack
• Split Outn8n-nodes-base.splitOut

From the author

How It Works This workflow automates the complete end-to-end processing of daily revenue transactions for finance and accounting teams. It systematically retrieves, validates, and standardizes transaction data from multiple sources, computes applicable tax…

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