I’ve used the various examples on this forum to get an API call working that loads new content to monday.com from Google Sheets and another that mutates the item on the board when a value changes (an onEdit function). However, for the function to work each row on the sheet needs to physically edited for the onEdit function to kick in.
I’m tring to keep a couple of hundreds lines updated and asking someone to make a physical edit is just not going to work. Has anyone been able to set this to work so an entire sheet, including pulseIds, refreshes monday.com? We can’t use a third party integration like Integromat as our organisation blocks Add-ons for sheets and also we would need to pay for the amount of use we expect.