# Use files from Google Drive, OneDrive or Dropbox

Connect Google Drive, OneDrive or Dropbox, then bring a file in by asking for it by name or by picking it, as if you had uploaded it.

Video: Use files from Google Drive, OneDrive or Dropbox (56 s): /images/docs/videos/google-drive-onedrive-dropbox.mp4

- **Who can use it:** Free, Creator and Creator Max
- **You provide:** A connected drive, and the name of the file or a description of it
- **You get:** A copy of the file in your session, read into a dataset

If the file you want to map lives in Google Drive, OneDrive or Dropbox, you do not need to download it first. Connect the drive once, then ask for the file by its name or what it is, or pick it yourself.

Mapstack brings in a copy of the file as it is at that moment, and from then on it is exactly as if you had uploaded it. The copy does not follow later changes in your drive; a [routine](/docs/automate/set-up-a-routine) can fetch the file again on a schedule. The asks on this page are examples of the kind of thing to say.

## Connect a drive

**Connecting is yours to do.** Mapstack cannot connect a drive for you, because connecting means signing in at the provider. If you ask for a file from a drive that is not connected, it gives you a **Connect** button.

1. In the sidebar, select **Connectors**. The same list is in **Settings**, under **Connectors**.
2. Select **Connect** beside Google Drive, OneDrive or Dropbox.
3. Sign in at the provider and agree. The drive now shows **Connected**.

**It only reads.** In your drive, Mapstack lists folders, searches and downloads the file you chose. It does not rename, move, delete or upload anything. Each provider shows its own consent screen when you connect; read it before you agree.

**Disconnect a drive:** in **Connectors**, select **Disconnect** beside it.

## Ask for a file by name

**It searches as you would.** By file name in every drive, and also by what is inside the files in Google Drive. When several files fit what you asked for, it asks which, and does not pick for you.

The file comes into your session as a copy, read the way its type is read: a spreadsheet or GIS file becomes a dataset, as a card in the conversation.

### Bring a file in from your drive

Name the drive and the file. The exact file name is surest; a description works too. If several files fit, Mapstack asks which one.

> Map our shops from store-locations.csv in my Google Drive

> Find my store list in Dropbox and put it on a map

## Pick a file yourself

1. In the message box, select **+**, then **Upload from the cloud**, and choose the drive. One that is not connected yet shows **Connect**.
2. Browse the folders, or search.
3. Select the file. It comes into your session like an upload.

Files that cannot be brought in are hidden at first. **Show N more** reveals them, each with its reason: **Google doc**, **Too large** or **Not mappable**.

## Keep up with a file that changes

The file someone keeps up to date on a shared drive: a store list, a site register, a weekly export. Bring it in once to map it, or give it to a routine so the map is refreshed from it.

**A copy is a copy.** The dataset is made from the file as it was when it was fetched. A routine can fetch it again on a schedule, using the connections of the person who set the routine up. See [What a routine can do](/docs/automate/what-a-routine-can-do).

### Check whether the file has changed

Mapstack compares the file in your drive with the copy it brought in. If they are the same, it says so and does not bring the file in again.

> Has the Drive file behind the customers dataset changed since I brought it in?

## Reference

| | |
|---|---|
| Drives | Google Drive, OneDrive and Dropbox |
| File types | Spreadsheets (.csv, .xlsx, .xls) and GIS files (.geojson, .geojsonl, .ndjson, .json, .topojson, .kml, .kmz, .gpx, .gpkg, .fgb, .gml, .parquet, .geoparquet, or a .zip of a shapefile, MapInfo TAB or File Geodatabase) |
| File size | See [Sizes and limits](/docs/workspace/sizes-and-limits) |
| Files in one pick | One |
| Download | Abandoned if it has not finished after 60 seconds |

After that, the file is treated like any file you upload.

## What it can't do

- Bring in a Google Doc, Sheet or Slides file. They show as **Google doc**. Download a Google Sheet as Excel or CSV into your drive, then bring that in.
- Bring in imagery or scenes. They show as **Not mappable**: attach them from your computer.
- Bring in a loose shapefile part. Zip the shapefile in your drive first.
- Use other storage or business tools. Only these three drives are offered.
- Keep a dataset in step with the file by itself. Each fetch is a copy; use a routine to fetch again.
- Connect a drive, or change anything in it.
- Take files from a Viewer seat. Connecting a drive and bringing files in take a Free, Creator or Creator Max seat.

## Common questions

**Does the dataset change when the file in my drive changes?**

No. Mapstack brings in a copy of the file as it was when it was fetched. Ask 'Has the Drive file behind the customers dataset changed since I brought it in?', or set up a [routine](/docs/automate/set-up-a-routine) to fetch it again on a schedule.

**What if Mapstack can't find my file?**

Give its exact file name, or pick it yourself: select **+** in the message box, then **Upload from the cloud**. When several files fit what you asked for, Mapstack asks which one.

**Why are some of my files hidden?**

They cannot be brought in from a drive: a **Google doc** (a Google Doc, Sheet or Slides file), **Too large** (see [Sizes and limits](/docs/workspace/sizes-and-limits)), or **Not mappable**, as imagery and scenes are. Select **Show N more** to see each with its reason. Download a Google Sheet as Excel or CSV into your drive, and attach imagery and scenes from your computer.

**What if connecting a drive doesn't work?**

Select **Connect** again. The sign-in opens in a pop-up window, so check your browser did not block it.

**Can I connect a CRM or other storage?**

No. Google Drive, OneDrive and Dropbox are the connections offered. Save the data as a file and bring that in, or upload it.

## Related

- [Upload a file](https://mapstack.io/docs/your-data/upload-a-file.md)
- [Map a spreadsheet: addresses, coordinates or place names](https://mapstack.io/docs/your-data/spreadsheets.md)
- [Set up a routine](https://mapstack.io/docs/automate/set-up-a-routine.md)
- [What a routine can and can't do](https://mapstack.io/docs/automate/what-a-routine-can-do.md)
- [Seats and what each can do](https://mapstack.io/docs/workspace/seats.md)
- [Publish a map at a link that keeps itself up to date](https://mapstack.io/docs/guides/keep-a-published-map-current.md)
