Thanks for the Reply Steve, yes when I say the integration is working I mean the google sheets are actually still being updated. However opening either the current workflow or one in progress, still generates the error despite evidently being able to find the spreadsheets shared with it. I've just got fingers crossed that the error is a false negative.
Video demo attached if it helps.
Google Sheet integration errors.mp4