im currently building a scraper for a google sheet. I can scrape all text based things easily but ive run into a problem with links hidden in shortcuts. I have no clue how to extract them. I previously used the follwing to extract the image links:

url = '#gid=0'
answer = requests.get(url)
table = BeautifulSoup(answer.text, "html.parser")
print(table.select('td img[src]'))
# convert all img links to text
for img in table.select('td img[src]'):
    img.replace_with(img['src'])
pd.set_option('display.max_columns', None)  # Display all columns
pd.set_option('display.max_rows', None)  # Display all rows (you can adjust as needed)
pd.set_option('display.width', 1000)  # Set a wide display width
df = pd.read_html(StringIO(str(table)))[0]

But this doest work with the follwing Spreadsheet. I think the images arent rendered by just a request but i dont have a clue how to solve it.