GoogleSheetReader

class GoogleSheetReader(google_sheet, *, gid=0, sort_middle_authors=True)[source]

Bases: SheetReader

Read from google sheets.

An example sheet that has the right template can be found at: https://docs.google.com/spreadsheets/d/1Fo1YH3ZzOVrQ4wzKnBm6sPha5hZG66-u-uSMDGUvguI

Initialize the sheet reader.

Parameters

  • google_sheet (str) – The identifier of the google sheet

  • gid (Union[str, int]) – The sheet identifier (in case there are more than one)

  • sort_middle_authors (bool) – Should the middle authors (i.e., ones that don’t have “Lead” or “Senior” in their role column) be automatically sorted by last name alphabetical order? Defaults to true, since middle authorship order isn’t usually meaningful.