How to insert info into online excel spreadsheet with python selenium

Question

Is it possible to use Selenium to input data into an Excel spreadsheet? For instance, I want to be able to insert certain information into a particular category and have a number of rows and categories. My spreadsheet looks like this.

Also are there any alternatives?

Answer 1

I recently discovered one of my options, and perhaps it would be helpful to others as well. I can make advantage of Selenium ActionChains to insert data.

driver.get(https://docs.google.com/spreadsheets/.........)
actions = ActionChains(driver)
actions.send_keys(Keys.DOWN + 't')
actions.perform()

For instance, in this scenario, when the webpage is opened by the driver and you click the down arrow button, the tab travels to the first column and second row before inserting the letter "t". It is possible to create a function that asks for coordinates, such as which row and column to select in order to input the data and how many times to click left, right, up, and down. My issue is resolved by this, however, I'd want to learn about other approaches.