To see an interesting use -- check out https://www.tillerhq.com/. An entire business built on top of google sheets.

Unfortunately, i didn't care for it (I didn't like the way they handled splits or the import from amazon)