Here is starting point that I used: Site Provisioning Workflow with Custom SharePoint Designer Activity