title: How to add data to a specific row in Google Sheets using Google Script
body: <p>In my Google Sheet, I have the index in a variable called colorRow. And i'm just trying to add some data to that row in the sheet but the data keeps going to some other row down the page. What am I doing wrong? </p>
  
  <pre><code>var data = [];
  // Some more fields in data array
  data.push("Final Submission Date: " + new Date());
  // target_sheet.insertRowAfter(colorRow); // Tried this didn't work
  target_sheet.appendRow(data);
  </code></pre>
  
  <p>I need to figure out some way to either reset the append counter so that I can set it to row {colorRow} or if there is a way I can add to a specific row, maybe something like </p>
  
  <pre><code>target_sheet.addAt(7, data)
  </code></pre>
  
  <p>Something like this would be ideal. </p>