This is a simple google apps script to autogenerate a link removal request. assuming you have 3 fields, url of link, requester's name and your domain, you can call this script by typing: =createRemovalMessage(A1, A2, A3) in the cell you want to create your message on

linkremovalcopy

function createRemovalMessage(url, name, domain)
{

  if(url)
  {
    return 'Hello, My name is '+name+' I work for the company '+domain+'. We\'ve noticed there is a link at '+url+' We would greatly appreciate it if you could remove it, our website has been penalized and we are working hard to remove that penalty. We worked with an SEO company that built links for us in an unscrupulous manner.  We apologize for any inconvenience this may cause, but removing this link should actually help your site\'s overall quality.  If you need any help, please don\'t hesitate to contact me directly.  I\'d be more than happy to help.  The link is directed to '+domain+' Thanks. '+name';
  }
  else
  {
    return;
  }
}