A repeatable alternative to CSV uploads
If you repeatedly download brokerage transactions, upload them to Google Sheets, and clean up the columns, a saved import can reduce that work. Brokerage Connect reads available activity from your connected SnapTrade accounts and writes it into a consistent table.
You initiate the import and later refresh it from the sidebar. No custom Apps Script code is required, and the add-on does not run scheduled background imports.
1. Choose Activities for transaction history
Select Activities, choose your accounts, and set inclusive start and end dates. Optional activity-type filters let you narrow the request. Begin with a manageable window and preview the data before writing it into your spreadsheet.
The default destination is ST_Activities. It includes account and institution context plus available activity ID, type, symbol, currency, amount, units, price, fee, trade date, settlement date, and description.
2. Understand Activities versus Orders
| Dataset | Use it for | Filter |
|---|---|---|
| Activities | Reported transactions, dividends, deposits, fees, and other returned activity | Start/end dates; optional types |
| Orders | Recent order status and execution details where available | All, open, or executed; 1–90 days |
An open order is not a completed transaction. Do not append Orders to Activities and count the combined rows as a trade ledger.
3. Filter the imported table
For example, put this formula in an analysis tab to inspect USD activity dates, types, symbols, amounts, and descriptions:
=QUERY(ST_Activities!A1:U, "select Q,E,F,I,S where G = 'USD'", 1)Q is trade_date, E is type, F is symbol, I is amount, and S is description. Change the currency filter to match your data. This view uses numeric amounts; the source table also retains exact values.
4. Refresh without repeatedly appending rows
The add-on replaces the managed activity window on refresh. That prevents repeated refreshes from simply appending the same window again. It also means source-table notes or manually appended history are not a durable journal: keep them in a separate tab.
Activity IDs may change when the provider reprocesses data. If you maintain your own longer-term archive, inspect overlaps and changes rather than assuming IDs will always stay fixed.
What about CSV exports and older history?
This add-on imports from SnapTrade, not from uploaded CSV files. A brokerage export may contain older history or specialized fields that the connection does not expose. Keep those reports separately if you need them; selecting a wider date range cannot create unavailable records.
For a specific connection, start with the brokerage setup guides. Data coverage and freshness depend on the account and provider.