New to googlesheets4 - just trying to get connected

I'm trying to set up connection between my lab (e.g., localhost) and one of my gmail accounts to test using google sheets/drive

when i run the app that I've built just to see if it would connect to the sheet i get

This site can’t be reached

localhost refused to connect.

the code looks like this:

library(shiny)
library(shinydashboard)
library(googlesheets4)

read_sheet("URL of the sheet here")

i don't have 0Auth set up on my gmail, its just username and pwd
i tried using the g24_auth, but that was an epic fail...

i don't think this app would ever be commercial

the goal is to get the app up and running on my local machine but connected to my gmail/gdrive for sheet access
then eventually migrate to shinyapps.io so i can put authentication in front of the app -