Hey Tyler, I went through a similar process several months ago with Lindy. For lead gen as well.
Sounds like our processes might be slightly different, but the objective is the same. I was using Apify and a google maps scraper to generate the least and write them to a sheet, then enhance the data with other agents, and eventually write a customised email to them.
DM me and perhaps we can figure out how to make your flow execute correctly