An index of the official example and test Sheets. They are world-readable, so we do gs4_deauth().

Example Sheets

name (these are links) id
mini-gap 1k94ZVVl6sdj0AXfK9MQOuQ4rOhd1PULqpAu2_kr9MAU
gapminder 1U6Cf_qEOhiR9AZqTqS3mbMF3zt2db48ZP5v3rkrAEJY
deaths 1VTJjWoP1nshbyxmL9JqXgdVsimaYty21LGxxs018H2Y
chicken-sheet 1ct9t1Efv8pAGN9YO5gC2QfRq2wT4XjNoTMXpVeUghJU
formulas-and-formats 1wPLrWOxxEjp3T1nv2YBxn63FX70Mz5W5Tm4tGc-lRms
cell-contents-and-formats 1peJXEeAp5Qt3ENoTvkhvenQ36N3kLyq6sq9Dh2ufQ6E

How to get hold of the example Sheets yourself

gs4_examples() returns a named vector of Sheet IDs. It is also an instance of drive_id, to make good things happen with googledrive.

gs4_examples()
#>                                       mini-gap 
#> "1k94ZVVl6sdj0AXfK9MQOuQ4rOhd1PULqpAu2_kr9MAU" 
#>                                      gapminder 
#> "1U6Cf_qEOhiR9AZqTqS3mbMF3zt2db48ZP5v3rkrAEJY" 
#>                                         deaths 
#> "1VTJjWoP1nshbyxmL9JqXgdVsimaYty21LGxxs018H2Y" 
#>                                  chicken-sheet 
#> "1ct9t1Efv8pAGN9YO5gC2QfRq2wT4XjNoTMXpVeUghJU" 
#>                           formulas-and-formats 
#> "1wPLrWOxxEjp3T1nv2YBxn63FX70Mz5W5Tm4tGc-lRms" 
#>                      cell-contents-and-formats 
#> "1peJXEeAp5Qt3ENoTvkhvenQ36N3kLyq6sq9Dh2ufQ6E" 
#> attr(,"class")
#> [1] "drive_id"

gs4_examples("gap")
#>                                       mini-gap 
#> "1k94ZVVl6sdj0AXfK9MQOuQ4rOhd1PULqpAu2_kr9MAU" 
#>                                      gapminder 
#> "1U6Cf_qEOhiR9AZqTqS3mbMF3zt2db48ZP5v3rkrAEJY" 
#> attr(,"class")
#> [1] "drive_id"

gs4_examples("and")
#>                           formulas-and-formats 
#> "1wPLrWOxxEjp3T1nv2YBxn63FX70Mz5W5Tm4tGc-lRms" 
#>                      cell-contents-and-formats 
#> "1peJXEeAp5Qt3ENoTvkhvenQ36N3kLyq6sq9Dh2ufQ6E" 
#> attr(,"class")
#> [1] "drive_id"

gs4_example() returns exactly one Sheet ID (or errors). It is an instance of drive_id. It is also an instance of sheets_id, which means printing will (try to) reveal current metadata about the Sheet.

gs4_example("chicken")
#> Spreadsheet name: chicken-sheet
#>               ID: 1ct9t1Efv8pAGN9YO5gC2QfRq2wT4XjNoTMXpVeUghJU
#>           Locale: en_US
#>        Time zone: America/Los_Angeles
#>      # of sheets: 1
#> 
#> (Sheet name): (Nominal extent in rows x columns)
#>  chicken.csv: 1000 x 26

gs4_example("gap")
#> Error: Found multiple matching example Sheets:
#>   * mini-gap
#>   * gapminder
#> Make the `matches` regular expression more specific.

Here’s a handy snippet to open all the example Sheets in browser tabs.

lapply(gs4_examples(), gs4_browse)

Test Sheets

These are more developer-facing, but it’s convenient to do them here too.

name (these are links) id
googlesheets4-cell-tests 1WRFIb11PJsNwx2tYBRn3uq8uHwWSI5ziSgbGjkOukmE
googlesheets4-col-types 1q-iRi1L3JugqHTtcjQ3DQOmOTuDnUsWi2AiG2eNyQkU