Write to Google sheet skipping 1st row

Question

When using the package googlesheets4 is there any method for writing data to a sheet skipping the first row so that the data being written to a sheet starts at row 2? I am hoping to leverage something similar to when you read a sheet and utilize ex. skip = 2 to read data starting at the 3rd row

I have tried the following which does not work write_sheet(data = df, ss = "google_sheet_url", skip = 1, sheet = "test")

Answer 1

skip=n is only for read_excel()

in the googlesheets4 library to start at a specified range, you'd use range_write(). This is similar to the startRow=n in the xlsx library.

range_write(ss = "google_sheet_url", data = df, range = "B1", sheet = "test")