Automating Lead Generation for Software Start-Up Connections

Hello world! I am generating leads for a software start-up targeting big retailers.I have a list of 1st degree indirect leads, many of whom are connected with my ICP's. Can I automate on Clay the process of checking if my connection has a connection with an ICP (I have a list of companies) and sending a personalised message ala: you are connected with x, would you mind doing an intro. I have about a 1000 of people to check, so thank u so much in advance for saving my time. Hope to be somehow useful too:) D