Type guessing | Excel types, R types, col_types | When column guessing goes wrong | Peek at column names | Square pegs in round holes | Logical column | Numeric column | Date column | Text or character column

Little known Excel facts | Implications for readxl | skip and n_max | skip | n_max | range

collapse transformer | Shell quoting transformer | emoji transformer | sprintf transformer | signif transformer | safely transformer | "Variables and Values" transformer

Working example | Where does glue() evaluate code?

Gluing and interpolating | Control of line breaks | Delimiters | Where glue looks for values | SQL

glue engine | glue_sql engine

The Remotes field | GitHub | Other sources | CRAN submission

"gargle_verbosity" option | gargle_oauth_sitrep() | Why do good tokens go bad? | Too many tokens | Credential rolling | How to avoid auth pain | How to inspect the last response

Consider using a service account token (or no token!) | When and how to use OOB | Request OOB auth in the PKG_auth() call | Set the "gargle_oob_default" option | Conventional vs. pseudo-OOB auth | How pseudo-OOB works | More details about the deprecation of conventional OOB | But I didn't need OOB yesterday! | Further reading

token_fetch() | Get verbose output | credentials_byo_oauth2() | credentials_service_account() | credentials_external_account() | credentials_app_default() | credentials_gce() | credentials_user_oauth2() | Manipulate the credential function registry

Get a Google Cloud Platform project | Enable API(s) | Think about billing | API Key | What does a user do with an API key? | OAuth client ID and secret | What does a user do with an OAuth client? | Service account token | What does a user do with a service account token? | Workload identity federation | Further reading

Key choices | User-facing auth | Auth state | OAuth client | API key | Email or Google identity | Scopes | OAuth cache and Out-of-band auth | Overview of mechanics | Getting that first token | Auth interface | De-auth | Bring Your Own Client and Key | Changing identities (and more)

Why use gargle's request helpers? | High-level design pattern | gargle's HTTP request helpers | Discovery Documents | Method (or endpoint) data | Design suggestion: forming requests | Design suggestion: making requests | Reference

Why change was needed | How to instantiate an OAuth client in R | AuthState class | Gargle2.0 class

Provide a token or pre-authorize token discovery | Sidebar 1: Deployment | Sidebar 2: I just want my .Rmd to render | Embrace credentials available in certain cloud settings | Google Compute Engine | Workload Identity on Google Kubernetes Engine (GKE) | AWS | Provide a service account token directly | Rig a service or external account for use with Application Default Credentials | Provide an OAuth token directly | Arrange for an OAuth user token to be re-discovered | I just want my .Rmd to render | Project-level OAuth cache

Reading files | Reading multiple files | Reading compressed files | Reading individual files from a multi-file zip archive | Reading remote files | Column selection | Reading fixed width files | Column types | Name repair | Writing delimited files | Writing CSV delimited files | Writing compressed files | Reading and writing from standard input and output | Further reading

How it works | Reading delimited files | Taxi Trip Dataset | Taxi Benchmarks | All numeric data | Long | Wide | All character data | Reading multiple delimited files | Reading fixed width files | United States Census 5-Percent Public Use Microdata Sample files | Census data benchmarks | Writing delimited files | Session and package information

Automatic guessing | Legacy behavior

Vector parsers | Atomic vectors | Flexible numeric parser | Date/times | Factors | Column specification | Rectangular parsers | Overriding the defaults | Available column specifications | Output

Dates and times | Names of months and days | Timezones | Default formats | Character | Numbers

OAuth client | Auth | Compose and send an email | Read email | Quota

Demo code | Setup: store a token | Usage: load and use token | Ongoing maintenance

Constructing a MIME message | Text | HTML | Attachments | Including images | Uploading | Create Draft | Insert | Import | Sending | Draft | Message | Troubleshooting | Gmail API error 400: Mail service not enabled

Install and test drive | Color schemes for countries and continents | How to use the color scheme in ggplot2 | How to use the color scheme in base graphics | ISO 3166-1 country codes | What is gapminder good for? | How this sausage was made | Plain text delimited files | License | Citation

Main requirements | This seems like a lot of work! | Further reading: | Package philosophy