As a workaround, I have copied the entire contents of the sheet into a second sheet, using the “paste special -> paste as values” menu.
However, this means the data is not as dynamic as I was hoping. On the bright side, this is not the fault of the plugin, but rather googles api endpoint. Hopefully it will be fixed soon.