1. using scrapy or any other tools you like to crawl data
2. using gspread, a 3rd party Google Spreadsheet API wrapper in Python

links

• https://city.shaform.com/zh/2016/03/19/gspread/
• https://github.com/burnash/gspread