you just need to add a condition inside your forEach loop that checks if the row is hidden before processing it. The sheet.isRowHiddenByUser(rowIndex) method returns true if the row is hidden by the user. Modify your loop like this:

Add a check for sheet.isRowHiddenByUser(index + 2) (since your data starts at row 2) before updating the event. If the row is hidden, skip the update for that row.