I am trying to use a outgoing slack webhook to access a private google sheet file
First, I would advise against using an outgoing webhook. Its an old and outdated approach and I would recommend to use either a slash command or the Events API.
Second, you can access a google sheet using Google's Apps Script Execution API. But you will need a script / Slack app to implement your logic and translate data between Slack and your Google sheet.