To achieve what you want I think you need to move away from the idea of using CPF's.
I used to use a script to pull data from Google Sheets and display it externally (it was nothing to do with phpBB and was not used on phpBB), but my initial thinking is a script shouldn't be too difficult to write to read the data - then it's a simple case of displaying it cleanly in a table on a new page.
Then, we can add the user ID to the global template variables (if we need to) and use it to lookup the value on the new page. (This would require the spreadsheet data to have the phpBB user ID to identify the member's scores).
From there it'd be a simple task of assigning it to
<!-- EVENT viewtopic_body_postrow_custom_fields_before -->
in
viewtopic_body.html
and
<!-- EVENT memberlist_view_non_contact_custom_fields_before -->
in
memberlist_view.html
for example.
I'm not too confident in my ability to do this, but am willing to give it a shot starting with manual code edits to the core files, and if I get anywhere then to an extension.
Just a quick note: any solicitation has to be done
here. I'm happy to (attempt) this for you for no cost, but being realistic it's going to take me some time to complete (but I should know sooner if it's beyond my knowledge)- it's also assuming you're willing to migrate onto Google Sheets and
possibly Google Scripts.
If you have some sample data I could use that would be helpful.
Thanks.