Open source projects using the Visual Crossing Weather API.
A Google Apps Script-based Looker Studio Community Connector that brings Visual Crossing weather data into Looker Studio. This connector supports both single location weather data and batch processing for multiple store locations via Google Sheets integration.
- Daily & Hourly Weather Data: Access comprehensive weather metrics including temperature, humidity, precipitation, wind speed, and more
- Single Location Mode: Get weather data for a specific location
- Batch Store Mode: Process multiple store locations from a Google Sheet
- Flexible Date Ranges: Historical and forecast weather data
- Multiple Units: Support for metric, imperial, and scientific units
- Caching: Built-in response caching to optimize API usage
- Error Handling: Comprehensive error handling and debugging
- Get your free API key from Visual Crossing Weather
- Deploy the connector using Google Apps Script
- Configure in Looker Studio with your API key and settings
Repository: visualcrossing_connector/
Documentation: See the detailed README for complete setup and usage instructions.
Test Deployment ID: AKfycbzxluwKtRgJ1Mu7esmy_2kNJAvA8Xltrm28jMjG8urW
Web app URL: https://script.google.com/macros/s/AKfycbzxluwKtRgJ1Mu7esmy_2kNJAvA8Xltrm28jMjG8urW/dev
-
Visit the connector: https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzxluwKtRgJ1Mu7esmy_2kNJAvA8Xltrm28jMjG8urW
-
Authorize if required:
-
Fill the parameters and click [CONNECT]:
-
Click [Create Report] to create a report:
-
Build your weather report:
Deployment ID: AKfycbybtv7dq1gGqfC8y8mbk8-Iul5ZJ_hBAxq59y9UrvB-oKW_Or1rTYlj6wJLtPaSCxUntQ
Data Studio URL: https://datastudio.google.com/datasources/create?connectorId=AKfycbybtv7dq1gGqfC8y8mbk8-Iul5ZJ_hBAxq59y9UrvB-oKW_Or1rTYlj6wJLtPaSCxUntQ&authuser=0
Web app URL: https://script.google.com/macros/s/AKfycbybtv7dq1gGqfC8y8mbk8-Iul5ZJ_hBAxq59y9UrvB-oKW_Or1rTYlj6wJLtPaSCxUntQ/exec