Running into an issue with my Google App Script that sends POST data from each row to an API Gateway URL. The problem seems to occur after the first 6 rows, possibly due to a stacking issue with Lambda.
Any ideas on how to limit the script to processing only a maximum of 6 rows? Here's a snippet of the code:
// Iterating through the spreadsheet rows
for (var i = 0; i < data.length; ++i) {
var row = data[i];
// Storing values from each row in variables
var index = row[0]; // Col A: Index Sequence Number
var img = row[1]; // Col B: Image Row
var url = row[2]; // Col C: URL Row
var emailStatus = row[lastColumn - 1]; // Col E: Email Status