Bank Account Formulas in Google Sheets™
Pull bank and transaction data directly into Google Sheets™ using custom formulas
Google Sheets™ Extension
Finicom provides custom formulas for Google Sheets™ that allow you to pull financial data directly into your spreadsheets via an Extension. These formulas enable real-time access to your accounts, balances, and transactions data.
Please note that these formulas are coming soon and not yet available.
Setup
- Open your Google Sheet
- Click on the "Finicom" menu at the top
- Select "Add Finicom API Key"
- Enter your API key from the Finicom Dashboard
Available Formulas
- FINICOM_GET_ACCOUNTS - List all connected accounts
- FINICOM_GET_ACCOUNT - Get details for a specific account
- FINICOM_GET_TRANSACTIONS - Fetch transaction data
Troubleshooting
If you encounter any issues:
- Verify your API key is correctly set up via the Finicom menu
- Check that your account IDs are valid
- Ensure your formulas are using the correct parameter formats
- If needed, you can remove and re-add your API key through the Finicom menu
For additional support, contact us at [email protected].