If you try the example here Location sensor (ringed fence / circular ringed fence) - #2 by SteveJG , does the geofence in the example work?
Is your app awake when the app attempts to send your data to the google sheet.? You are doing a LOT of processing within the LocationSensor,LocationChanged event handler. That is usually not a great idea and may be part of your issue.
Can you send a location to your Googlesheet using a Button and a Post command. It that works and your existing code does not, how you use your if..then statements in this Block is possibly the issue.
Your code is very complex, it uses a TinyDB, a FirebaseDB and a google sheet, multiple if statements to determine whether in or not within the boundary created by the Circle (when only a single if/else is necessary). The code need not be that complex.
Get your ringed fence to work the way you want Samuel. Test it then add the 'interesting features'.