here is the errors
Raw message: The state of the object caused the operation to fail.
in Main.xaml
at WriteCellConnections “DAte cell in Google Sheets. 1”
at Sequence “Do”
at ForEachFileFolderConnections “For Each File or Folder”
at Sequence “Sequence”
at Main “Main”
It works in Manual run because you are logged in and the session is active.It fails in Timed Trigger because the robot runs without a user session, so apps like Google Sheets / browser login are not available.
Please Set up Unattended credentials properly and make sure the process does not depend on an open browser or manual login.
This happens because the timed trigger runs in a fresh unattended context where the Google Sheets connection is not initialized or the robot user does not have access, while manual runs reuse an active authenticated session. The fix is to initialize the Google Sheets connection once at the start of the process, keep it outside the For Each loop, and ensure the triggered robot user has permission to the Integration Service connection.