Get Bank Account Information in Google Sheets™ using the FINICOM_GET_ACCOUNT formula

Get bank account information in Google Sheets™ using the FINICOM_GET_ACCOUNT formula in Finicom.

FINICOM_GET_ACCOUNT

The FINICOM_GET_ACCOUNT formula retrieves detailed information about a specific account connected to your Finicom account. It provides the same detailed information as FINICOM_GET_ACCOUNTS but for a single account.

Syntax

=FINICOM_GET_ACCOUNT(accountId, columns, includeHeaders)

Parameters

ParameterTypeRequiredDefaultDescription
accountIdstringYes-The unique identifier of the account
columnsstring[] or stringNoAll columnsArray of column names to include in output
includeHeadersbooleanNotrueWhether to include column headers as first row

Available Columns

  • Account ID - Unique identifier for the account
  • Institution - Name of the financial institution
  • Account Name - Display name of the account
  • Last 4 Digits - Last 4 digits of the account number
  • Account Type - Type of account (e.g., checking, savings)
  • Current Balance - Current balance in the account
  • Available Balance - Available balance that can be withdrawn
  • Currency - Currency code of the account
  • Last Updated - Timestamp of last account update

Examples

Basic Usage

Get all information for a specific account:

=FINICOM_GET_ACCOUNT("account_id")

Select Specific Columns

Get only balance information:

=FINICOM_GET_ACCOUNT("account_id", {"Account Name", "Current Balance", "Available Balance", "Currency"})

Without Headers

Get account information without header row:

=FINICOM_GET_ACCOUNT("account_id", {"Account Name", "Current Balance"}, FALSE)

Error Handling

The formula will throw an error if:

  • The specified account ID doesn't exist
  • The account ID is invalid
  • Any of the specified columns are invalid
  • The API key is not set up or is invalid

Tips

  • Use this formula when you only need information about one specific account
  • Column names are case-sensitive
  • The formula always returns a 1 or 2-row array (depending on includeHeaders)
  • Results are automatically updated when account information changes

Related