Getting started with Google Sheets

  • The main function of the googlesheets4 package is read_sheet(), which reads a Google Sheet from a URL or a file id. This function also goes by the name range_read().

  • You can create a brand new sheet with gs4_create() or write to an existing sheet with sheet_write() and friends.

  • You can read from a public Google Sheet without authenticating with your Google account and with gs4_deauth().