Sample Header Ad - 728x90

Get google spreadsheet contents using shell script

1 vote
1 answer
3610 views
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?
Asked by Briana (19 rep)
Aug 28, 2020, 06:10 PM
Last activity: Sep 3, 2021, 07:47 PM