Can the error from `check_is_service_account()` be improved?

[jennybc]

Raised in tidyverse/googlesheets4#300

While I can't truly know the user's intent (whether they mean to provide a filepath or a JSON string), maybe I can try a little harder to guess and tweak the error message.