“Node should mark execution as failed when it returns a service error” is a legitimate bug/design issue worth raising. Google Sheet read Auth failed and output showed
error
Service unavailable - try again later or consider setting this node to retry automatically (in the node settings)
yet the execution shows success?