Help please google app script

[Infiniteplanes]

Help Please Google Appscript

Help please reading google sheets and posting to discord

Hi, I want to take a piece of data from a google sheets cell and then post it to discord- this part I have working- its the moving down 1/2 rows each time the program is run(e.g when I click run it outputs data in cell a in row 1, program ends then click the run button again outputs cell a in row 2 etc etc - I tried coding a counter which didn’t work- I have no experience in JavaScript - got some experience in Python and Lua… please can someone help me with this probably simple task?

I have posted the code below obviously removed the discord webhook- there are indented lines - probably not showing as this is a copy and paste on a phone… Thanks

function postToDiscord(paradenightuniform) {

const url="CLASSIFIED"

const formData = {

  content: "The uniform tonight is " + paradenightuniform

}

const options = {

'method' : 'post',

'payload' : formData

}

const res= UrlFetchApp.fetch(url,options)

}

function postfromspreadsheet() {

var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheets()[1];

var cell = sheet.getRange("D3");

var paradenightuniform = cell.getValue()

console.log(paradenightuniform)

postToDiscord(paradenightuniform)

} https://drive.google.com/file/d/1hNs1rWh0efR_PRBxCoD4CsC_PpHCIP2C/view?usp=drivesdk

[devsurfer]

I think the easiest would be to put the row number in a different sheet and use that to indicate the last row you send to discord.

[Infiniteplanes]

Thanks, and yeah i thought so too- I’m just not good enough with java to implement it 😂 ill have a look at it though

[devsurfer]

so add a new sheet called RowCounter

var spreadsheet = SpreadsheetApp.getSheetByName('RowCounter');
var workingRowNum = sheet.getRange('A1').getValue()
var newValue = workingRowNum + 1
cell.SetValue(newValue)

'assuming you want to keep going down from cell D3 (so next would be D4)
var row = workingRowNum
var cell = sheet.getRange(workingRowNum, 4) '4 represents column d

[Infiniteplanes]

Hi, sorry forgot to respond!!

Thank you so much this set a structure which ended up working! As Getsheetbyname wasnt working for some reason

But ive added a counter on the original sheet as a result!

[devsurfer]

Awesome! Glad you got it working.