I hope this is a solvable problem, but when I set up an integration with google sheet, google sheets will not send Zapier the data of any column if that column includes a link.
Here is a quick video of me going over what I am talking about:
https://www.loom.com/share/5bbbb17090c44ddea5adaf485e42d686