{"product_id":"daily-stripe-revenue-reconciliation-with-apogeoapi-sheets-slack-n8n","title":"Daily Stripe Revenue Reconciliation with ApogeoAPI, Sheets \u0026 Slack (n8n)","description":"\u003ch3\u003eReconcile yesterday’s Stripe revenue daily—convert FX with ApogeoAPI, log totals to Google Sheets, and alert Slack when anything looks off\u003c\/h3\u003e\n\u003cp\u003eIf you need a reliable \u003cstrong\u003eStripe revenue reconciliation workflow\u003c\/strong\u003e for multiple currencies, this n8n automation automatically totals yesterday’s successful charges, converts net revenue to a single reporting currency using \u003cstrong\u003eApogeoAPI\u003c\/strong\u003e exchange rates, and appends a dated summary to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e. When exchange rates are stale or charges can’t be converted, it sends a \u003cstrong\u003eSlack\u003c\/strong\u003e alert.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 09:00\u003c\/strong\u003e (or can be executed manually with sample data for testing).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls Stripe charges\u003c\/strong\u003e and keeps only \u003cem\u003esucceeded\u003c\/em\u003e charges created during the previous UTC day, \u003cstrong\u003enet of refunded amounts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches FX rates in one call\u003c\/strong\u003e from \u003cstrong\u003eApogeoAPI\u003c\/strong\u003e, using \u003cstrong\u003eUSD as the base\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConverts each charge\u003c\/strong\u003e into the reporting currency, including correct handling for \u003cstrong\u003ezero-decimal\u003c\/strong\u003e and \u003cstrong\u003ethree-decimal\u003c\/strong\u003e currencies, then aggregates totals by currency and computes a \u003cstrong\u003egrand total\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites a single reconciliation row\u003c\/strong\u003e to the Google Sheets \u003ccode\u003eReconciliation\u003c\/code\u003e tab with: date, totals, rate flags, and a \u003cstrong\u003ebreakdown JSON\u003c\/strong\u003e (plus any \u003cstrong\u003eunconverted charges\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack\u003c\/strong\u003e if exchange rates are marked stale or any charges could not be converted.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS finance ops that need daily \u003cstrong\u003emulti-currency Stripe reporting\u003c\/strong\u003e with FX conversions.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable \u003cstrong\u003ereconciliation pipeline\u003c\/strong\u003e using n8n and actionable alerts.\u003c\/li\u003e\n  \u003cli\u003eTeams that want an audit-friendly sheet row each day, including unconverted charges and FX status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/services: \u003cstrong\u003eStripe\u003c\/strong\u003e, \u003cstrong\u003eApogeoAPI\u003c\/strong\u003e (via \u003ccode\u003en8n-nodes-apogeoapi\u003c\/code\u003e), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2), \u003cstrong\u003eSlack\u003c\/strong\u003e, plus \u003cstrong\u003eif\u003c\/strong\u003e and \u003cstrong\u003ecode\u003c\/strong\u003e logic.\u003c\/li\u003e\n  \u003cli\u003eRequires: Stripe, ApogeoAPI, Google Sheets credentials, and Slack channel configuration (e.g., \u003ccode\u003e#finance\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003eSetup includes updating the Google Sheets document ID and ensuring the \u003ccode\u003eReconciliation\u003c\/code\u003e tab has the expected columns.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072079155379,"sku":"N8N-19794","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/q1pGbY5v39fCQzQCHtUBg_kS2jNGNS.png?v=1790068159","url":"https:\/\/buyflowscripts.com\/products\/daily-stripe-revenue-reconciliation-with-apogeoapi-sheets-slack-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}