How do I replace my appsettings.json at build or publish?

Question

During development, I am using SQL Server locally. However when I want to publish, I have to go to my network share and copy it (overwriting my file) and then build/publish.

Is there a way I can automate this by copying the file from

\\Network\IT\ProjectName\appsettings.json

to my project directory\appsettings.json