I have a google spreadsheet with a column of hyperlinks I want the URL from. The googlesheets package can return this information with gs_read_cellfeed(), but it needs to be reshaped with gs_reshape_cellfeed(). Problem is, gs_reshape_cellfeed() returns the 'value' of the cells, not the 'input_value' making it exactly like gs_read(). How do I extract input_value from a cell feed in a convenient format? I want a data frame that looks exactly like the output of gs_read(), except returning 'input_value' instead of 'value'.