ae_get_gs_data: GoogleSheets to dataframe

In aleksandereiken/aeikenr: A collection of usefull functions created by Aleksander

Description

Retrieves data from a googlesheets online, if you have authorization

Usage

ae_get_gs_data(worksheet, sheet_key, colnames = TRUE, path_to_token = NULL)

Arguments

worksheet	The worksheet in the googlesheets, which you want to retrieve data from
sheet_key	The sheet_key of the worksheet. Can be accessed through the URL
colnames	Boolean on whether you wish to have the first row of the spreadsheet serve as column names
path_to_token	Specify path to token, which allows access to googlesheets. If not specified, you will be asked to grant access via a web browser

Value

Tibble of googlesheets data

Examples

ae_get_gs_data("your_data","your_worksheet_name","your_sheet_key_id_like_1zmxDhJ...")

aleksandereiken/aeikenr documentation built on July 29, 2020, 12:05 a.m.