Google Sheets API R library
Reads and writes Google Sheets using Google Sheets API v4. This is an R package originated from googlesheetsv4.auto autogenerated via googleAuthR's Discovery API builder. The Google Documentation for this API is here. are published.
This package is compatible with authentication method of googleAuthR package. It is recommendation to:
options(
googleAuthR.client_id = "your_client_id",
googleAuthR.client_secret = "your_client_id",
googleAuthR.httr_oauth_cache = ".httr-oauth",
googleAuthR.scopes.selected = c('https://www.googleapis.com/auth/drive', 'https://www.googleapis.com/auth/drive.readonly', 'https://www.googleapis.com/auth/spreadsheets.readonly', 'https://www.googleapis.com/auth/spreadsheets')
)
Set the appropriate scopes above if your are also using other Google API Services. Check googleAuthR packages for more details.
Run the code below:
library(googleAuthR)
gar_auth()
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.