I need Google Spreadsheet to make an API call and record the results

General information for the business: I want to make bulk calls to an API
Description of requirements/functionality: I would like a Google Spreadsheet that looks like this:

https://docs.google.com/spreadsheets/d/17YqsbKBvdC8JqsXXdiLc8dpRPek6Wpzkf5NKbqCHL5Q/edit?usp=sharing

Firstname, Surname, Company, Domain_name Result
When I hit the 'SEARCH' button it makes an API call to populate colum G with the 'Result'

The API documentation is here:
https://emailhunter.co/api/docs#email-generation

You can signup for a demo account of the API here:
https://emailhunter.co/users/sign_up

Please provide me with a fixed price! Need it done ASAP.

thanks!
Specific technologies required: Google Spreadsheet
Extra notes: I would like a Google Spreadsheet that looks like this:

https://docs.google.com/spreadsheets/d/17YqsbKBvdC8JqsXXdiLc8dpRPek6Wpzkf5NKbqCHL5Q/edit?usp=sharing

Firstname, Surname, Company, Domain_name Result
When I hit the 'SEARCH' button it makes an API call to populate colum G with the 'Result'

The API documentation is here:
https://emailhunter.co/api/docs#email-generation

You can signup for a demo account of the API here:
https://emailhunter.co/users/sign_up

Please provide me with a fixed price! Need it done ASAP.

thanks!