This project leverages WeatherAPI and Google Apps Script to fetch and visualize real-time weather updates, detailed summaries, weekly weather predictions, and visualizations of temperature and precipitation. ForecastSheet is designed to make weather data analysis simple, efficient, and accessible directly within your Google Sheets.
Real-time Weather Updates: Fetches the latest weather data for specified locations.
Weather Summaries: Provides comprehensive weather summaries including temperature, condition, humidity, and wind speed.
Weekly Weather Predictions: Displays a 7-day weather forecast with detailed information for each day.
Visualization: Visualizes temperature and precipitation data for easy analysis.
Tracking Weather of Multiple Location at the same time: It allows users to enter multiple location at the same time
APIs: Utilizes WeatherAPI to fetch real-time and forecast weather data.
Google Apps Script: Custom scripts automate data retrieval, processing, and visualization within Google Sheets.
-A Google account
-Access to Google Sheets
-WeatherAPI key (you can get one by signing up on WeatherAPI)
- Clone the Repository
- git clone https://github.com/krupa2002/ForecastSheet.git
- cd ForecastSheet
- Open Google Sheets
- Open a new or existing Google Sheet.
- Open Script Editor
- Click on Extensions > Apps Script to open the script editor.
- Add the Scripts
- Create two new script files in the script editor and name them Code.gs and Code1.gs.
- Copy the contents of Code.gs from the repository into the Code.gs file in the script editor.
- Copy the contents of Code1.gs from the repository into the Code1.gs file in the script editor.
- Save and Run
- Save the scripts.
- Run the onOpen function to add the "Weather" menu to your Google Sheet.
Refresh Your Google Sheet
After running the onOpen function, refresh your Google Sheet. You should see a new "Weather" menu in the menu bar.
Fetch Weather Data
Click on the "Weather" menu and select "Weather Forecast."
Enter the city names separated by commas when prompted.
View Weather Data
The weather data for the specified cities will be displayed in new sheets within your Google Sheet.
Each sheet will contain current weather data, a weekly forecast, a weather chart and a weather summary.