I want to create a newsletter subscription and on click on submit i want to execute a workflow which will insert a new lead in repository.
I googled but didn't find a perfect solution for inserting leads programmatically.
As I understand it, you basically need a newsletter sign up form. The easiest way to create one for Campaign Standard is through Experience Manager: Adobe Campaign Help | Creating a Campaign form in Experience Manager
I hope this helps!
All the best,