UrlFetchApp + Excel 365 Office Scripts
Add a 1-Click 🏦 Generate Bank File Menu Inside Google Sheets & Excel 365
Stop fighting broken Excel VBA macros, stripped leading zeros, and manual CSV exports. Generate custom Google Apps Script (Code.gs) and Microsoft Excel 365 Office Scripts (TypeScript) tailored to your exact columns—and save bank-verified SEPA XML, US NACHA (.ach), UK BACS 18, Australian .ABA, Canadian CPA-005, or DATEV EXTF files straight to Google Drive or SharePoint for $0/month.
Code.gs) — Saves Directly to Google Drive
.ts) + Power Automate HTTP Spec
60-Second Setup Guide (Zero Servers, Zero Monthly Subscriptions)
1. Install in Google Sheets
- Open your Google Sheet and click Extensions → Apps Script.
- Paste the generated
Code.gsabove and click Save. - Click Project Settings (⚙️) → Script Properties and add
APIFY_TOKEN= your token from Apify Console (includes $5/month free credit). - Reload your Google Sheet: click 🏦 FinOps Bank Files → Generate Bank File to Drive!
2. Install in Microsoft Excel 365
- Format your payment rows as an Excel Table (
Ctrl + T) and format routing/BSB/account columns as Text so leading zeros stay intact. - Open Automate → New Script in Excel 365 and paste the TypeScript Office Script above.
- In Power Automate, add Excel Online → Run script followed by HTTP POST to the synchronous endpoint shown in the comment header, then Create file in SharePoint/OneDrive.
3. Why Finance Teams Prefer API Macros
- Leading-Zero Protection: Reads cells via
getDisplayValues()/getTexts()so021000021(Chase ABA) or003(RBC Institution) never turns into21000021or3. - Pre-Flight Checksums: Rejects bad IBAN MOD-97, ABA MOD-10, UK Sort Codes, or missing 2026 SEPA structured addresses before creating a file.
- $0/Mo Fixed Cost: Pay $0.02/row ($0.03 start)—up to ~248 payroll rows every month are $0.00 on Apify's free tier.
Related Pre-Flight Validators & Banking Format References
1-Click Browser CSV / Excel Column Mapper
Want to convert a spreadsheet right now without installing a script? Paste Excel or CSV rows directly in your browser and download your bank file.
Make.com, Zapier & Power Automate Blueprints
Download ready-to-import Make.com and n8n JSON workflows connecting Airtable, Google Sheets, Stripe, and SharePoint to all 9 live APIs.
5-Country Global Payroll Bank File Router
Pay employees across the US (NACHA), Europe (SEPA), UK (BACS 18), Australia (.ABA), and Canada (CPA-005) from a single unified HRIS table.