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.
Thanks for the quick turnaround. That seems to have fixed that issue. I do have another issue that I thought might have been caused by this, but apparently didn’t fix it. I’ll open a different ticket for that for tracking purposes.