[Python] How to crawl data using Selenium and split cell values in Google Sheets

enter image description here

Currently, I am retrieving all the td values and saving them to Google Sheets

enter image description here

For the page to be crawled, the date and rank are located as td > div > div > span,b

enter image description here

So, when I extract only the elements, all the data gets stored in a single cell. Is there a way to store it as follows?

For example: a2:11-27(Wed), a3:291st b2:11-26(Tue), b3:278th (...)

split and bs4 are not working

Continue reading...