Skip to Content

Read data from Google sheets

Extracting data directly from Google spreadsheets


The R package googlesheets4 provides the functionality to read and write data from a Google sheet.

This package is very well documented, so we just have to provide you with the right links:

There are also two specific in-depth articles: one about reading and one about writing sheets.

A complete list of vignettes can be found in the Articles page.

googlesheets4 vs googlesheets

The package googlesheets4 is the follower of googlesheets which doesn’t work anymore as it is built on the outdated Sheets v3 API. If you still have code using this package, you will get this error:

Sign in with Google temporarily disabled for this app

Please, consider to update your code by using the new package, googlesheets4. Good luck!