Hi @Hannah_Krumholz 
!
Someone ran into a similar issue some time ago and if I do remember correctly this happens because in GSheets hyperlinks are created with a “cell formula” (and Coda doesn’t support “cell formulas”, so the hyperlinks are not interpreted as hyperlinks but as text) .
What you could do is instead of copying/pasting the hyperlink from GSheets would be to copy and paste in your table the display text of your GSheets hyperlink and the url… then in another column, recreate the hyperlink (with Hyperlink()) .
In my sample, the Hyperlink() formula is :
Hyperlink(thisRow.[Copied URL],thisRow.[Copied Name])
It’s been a while since I’ve used GSheets so I might be wrong here 
.