I'm trying to set up a trigger for when a new row is added to a specific tab in an Excel sheet. However, the only trigger the editor shows me is "For a selected row". Copilot told me there should be a "When a new row is added" trigger.
Is this a permissions issue or something else? If there's not a "When a new row is added" trigger, how can I get around that?
Jay