FSFinOps Studio
📗 Native Spreadsheet Add-In Cookbook • Google Sheets 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.

Open Live API on Apify →
Step 2 — Enter Your Originator / Company Header Defaults & Spreadsheet Column Letters:
Google Sheets Apps Script (Code.gs) — Saves Directly to Google Drive

        
Microsoft Excel 365 Office Script (.ts) + Power Automate HTTP Spec

        

60-Second Setup Guide (Zero Servers, Zero Monthly Subscriptions)

Google WorkspaceExtensions → Apps Script

1. Install in Google Sheets

  1. Open your Google Sheet and click Extensions → Apps Script.
  2. Paste the generated Code.gs above and click Save.
  3. Click Project Settings (⚙️) → Script Properties and add APIFY_TOKEN = your token from Apify Console (includes $5/month free credit).
  4. Reload your Google Sheet: click 🏦 FinOps Bank Files → Generate Bank File to Drive!
Excel 365 / WebAutomate → New Script

2. Install in Microsoft Excel 365

  1. Format your payment rows as an Excel Table (Ctrl + T) and format routing/BSB/account columns as Text so leading zeros stay intact.
  2. Open Automate → New Script in Excel 365 and paste the TypeScript Office Script above.
  3. 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.
Security & AuditZero Formula Drift

3. Why Finance Teams Prefer API Macros

  • Leading-Zero Protection: Reads cells via getDisplayValues() / getTexts() so 021000021 (Chase ABA) or 003 (RBC Institution) never turns into 21000021 or 3.
  • 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.