The only way to host and store a copy of google sheets on your local network is to use a program that automatically goes to google sheets, logs in, and then downloads all of the sheets you want to save on your local network.
I could create a program to do this task for you perfectly and quickly with c# and selenium.