SOLVED:
I had to perform one extra step to get this to work:
- Open up Google Sheet and click "share"
- Input the Google IAM email address (associated with the Private Key) into the Google Sheet email-input textbox
- Click save
SOLVED:
I had to perform one extra step to get this to work: