Identify who was paid on every bank feed line
Researches each new line on a client's bank feed sheet and writes who was paid, what they do and where to post it, with sources.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
Try
- 1Google SheetsRead rowsReads the research tab to see which bank lines are already done, then the bank feed tab, checking it has a Description column, for each line's wording, date and amount.
If
done.headersis empty- 2Google SheetsAppend rowAppends one row per bank line to the research tab with what the verifier found, written exactly as given, or a 'Could not research' row when it failed.
- 2
If a step fails
- 3Google SheetsCreate tabCreates the 'Vendor research' tab with its sixteen headings on the first run, when the tab does not exist yet.
- 4Google SheetsAppend row
- 1
- 5Google SheetsRead rows
For each
line- 6Google SheetsAppend row
- 6
How it works
What happens on each run, in plain English.
Point it at the Google Sheet that holds a client's bank feed and run it. Every line that has not been looked into yet is handed to the vendor verifier, which searches the live web for the business or person behind it and reads the vendor's own page, and what it finds lands as one row on a 'Vendor research' tab: status, vendor, website, what they do, the likely reason, a suggested account, the independent check's verdict, the summary, the evidence, the sources and a question for the client.
The feed is never edited and finished lines are skipped on the next run. If the very first line of a run cannot be researched, usually because the verifier is not set up yet, the run stops and says why, and nothing is written. A line that fails later is recorded as 'Could not research' and the run ends as failed. A feed tab without a Description column stops the run with a note of what it needs. Each run is capped so the cost stays predictable, and its last message says how many lines are still waiting.
You need Google Sheets connected, and the 'Verify the vendor behind a bank or card line' workflow imported and chosen in this one's 'Run a workflow' step, with Serper, Exa and OpenAI connected for it. When you add it, give the sheet's link, the client's name and the client's notes; import a fresh copy for each client.
You may also be interested in
Monthly client invoicesOn the 1st of each month, makes a PDF invoice for every active client in your sheet and emails it to them.
Chase overdue QuickBooks invoicesEmails customers a polite reminder with the invoice attached at 3, 14 and 30 days overdue, and sends you a morning summary of what's owed.
Verify the vendor behind a bank or card lineThe engine behind the bank-line checks: finds who a feed line was paid to, what they do and what it was likely for, or says it could not.Find out who a bank charge was paid toPaste a cryptic bank or card line and get back who was paid, what they do, what it was likely for and where to post it, with sources.Start from a workflow that already works.
Add "Identify who was paid on every bank feed line" to your workspace, connect its apps, and make it yours.
Free plan, no credit card