Hi,
I have created a google sheet that allow our Human Resource Department to fill in the employee ID with their identification number. After that by just click a button, it will automatically generate letter with company letterhead and the employee id with their identification number on the Google Docs. Lets further discuss in detail about your requirements and I believe I am able to complete your task. Thanks!