Download Google sheet in Excel format

download_sheet.py

# This script will take in a Google sheets link
# and download the sheet in Excel format to your computer

# example:
# $ python3 download_sheet.py https://docs.google.com/spreadsheets/d/1eSfTc8B6sU94JVvmXWEyINytWdjzRIwLA8bB93Lycus/edit#gid=1773176508

import sys
import webbrowser

# read the sheet link argument passed in the cli
sheet_link = sys.argv[-1]

# prepare query strings
gid = sheet_link[sheet_link.find('gid=')::]
export_format = 'export?format=xlsx'
parameters = export_format + '&' + gid

base_link = sheet_link[:sheet_link.find('edit')]

# concatenate base link with parameters
excel_link = base_link + parameters

# open the link in a new tab
webbrowser.open_new(excel_link)