Mmh, I am using the CMC api myself for my portfolio and just checked it and I still get the value in my excel sheet.
So, I do wonder if this will have an impact on my excel sheet.
To bad, I can't help you with google sheet, I have never used them.

Good luck,
Peter