Gets the data contained in a Google spreadsheet, skipping rows if required

get_data(data_type_url, user_email, type_value, sheet = NULL, sleep = 5)

Arguments

data_type_url

The URL of a google sheet containing the data

user_email

user email if sheet contains authentication. This may open a browser for authentication and access to Gdrive (optional)

sleep

number of seconds to sleep after call to prevent overload of Google APIs

Value

A tibble dataframe representing the data in the Googlesheet