< All Topics
Print

Importing 7Timer Data

PostedFebruary 1, 2025
UpdatedFebruary 1, 2025
ByAnas Kakuwala

Importing 7Timer Data into Google Sheets

This guide will walk through how to pull weather data from the 7Timer API directly into Google Sheets.

To start pulling data all you need to do is make a request to pull data using Phlorin in Google Sheets.

Getting Started

Install the API solution add-on from Google Marketplace.

Pull 7Timer Data into Google Sheets

To get the most out of the 7Timer API, use Phlorin to pull data seamlessly into Google Sheets.

1. In your desired Sheets document, open Phlorin and create a new request:

Extensions > Phlorin > Open > Create a request

2. In the Application dropdown select or search for 7Timer Astro Weather

3. Select the desired endpoint. No API key necessary.

In this example we will use /civilight.php?output=json this will provide a simplified 7-day weather forecast for a specific area.
4. Next you will need to enter the parameters. First the output language. Type en for English. See the official documentation for other outputs.
5. For Latitude and Longitude you simply need a specific area you are trying to report.

Tip: use a site like https://www.latlong.net/ to quickly acquire the latitude and longitude of a place name, country, city, etc.

5. Lastly, make sure your desired sheet is selected and click Run.

Need help creating your request?
Reach out to us: Contact support or join our community forum.

Creating Custom Request

Though it is recommended to use Phlorin’s built-in functionality, with 7Timer API’s documentation you can find URLs to run custom requests. Search their documentation for the desired request and adapt the URL to suit your needs.

Documentation

7Timer official API documentation: https://www.7timer.info/doc.php?lang=en#graphical_api

Phlorin