Its frustrating that this isn't easily accessible. I was able to get the ID with a Loop by Zapier. But this wasn't cheap because it creates tasks for each updated row. Someone might have a better Zap, but this worked out for me. You only get 500 rows per action, so you will have to run it multiple times or add a path to run it multiple times in parallel (be sure to adjust the subsequent action's starting row by +500).

After I got my list, I turned it off and just used both the New Vendor trigger alongside the Update Bill trigger to create two lower usage Zaps for maintenance (with Update Bill, I used actions to Search/Filter for a blank VendorID column in my Vendor table and then update the Vendor record using Find Vendor if the data was missing).