Need Snovio api integration to find emails from spreadsheet

I need someone experienced with Snov.io API, to make a script that goes through entries in a spreadsheet, and tries to find a specific persons email as well as people with role "Home Manager", "Deputy Manager", "Manager" and "Operations Manager"

Please watch this video first to understand: https://drive.google.com/file/d/1T-hpq5DwQETYp8mXBHx63-1sUe9eIXea/view