Export CSV from Google Spreadsheet using Python

export_csv.py

import requests
import argparse
import sys

def main():
    parser = argparse.ArgumentParser()
    parser.add_argument('--spreadsheet_id', type=str, required=True)
    parser.add_argument('--gid', type=int, required=True)
    parser.add_argument('outfile', nargs='?', type=argparse.FileType('w'), default=sys.stdout)
    args = parser.parse_args()
    # The given spreadsheet should be publicly accessible.
    url = f'https://docs.google.com/spreadsheets/d/{args.spreadsheet_id}/export?gid={args.gid}&format=csv'
    print(f'Reading {url}...')
    r = requests.get(url)
    args.outfile.write(r.text)
    args.outfile.close()

if __name__ == "__main__":
    main()