Is there any tool that can automate database creation? For eg: I have name of prospects and company name but no email ID and other info? Is there a tool that integrates with data providers and do it in an automated manner ?

Try Clay.io

+1 to Clay

Clay and Prospectoo.com

Clay would be so expensive for this so I would rather use rapidapi + apify enrichment api with make.com to automate this workflow