Can Automation Blocks import clips into a sequence from a spreadsheet using "file name starts with..." instead of the exact clip name?

Looking for a way to import clips using a “starts with” filename match (Premiere Pro / Automation Blocks / spreadsheet-driven workflows)

I’m using Automation Blocks for Premiere Pro to automatically pull video clips into a sequence based on file paths generated from a spreadsheet.

Previous workflow (worked well):

• All footage was shot on one camera.

• Filenames followed a simple, predictable pattern (e.g. 1J1A0001.MP4, 1J1A0002.MP4, etc.).

• While filming, I logged the clip number in Excel.

• A formula built the full file path (path + prefix + clip number + extension).

• Automation Blocks could find each clip via an exact filename match and import it into a sequence.

New issue:

• I added a second camera (Canon R5C recording .mxf).

• Canon filenames are much longer and include metadata (date, UUID, etc.).

• The clip number itself still matches what I log in Excel, but it’s now embedded inside a longer filename.

• Because Automation Blocks requires an exact filename match, I can’t reliably reconstruct the full filename via a formula anymore.

What I’m trying to solve:
Instead of requiring an exact filename match, I’m hoping to find:

• a way (in Automation Blocks, Premiere Pro, or another tool) to pull clips from a file path using a “starts with” / partial filename match

• e.g. “import the first clip in this folder whose name starts with B_0012”

*Ideally avoiding renaming media if possible, since the clip numbers already align with my logs

Has anyone found a way to use partial filename matching with Automation Blocks or implement a similar spreadsheet-to-timeline automation that doesn’t rely on exact filename equality?

Any insight, workarounds, or alternative tools would be hugely appreciated!