> For the complete documentation index, see [llms.txt](https://docs.exploratory.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.exploratory.io/data_import/cloud-apps-data/google-sheet.md).

# Google Spreadsheet

## 1. Select Google Spreadsheet Data Menu

Click '+' button next to 'Data Frames' and select 'Import Cloud Apps Data'.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN0X39XzG_qmQv2-F%2Fimport-cloudapps.png?generation=1586795454579146\&alt=media)

Click 'Google Sheets'

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN98xMZoWA0l7F4hn%2Fselect-google-sheet.png?generation=1586795466406246\&alt=media)

## 2. OAuth Setting

Create a connection following [this instruction](https://blog.exploratory.io/how-to-setup-oauth-cloud-apps-connections-in-exploratory-a5c20d18e7c7).

## 3. Set Parameters

* Select a Drive if you have Shared Drives. If you don't have Shared Drives, it only shows defualt drive which is My Drive.
* Select Google Spreadsheet name from the dropdown menu
* Select Worksheet name from the dropdown menu
* Set parameters for how to read the data.

Now you can set below parameters:

1. First row as header - Set Yes if the first row is the header row.
2. Skip first N rows - Number of lines to skip before reading data
3. Timezone - Timezone you want to use for the POSIXct columns
4. Treat these as NA - Character vector of strings to interpret as missing values.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F03858b0ecd36ca9b988393949eb483927abb301f.png?generation=1598456455374000\&alt=media)

## 4. Preview and Import

Click 'Get Data' button

If the data in the preview table look ok, then click 'Save' button to import the data into Exploratory.