title: How can I get an image FROM A CELL in a Google Sheet and insert it into a Google Doc
body: <p>I'm currently trying to make a Google Sheet that will fill in a Google Doc with info so that I can better run my community's local job board (I know Indeed is 10x better but I work with a lot of people who are bad at computers XD).
  So far I have all the text replacement working, however, I can't figure out how to insert an image into the document from an image that is in the cell on my Spreadsheet. I have found some solutions on here for using a Google Drive url, but in this scenario, I'm wanting to make it so that the image can simply be inserted into a cell and then put in my Google Doc.</p>
  <p>I've also seen lots of people use a &quot;.replaceTextWithImage&quot; command, but when I try it it doesn't work.</p>
  <p>Here's my code</p>
  <pre><code>//Creates menu option on spreadsheet
  function onOpen() {
    const ui = SpreadsheetApp.getUi();
    const menu = ui.createMenu('AutoFill Docs');
    menu.addItem('Create New Docs', 'createNewGoogleDocs');
    menu.addToUi();
  
  }
  
  //Defines where to get template and info from
  function createNewGoogleDocs() {
   
    const googleDocTemplate = DriveApp.getFileById('14MJNd37pn6D-EmNKCQzXXvxJCcOAoB3KS-TlDgZuWMI');
    const destinationFolder = DriveApp.getFolderById('120Sb_CJJlmz5NzJW8W3DB4TNuC4kdD3e');
    const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('JobBoard');
    const rows = sheet.getDataRange().getValues();
    
    rows.forEach(function(row, index) {
      if (index === 0) return;
      if (row[9]) return;
      const copy = googleDocTemplate.makeCopy(`${row[1]}, ${row[0]} Printout`, destinationFolder);
      const doc = DocumentApp.openById(copy.getId())
      const body = doc.getBody();
      const friendlyDate = new Date(row[2]).toLocaleDateString();
  
  //Replacing text
      body.replaceText('{{Company}}', row[1]);
      body.replaceText('{{jobTitle}}', row[0]);
      body.replaceText('{{datePosted}}', friendlyDate);
      body.replaceText('{{Description}}', row[3]);
      body.replaceText('{{Qualifications}}', row[5]);
      body.replaceText('{{Wage}}', row[4]);
      body.replaceText('{{Apply}}', row[6]);
      body.replaceText(&quot;{{Upload Image}}&quot;, ''); //this is line giving me trouble
    
  
      doc.saveAndClose();
      const url = doc.getUrl();
      sheet.getRange(index + 1, 10).setValue(url)
      
    })
  
  }
  </code></pre>
  <p>Here's my files for reference:</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1cySHogAxcUgzr0hsJoTyPZakKQkM6uIOtmyPzcMoJUM/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1cySHogAxcUgzr0hsJoTyPZakKQkM6uIOtmyPzcMoJUM/edit#gid=0</a></p>
  <p><a href="https://docs.google.com/document/d/14MJNd37pn6D-EmNKCQzXXvxJCcOAoB3KS-TlDgZuWMI/edit" rel="nofollow noreferrer">https://docs.google.com/document/d/14MJNd37pn6D-EmNKCQzXXvxJCcOAoB3KS-TlDgZuWMI/edit</a></p>
  <p>Thanks!</p>