Connect Google Sheets to import spreadsheet data into Atlas. Supports public URLs and private spreadsheets from Google Drive. Data syncs automatically on a schedule.
Connect to Google Sheets
- Click Add data in the Layers panel
- Go to the Connections tab
- Select Google Sheets
- Enter a public URL or select from Google Drive
- Click Connect
Connection Methods
Public URL
Paste any public Google Sheets URL. The spreadsheet must have link sharing enabled:
- Open your spreadsheet in Google Sheets
- Click Share → Change to anyone with the link
- Set permission to Viewer
- Copy and paste the URL into Atlas
URL format: https://docs.google.com/spreadsheets/d/<SPREADSHEET_ID>/...
Google Drive
Select private spreadsheets directly from your Google Drive:
- Click Select from Google Drive
- Sign in to your Google account
- Browse or search for spreadsheets
- Select one or more files and click Select
You can select multiple spreadsheets at once to create several connections.
Working with Data
After connecting, Atlas imports the spreadsheet as a dataset. If your data contains location columns (addresses, coordinates, place names), Atlas maps them automatically.
Sync Settings
Connected spreadsheets sync automatically. Configure sync intervals in Layer Settings to keep your data up to date when the source spreadsheet changes.
Troubleshooting
| Issue | Solution |
|---|---|
| Invalid URL | URL must be from docs.google.com/spreadsheets/d/. Check format. |
| Permission Denied | Enable link sharing on the spreadsheet or use Google Drive connection. |
| No Location Data Found | Ensure spreadsheet has columns with addresses, coordinates, or places. |
| Sync Failed | Check that the spreadsheet still exists and sharing settings are valid. |