title: how to loop through each rows and column values in google sheet using app script?
body: <p><a href="https://i.stack.imgur.com/nkssF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nkssF.png" alt="enter image description here" /></a></p>
  <p>am trying to loop through all the amount values in google sheet using app script , but am when i use for loop am only able to get &quot;aoumnt 1&quot; column values only ,</p>
  <pre><code>  var sheetSource1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  for (var i = 1; i &lt;= 3; i++) {
  var activecell = sheetSource1.getRange(i + 2, 2).getValue();
  Logger.log(activecell);
  }
  </code></pre>
  <p>when i run Logger.log()
  i get like below</p>
  <blockquote>
  </blockquote>
  <ul>
  <li>860</li>
  <li>650</li>
  <li>420</li>
  </ul>
  <p>but i want to reesult like</p>
  <ul>
  <li>860</li>
  <li>650</li>
  <li>420</li>
  <li>760</li>
  <li>550</li>
  <li>525</li>
  </ul>
  <p>how to achive this result.?</p>