Draft ~250 emails from a template (1-2 sentences each) and save draft emails in spreadsheet

Draft emails to send to book authors. I have a template and have already completed a few. We create a new column before the 'pitch sent' column in a s/s with author details with a draft email following the template. Each email/cell should only take 1-2 minutes as the details are already available in sheet. The template is as follows: ## Template ## Compliment (why do you respect this person) Identify what they're good at (show you understand their work) Value for them doing the interview (this is their time after all) Credibility (past interviews) Open question - What do you think? (hook) ### Hi *Name* Myself and my small team have recently started a blog which helps aspiring authors, I have so much respect for success in *** area of achievement *** On our blog and corresponding community, we interview unique authors like yourself that are leaders in their chosen markets, allowing us to dig deep into what makes you tick. We’d be honoured to have you complete a short email interview to understand your mindset, goals & tools in day-to-day life. I know that the blog interview format is a unique way to open up to your network and potentially even promote upcoming events or launches with minimal time requirement from yourself. What do you think about completing a short email interview? (10 questions, of which you can pick three to answer) Best, Ollie As you can see the *area of achievement* portion comes directly from the comments column in the spreadsheet. You wouldn't need to send any of the emails, just draft them and have them in the corresponding cell in the highlighted "draft emails" column - I'd then proof read and send from my email address (copy and pasting) All authors in sheet require an email drafted (approximately 250) The second sheet in the workbook can be ignored [login to view URL] Read Less