I seem to be having a strange issue with the built in Google Sheets API.
other actions al seem to work fine however I have a function where I need to delete a row from a google sheet table. using the built in function i have entered the filter which generates the correct output when i click preview. HOWEVER, for some reason will not work when run? I'm not really sure why? especially since the preview function is working?
this is the error in the console when running: