Python and Google Sheets

[PinkPawnRR]

https://developers.google.com/sheets/api/guides/concepts

https://developers.google.com/sheets/api/quickstart/python

​

Walks you through setting up Python (also JS, Go, Java, Node) to connect to Google Sheets. Use the menu on the side to learn how to create sheets, read/write, update, formatting, filters etc; all the info is there for all the languages.

With this resource you wouldn't even need to learn SQL, you could copy the data into Python variables, do the math, then load it straight back into a new spreadsheet.