Banking to Google Sheets

Automatically Export & Sync Banking Data to Google Sheets

Banking
a black arrow pointing to the right
Google Sheets
Full data sets
No instructions needed
No code
No complicated flow charts
No triggers
Set up in under 3 minutes
Flat pricing starting at $19 /month

Data sets

Balances
Balances-Recent
Transactions-AllAvailable
Transactions-Last X days
Date Rangable
InvestmentTransactions-All
InvestmentTransactions-Last X days
Date Rangable
InvestmentHoldings
InvestmentHoldings+RealtimeStocks
Pre-blended combo set Stock Prices [ Premium Data Set | Plaid + Marketstack | Flatly Exclusive ]
Liabilities-Credit
Liabilities-Mortgage
Liabilities-Student

Built for Synchronization

This service is designed to help anyone continuously export (i.e. "sync") bulk data from Banking.

If you only need to export your data one time, check the website of Banking to see if their service offers a one-time export feature natively. Sometimes a Data Source's native export feature may provide not as much data as its API does, in which case Flatly is the solution.

Additional Information

Flatly uses official API channels to provide an integration with Banking.
Flatly connects to over 10,000 financial institutions in the US and Canada via Plaid.
Scopes

Flatly's access to Plaid and Plaid's downstream connected financial institutions is read-only access to text. It is limited to account data (words, numbers, dates). It does not include any money-movement, transfer capabilities or account holder profiles/identities.

Plaid alone interfaces directly with financial institutions, caches data from those institutions on Plaid infrastructure, and then makes the appropriate scoped subset of that data available to partners like Flatly using secure connections called client libraries.

Scopes

Flatly provisions and manages its own App Folder in Google Drive, which contains Google Sheets files, CSV files or XLSX files refreshed by Flatly. Flatly only has access to this one folder. This folder is like an isolated container that you can move anywhere inside your Google Drive, share with members of your team or link to using Google Sheets scripting. Unlike other apps, Flatly does not request overly broad access to all folders, files and sheets in your Google Drive.

Flatly also requests your Google Account email address, to help you keep track of which Google Drive (belonging to which Google Account) you have shared in certain sync jobs in Flatly.

Google Data Studio reads Google Sheets files in Google Drive directly. Google Sheets provides powerful filtering and views.

File Formats

Google Sheets (Parsed)
Google Sheets (Raw)
XLSX (Parsed)
XLSX (Raw)
CSV File

Integration Flow

Setup

Step 1

Select Banking from the Data Source dropdown and Google Sheets from the Data Destination dropdown.

Step 2

Authorize Banking with your credentials using the Plaid (OAuth) flow.

Step 3

Authorize Google Sheets with your credentials using the OAuth flow.

Step 4

Select your Data Set from the 11 Data Sets available using the dropdown.

Step 5

Click Flatten to sync your data.

Walkthrough Video

Extended Data Sources

