Good morning Meggie,
You will need to download the data from google sheets as a comma separated values (csv) file. Then you can drag it from your desktop into a CODAP document window or use the Import command from the “hamburger” menu in the upper-left corner of the CODAP window.
Hope this helps,
Bill