as_sheets_id()
.read_sheet()
to read in the data. read_sheet()
’s first argument, ss
, takes the sheet ID.sheets_sheets()
. Things todoist.sheets_read()
reads in the first sheet. Here, that’s the Africa sheet. If we want to read in Asia, we can specify the sheet
argument.sheets_find()
will lists both sheets that you own and private sheets that you have access to. These are the same sheets that you can see on your Google Sheets homepage.sheets_find()
into view()
.sheets_read(ss = id_gapminder)
), a browser tab will open and prompt you to sign into Google. Sign into your account and then return to RStudio.googlesheets4::sheets_auth()
(you can run this anywhere: console, R Markdown chunk, etc.). Once you’ve signed into Google and returned to RStudio, try knitting your document.googlesheets4::sheets_auth()
and then try knitting again.