Google Sheets / API Wizard needed for quick job

We have a google sheet which we populate with name / company data via a scraper- then we generate emails with this data. We want to use API from Zerobounce so that it checks whether the email is valid. At the moment we have to copy & paste the emails into zerobounce and make sure it is format correctly but its a pain. So we want to run a script via google sheet to do this automatically. [login to view URL] So we want to press to validate emails- the script runs- then in column it gives email status next to each (eg verified, unverified, catch all) if this status is verfied then the row is copied onto another worksheet within the same google sheet..eg Verified emails. So we can just go in and copy & paste them If you think you can do this quickly get in touch $50 quick job