L.C.E. Credit Union (Plaid) Transactions, Balances
Levro (Plaid) Transactions, Balances
Lili (Plaid) Transactions, Balances
Lincoln Federal Savings Bank of Nebraska (Plaid) Transactions, Balances
Lincoln Savings Bank (IA) - Online Banking (Plaid) Transactions, Balances
Local Government Federal Credit Union (Plaid) Transactions, Balances
Lake Michigan Credit Union - Personal and Business (Plaid) Transactions, Balances
Lake Michigan Credit Union - Business Plus (Plaid) Transactions, Balances
Langley Federal Credit Union - Personal (Plaid) Transactions, Balances
Landmark Credit Union (Plaid) Transactions, Balances
Lone Star National Bank (Plaid) Transactions, Balances
Liberty Bank (CT) - Cash Management (Plaid) Transactions, Balances
Liberty Bank (CT) - Personal (Plaid) Transactions, Balances
L&N Federal Credit Union (Plaid) Transactions, Balances
Launch Credit Union (Plaid) Transactions, Balances
LGE Community Credit Union (Plaid) Transactions, Balances
Lake Trust Credit Union - Personal (Plaid) Transactions, Balances
Leaders Credit Union (Plaid) Transactions, Balances
Listerhill Credit Union (Plaid) Transactions, Balances
LAFCU (Plaid) Transactions, Balances
Louisiana Federal Credit Union (Plaid) Transactions, Balances
Liberty Federal Credit Union (Plaid) Transactions, Balances
Logix Federal Credit Union (Smarter Banking) (Plaid) Transactions, Balances
La Capitol Federal Credit Union (Plaid) Transactions, Balances
LendingClub - Commercial (Plaid) Transactions, Balances
LendingClub - Personal & Business (Plaid) Transactions, Balances
Lake City Bank - Personal (Plaid) Transactions, Balances
Los Angeles Federal Credit Union (Plaid) Transactions, Balances
Lebanon Federal Credit Union (Plaid) Transactions, Balances
LCNB National Bank (Plaid) Transactions, Balances
Lowe's Consumer Credit Card (Plaid) Transactions, Balances
Legend Bank (Plaid) Transactions, Balances
Lyons National Bank (Plaid) Transactions, Balances
Legacy Bank (Plaid) Transactions, Balances
Liberty First Credit Union (Plaid) Transactions, Balances
Lakeland Bank - Consumer (Plaid) Transactions, Balances
LA Financial Credit Union (Plaid) Transactions, Balances
L.A. Electrical Workers Credit Union (Plaid) Transactions, Balances
L.E.S. Credit Union (Plaid) Transactions, Balances
L.I.U.N.A. Local 183 Credit Union - Online Banking (Plaid) Transactions, Balances
LA Healthcare Federal Credit Union (Plaid) Transactions, Balances
La Joya Area Credit Union (Plaid) Transactions, Balances
La Loma Federal Credit Union (Plaid) Transactions, Balances
La Salle State Bank (Plaid) Transactions, Balances
LA Schools Credit Union (Plaid) Transactions, Balances
Labette Bank (Plaid) Transactions, Balances
Ladysmith & District Credit Union (Plaid) Transactions, Balances
Ladysmith Federal Savings and Loan (Plaid) Transactions, Balances
Lafayette Federal Credit Union (Plaid) Transactions, Balances
Lafayette Life Insurance Company (Plaid) Transactions, Balances
Lafayette State Bank (Plaid) Transactions, Balances
LaHave River Credit Union (Plaid) Transactions, Balances
Lake Area Bank - Business (Plaid) Transactions, Balances
Lake Area Bank (Plaid) Transactions, Balances
Lake Chem Community Credit Union (Plaid) Transactions, Balances
Lake City Bank - Credit Cards (Plaid) Transactions, Balances
Lake City Federal Savings and Loan Association - Personal (Plaid) Transactions, Balances
Lake Community Bank (Plaid) Transactions, Balances
Lake Community Bank - Business (Plaid) Transactions, Balances
Lake County Educational Credit Union (Plaid) Transactions, Balances
Lake Elmo Bank (Plaid) Transactions, Balances
Lake Forest Bank & Trust Company N.A. - .COMmunity Banking (Plaid) Transactions, Balances
Lake Forest Bank & Trust Company N.A. - iBusiness Banking (Plaid) Transactions, Balances
Lake Huron Credit Union (Plaid) Transactions, Balances
Lake Region Bank (Plaid) Transactions, Balances
Lake Ridge Bank - Business (Plaid) Transactions, Balances
Lake Shore Savings (Western NY) - Personal (Plaid) Transactions, Balances
Lake State Credit Union (Plaid) Transactions, Balances
Lake Sunapee Bank (Plaid) Transactions, Balances
Lake Trust Credit Union - Business (Plaid) Transactions, Balances
Lake View Credit Union (Plaid) Transactions, Balances
Lake-Osceola State Bank (Plaid) Transactions, Balances
Lakeland Credit Union - Personal (Plaid) Transactions, Balances
Lakeshore Federal Credit Union (Plaid) Transactions, Balances
Lakeside Bank (Plaid) Transactions, Balances
Lakeside Bank (LA) - Mobile Banking (Plaid) Transactions, Balances
Lakeside Bank (TX) (Plaid) Transactions, Balances
Lakeside National Bank (Plaid) Transactions, Balances
Lakeside State Bank (Plaid) Transactions, Balances
Lakeview Bank (Plaid) Transactions, Balances
Lakeview FCU (Plaid) Transactions, Balances
Lakota Federal Credit Union (Plaid) Transactions, Balances
Lamar Bank and Trust Company (Plaid) Transactions, Balances
Lamar National Bank - Personal (Plaid) Transactions, Balances
Lamesa National Bank (Plaid) Transactions, Balances
Lampco Federal Credit Union (Plaid) Transactions, Balances
Lan-Fair Federal Credit Union (Plaid) Transactions, Balances
Lance (Plaid) Transactions, Balances
Lanco Federal Credit Union (Plaid) Transactions, Balances
Land of Lincoln Credit Union (Plaid) Transactions, Balances
Landings Credit Union (Plaid) Transactions, Balances
LANDMARK BANK - FT. Lauderdale, FL (Plaid) Transactions, Balances
Landmark Bank (Plaid) Transactions, Balances
Landmark Bank (Plaid) Transactions, Balances
Landmark Community Bank (Plaid) Transactions, Balances
Landmark National Bank - Personal (Plaid) Transactions, Balances
Landmark National Bank - Business (Plaid) Transactions, Balances
Lands End Credit Card (Plaid) Transactions, Balances
Lane Bryant Card (Plaid) Transactions, Balances
Lanier Federal Credit Union (Plaid) Transactions, Balances
Lantern Investments (Plaid) Transactions, Balances
Laona State Bank (Plaid) Transactions, Balances
LaPorte Community Credit Union (Plaid) Transactions, Balances
Laramie Plains Community Credit Union (Plaid) Transactions, Balances
Laredo Federal Credit Union (Plaid) Transactions, Balances
Las Colinas Credit Union (Plaid) Transactions, Balances
LaSalle St Securities LLC - Streetscape (Plaid) Transactions, Balances
LaSalle Trust Services (Plaid) Transactions, Balances
Lassen County Credit Union (Plaid) Transactions, Balances
Latah Federal Credit Union (Plaid) Transactions, Balances
Latitude 32 Credit Union (Plaid) Transactions, Balances
Lauderdale County Teachers Credit Union (Plaid) Transactions, Balances
Laurel Road - MOHELA (Plaid) Transactions, Balances
Laurel Road (Plaid) Transactions, Balances
Laurentian Bank (Plaid) Transactions, Balances
Laurentian Credit Card (Plaid) Transactions, Balances
Lawrence Memorial Hospital Employees Credit Union (Plaid) Transactions, Balances
Lazard - 401k Access (Plaid) Transactions, Balances
LBPS Mortgage (Plaid) Transactions, Balances
LBS Financial Credit Union (Plaid) Transactions, Balances
Lea County State Bank (Plaid) Transactions, Balances
Lead Bank - Personal (Plaid) Transactions, Balances
Lead Bank - Business (Plaid) Transactions, Balances
Leadco Community Credit Union (Plaid) Transactions, Balances
Leader Bank - Personal (Plaid) Transactions, Balances
Leader Bank - eBusiness (Plaid) Transactions, Balances
LeaderOne Financial (Plaid) Transactions, Balances
Leaders Bank (Plaid) Transactions, Balances
Leading Edge (Plaid) Transactions, Balances
Leading Edge Credit Union (Plaid) Transactions, Balances
Lear Link Online (Plaid) Transactions, Balances
Learning Quest 529 - Individual Investors (Plaid) Transactions, Balances
Learnvest (Plaid) Transactions, Balances
Leatherstocking Credit Union (Plaid) Transactions, Balances
Ledyard National Bank (Plaid) Transactions, Balances
Lee Bank (Plaid) Transactions, Balances
Lee Bank and Trust Company (Plaid) Transactions, Balances
Lee County Bank (Plaid) Transactions, Balances
Legacy Bank (Florida) - Personal (Plaid) Transactions, Balances
Legacy Bank (Florida) - Business (Plaid) Transactions, Balances
Legacy Bank (Iowa) (Plaid) Transactions, Balances
Legacy Bank (Kansas) (Plaid) Transactions, Balances
Legacy Bank and Trust (Missouri) (Plaid) Transactions, Balances
Legacy Credit Union (Plaid) Transactions, Balances
Legacy National Bank (Arkansas) - Personal (Plaid) Transactions, Balances
Legacy National Bank (Arkansas) - Business (Plaid) Transactions, Balances
Legacy Private Trust (Plaid) Transactions, Balances
Legacy State Bank (Plaid) Transactions, Balances
Legal Community Credit Union of Colorado (Plaid) Transactions, Balances
Legence Bank (Plaid) Transactions, Balances
Legendary Pine Mastercard (Plaid) Transactions, Balances
Legends Bank - Personal (Plaid) Transactions, Balances
Legends Bank - Business (Plaid) Transactions, Balances
Legends Bank of Missouri (Plaid) Transactions, Balances
Legent Clearing - Client Login (Plaid) Transactions, Balances
Legg Mason - 401K (Plaid) Transactions, Balances
Legg Mason Investment Counsel (Portfolio Online) - Client Access (Plaid) Transactions, Balances
Lehigh Valley Educators Credit Union (Plaid) Transactions, Balances
Leidos Your Retirement Center (Plaid) Transactions, Balances
Leighton State Bank (Plaid) Transactions, Balances
Lena State Bank (Plaid) Transactions, Balances
Lenco Credit Union (Plaid) Transactions, Balances
Lending Point (Plaid) Transactions, Balances
Lendmark Financial (Plaid) Transactions, Balances
LendUp (Plaid) Transactions, Balances
Lennox Employees Credit Union (Plaid) Transactions, Balances
Leominster Credit Union (Plaid) Transactions, Balances
LeRoy Federal Credit Union (Plaid) Transactions, Balances
Lesco Federal Credit Union (Plaid) Transactions, Balances
Letort Trust - Trust Accounts (Plaid) Transactions, Balances
Letort Trust - Retirement Access (Plaid) Transactions, Balances
LeTourneau Credit Union (Plaid) Transactions, Balances
Letter (Plaid) Transactions, Balances
Level One Bank - Personal (Plaid) Transactions, Balances
Levitz Furniture - Credit Card (Plaid) Transactions, Balances
Levo Credit Union (Plaid) Transactions, Balances
Lewis & Clark Bank (Plaid) Transactions, Balances
Lewis Clark Credit Union (Plaid) Transactions, Balances
Lexicon Bank - Business (Plaid) Transactions, Balances
Lexicon Bank - Personal (Plaid) Transactions, Balances
Lexus Pursuits Visa (Plaid) Transactions, Balances
LG&W Federal Credit Union (Plaid) Transactions, Balances
Liberty Bank (CA) - Personal (Plaid) Transactions, Balances
Liberty Bank (Plaid) Transactions, Balances
Liberty Bank (Minnesota) - Personal (Plaid) Transactions, Balances
Liberty Bank (Alabama) (Plaid) Transactions, Balances
Liberty Bank (Minnesota) - Business (Plaid) Transactions, Balances
Liberty Bank and Trust - Personal & Small Business Banking (Plaid) Transactions, Balances
Liberty Bank for Savings (Plaid) Transactions, Balances
Liberty Bay Bank (Plaid) Transactions, Balances
Liberty Bay Credit Union (Plaid) Transactions, Balances
Liberty Capital Bank (Addison,TX) (Plaid) Transactions, Balances
Liberty Capital Bank - Business (Plaid) Transactions, Balances
Liberty Global (LBTYA) (Plaid) Transactions, Balances
Liberty Global (LILA) (Plaid) Transactions, Balances
Liberty Global (LILAK) (Plaid) Transactions, Balances
Liberty National Bank (Plaid) Transactions, Balances
Liberty National Bank (Plaid) Transactions, Balances
Liberty National Bank (OK) - Personal (Plaid) Transactions, Balances
Liberty National Bank (OK) - Business (Plaid) Transactions, Balances
Liberty National Bank (Iowa) (Plaid) Transactions, Balances
Liberty National Life Insurance Company (Plaid) Transactions, Balances
Liberty Savings Bank - Personal (Plaid) Transactions, Balances
Liberty Savings Credit Union (Plaid) Transactions, Balances
Liberty Trust & Savings Bank (Plaid) Transactions, Balances
LibertyOne Credit Union (Plaid) Transactions, Balances
Libertyville Bank & Trust Company N.A. - iBusiness Banking (Plaid) Transactions, Balances
Libertyville Savings Bank (IA) (Plaid) Transactions, Balances
Library of Congress Federal Credit Union (Plaid) Transactions, Balances
Libro Credit Union - Online Banking (Plaid) Transactions, Balances
Libro Credit Union - Credit Card (Plaid) Transactions, Balances
Liccar CPA - Client Access (Plaid) Transactions, Balances
Life Credit Union (Plaid) Transactions, Balances
LiFE Federal Credit Union (Plaid) Transactions, Balances
Liferaft (Plaid) Transactions, Balances
LifeStore Bank (Plaid) Transactions, Balances
Lime Bank (Plaid) Transactions, Balances
Limestone Bank (Plaid) Transactions, Balances
Limestone Federal Credit Union (Plaid) Transactions, Balances
Lincoln Automotive Financial Services (Plaid) Transactions, Balances
Lincoln Benefit Life (Annuity) - Client Access (Plaid) Transactions, Balances
Lincoln County Credit Union (Plaid) Transactions, Balances
Lincoln Financial Advisors - MyStreetscape (Plaid) Transactions, Balances
Lincoln Financial Group (Plaid) Transactions, Balances
Lincoln Investment Planning (Plaid) Transactions, Balances
Lincoln National Bank (Hodgenville, KY) (Plaid) Transactions, Balances
Lincoln Park Community Credit Union (Plaid) Transactions, Balances
Lincoln Teachers Credit Union (Plaid) Transactions, Balances
Lincolnway Community Bank (Plaid) Transactions, Balances
Lindell Bank (Plaid) Transactions, Balances
Lineage Bank (Plaid) Transactions, Balances
Link Federal Credit Union (Plaid) Transactions, Balances
Linkage Credit Union (Plaid) Transactions, Balances
LINKBANK (Plaid) Transactions, Balances
Linn Area Credit Union (Plaid) Transactions, Balances
Linn County State Bank (Plaid) Transactions, Balances
Linn-Co Federal Credit Union (Plaid) Transactions, Balances
Lion's Share Federal Credit Union (Plaid) Transactions, Balances
Lisbon Community Federal Credit Union (Plaid) Transactions, Balances
Lisle Savings Bank (Plaid) Transactions, Balances
Litchfield Bancorp (Plaid) Transactions, Balances
Litchfield Bancorp - Business (Plaid) Transactions, Balances
Litchfield National Bank (Plaid) Transactions, Balances
Litman Gregory Masters Funds (Plaid) Transactions, Balances
Live Life FCU (Plaid) Transactions, Balances
LL Bean - Citi Card (Plaid) Transactions, Balances
Llano National Bank - Mobile Banking (Plaid) Transactions, Balances
LM Federal Credit Union (Plaid) Transactions, Balances
LMPeople - Client Access (Plaid) Transactions, Balances
LOC Credit Union (Plaid) Transactions, Balances
Local 520 UA Federal Credit Union (Plaid) Transactions, Balances
Local 697 Federal Credit Union (Plaid) Transactions, Balances
Local 804 Credit Union (Plaid) Transactions, Balances
Local Bank (Plaid) Transactions, Balances
Local Bank (Plaid) Transactions, Balances
Locality Bank (Plaid) Transactions, Balances
Lockton Deferred Compensation Plan (Plaid) Transactions, Balances
LOCO Credit Union (Plaid) Transactions, Balances
Locoga Federal Credit Union (Plaid) Transactions, Balances
Loeb Partners Corporation (Plaid) Transactions, Balances
Loft ALL Rewards (Comenity) - Credit Card (Plaid) Transactions, Balances
Loft ALL Rewards (Comenity) - Mastercard (Plaid) Transactions, Balances
Logan Bank & Trust (Plaid) Transactions, Balances
Logan County Bank (Plaid) Transactions, Balances
Logansport Savings Bank, FSB (Plaid) Transactions, Balances
Lone Star Bank (Plaid) Transactions, Balances
Lone Star Capital Bank (Plaid) Transactions, Balances
Lone Star Credit Union (Plaid) Transactions, Balances
Lone Star State Bank (West Texas) - Personal (Plaid) Transactions, Balances
LoneStar 529 Plan - Client Access (Plaid) Transactions, Balances
Long Beach City Employees Federal CU (Plaid) Transactions, Balances
Long Beach Firemen's Credit Union (Plaid) Transactions, Balances
Longview Bank (Plaid) Transactions, Balances
Lookout Credit Union (Plaid) Transactions, Balances
Lord Abbett - Regular Mutual Fund Account (Plaid) Transactions, Balances
LOreal USA Federal Credit Union (Plaid) Transactions, Balances
Lormet Community FCU (Plaid) Transactions, Balances
Los Alamos National Bank - eBanking (Plaid) Transactions, Balances
Los Angeles Kings Visa (Plaid) Transactions, Balances
Los Angeles Police Federal Credit Union (Plaid) Transactions, Balances
Los Angeles Unified School District (457b) (Plaid) Transactions, Balances
LouChem Federal Credit Union (Plaid) Transactions, Balances
Loudoun Credit Union (Plaid) Transactions, Balances
Louisiana 529 College Saving Program (Plaid) Transactions, Balances
Louisiana Catholic Federal Credit Union (Plaid) Transactions, Balances
Louisiana Central Credit Union (Plaid) Transactions, Balances
Louisiana National Bank (formerly First National Bank) - The Uncommon Bank (Plaid) Transactions, Balances
Louisiana USA Credit Union (Plaid) Transactions, Balances
Louviers Federal Credit Union (Plaid) Transactions, Balances
Lowell Firefighters Credit Union (Plaid) Transactions, Balances
Lowell Five Cent Savings Bank (Plaid) Transactions, Balances
Lowes Business Credit Center (Plaid) Transactions, Balances
Lowland CU(Morristown, TN) (Plaid) Transactions, Balances
Lowry State Bank (Plaid) Transactions, Balances
Loy Allen Visa (Plaid) Transactions, Balances
Loyalty Credit Union (Plaid) Transactions, Balances
LPL Financial (Plaid) Transactions, Balances
LT Retire (Plaid) Transactions, Balances
Luana Savings Bank (Plaid) Transactions, Balances
Lubbock National Bank (Plaid) Transactions, Balances
Lubrizol Employees Credit Union (Plaid) Transactions, Balances
Lumbee Guaranty Bank - Personal (Plaid) Transactions, Balances
Lume (Plaid) Transactions, Balances
Luminate Bank (Plaid) Transactions, Balances
Luminus Financial - Personal Banking (Plaid) Transactions, Balances
Lusitania Savings Bank (NJ) (Plaid) Transactions, Balances
LUSO Federal Credit Union (MA) (Plaid) Transactions, Balances
Luther Burbank Savings - Personal (Plaid) Transactions, Balances
Lutheran Church Extension Fund (Plaid) Transactions, Balances
Lutheran Federal Credit Union (Plaid) Transactions, Balances
Luzerne Bank (Plaid) Transactions, Balances
Lyndon Amick Visa (Plaid) Transactions, Balances
Lyndon State Bank (Plaid) Transactions, Balances
Lynnville National Bank (Plaid) Transactions, Balances
Lyon County State Bank (Plaid) Transactions, Balances
Lyons Federal Savings (Plaid) Transactions, Balances

Get started with your data pipelines

Connect your data with our turnkey data integration solution so you can focus on running your business.