If I create a published table on Google sheets with a specific web address https://docs.google.com/xxxx how can I extract that information using a shell script? I have used the command
wget -O ABC.txt http://address.txt
to extract information from a webpage but it was already in .txt format. Creating another text file was straight forward. But if I use a similar command using a Google weblink it spits out all of the webpage content that doesn't matter; height, font, white-space, etc. I would like to extract the table into a txt or csv file. Has anyone done this?