Google Sheets integration connects spreadsheet data directly to your Atlas projects. Import structured data from public URLs or your Google Drive account, and refresh it anytime to sync the latest changes.
Prerequisites
Before connecting Google Sheets, ensure you have:
- A Google Sheets spreadsheet with your data
- Public sharing enabled (for URL method) or a Google account (for Drive method)
- Data formatted with column headers in the first row
- Location data included (addresses, coordinates, or place names for mapping)
Access the Connections Tab
- Click Add layer in the Layers panel
- Navigate to the Connections tab
- Select Google Sheets from the connection options
The dialog displays two connection methods: public URL or Google Drive selection.
Connect via Public URL
This method works with any Google Sheets spreadsheet that has public sharing enabled.
Make Your Sheet Public
- Open your Google Sheets spreadsheet
- Click Share in the top right
- Click Change to anyone with the link
- Set permission to Viewer
- Click Copy link
Add the Connection
- In the Atlas Connections dialog, paste your Google Sheets URL into the Enter any public Google Sheets URL field
- Click Connect
- Atlas fetches the spreadsheet and imports it as a new dataset
The dataset appears in your Layers panel and on the map if it contains location data.
Connect via Google Drive
This method lets you browse and select private spreadsheets from your Google Drive without manually copying URLs.
Authenticate
- Click Select from Google Drive
- Sign in to your Google account if prompted
- Grant Atlas permission to access your Google Drive files
- The Google Drive file picker opens
Select Your Spreadsheet
- Browse your Drive folders or search for a specific spreadsheet
- Select the spreadsheet you want to import
- Click Select
- Atlas establishes the connection and imports the data
The spreadsheet appears as a dataset in your project.
Manage Connections
All Google Sheets connections appear in your project under External Connections in the Layers panel.
Refresh Data
Sync your dataset with the latest spreadsheet changes:
- Open up Layer Settings
- Click the Refresh button or schedule refresh based on interval
- Atlas fetches the current spreadsheet data and updates your map
Changes to your Google Sheet (added rows, updated values, new columns) sync when you refresh.
