This workflow automates the process of continuously tracking the position of the International Space Station (ISS) and storing its data into Google BigQuery for analysis or monitoring purposes. It is designed to run every minute, making it suitable for real-time tracking applications.
The workflow starts with a Cron trigger that initiates execution every minute. It then makes an HTTP request to the ‘Where the ISS at’ API to fetch the latest position data of the ISS, including latitude, longitude, and timestamp. The data received from this API is processed and formatted in a Set node, extracting relevant fields: name, latitude, longitude, and timestamp.
Next, the formatted data is pushed into Google BigQuery, where it is stored in a table within the ‘iss’ dataset. This process enables chronological logging of the ISS’ position, which can be used for visualization, analysis, or historical tracking.
This workflow is ideal for space enthusiasts, educational projects, or monitoring systems that require real-time satellite positional data stored for further use and analysis. It demonstrates how n8n can integrate REST APIs with cloud databases to automate data collection workflows.
Reviews
There are no reviews yet.