Automate ISS Location Tracking to BigQuery
detail.loadingPreview
Continuously capture the International Space Station's (ISS) real-time location data and store it in Google BigQuery. This workflow automates fetching data from the ISS API and populating your data warehouse for analysis.
About This Workflow
This n8n workflow automates the process of tracking the International Space Station's (ISS) current location and storing it for future analysis. It starts with a Cron node that triggers the process every minute. An HTTP Request node then fetches the latest latitude, longitude, and timestamp data from the ISS API. The data is then processed by a Set node to structure it before being inserted into a Google BigQuery table named 'position' within the 'iss' dataset. This provides a continuous stream of valuable geospatial data, perfect for research, educational projects, or simply satisfying your curiosity about the ISS's journey.
Key Features
- Real-time Data Fetching: Automatically retrieves live location data from the ISS.
- Automated Data Storage: Seamlessly integrates with Google BigQuery for persistent data storage.
- Scheduled Execution: Configurable to run at desired intervals, ensuring up-to-date information.
- Data Transformation: Prepares fetched data for optimal insertion into BigQuery.
- Scalable Infrastructure: Leverages powerful cloud services for reliable data handling.
How To Use
- Cron Node Configuration: Set the
triggerTimesparameter toeveryMinute(or your desired interval) to initiate the workflow. - HTTP Request Node Setup: Configure the
urltohttps://api.wheretheiss.at/v1/satellites/25544/positions. Add a query parametertimestampswith the value={{Date.now();}}. - Set Node Configuration: Map the incoming JSON data from the HTTP Request node. For
latitude,longitude, andtimestamp, use expressions like={{$node["HTTP Request"].json["0"]["latitude"]}}. Forname, use={{$json["0"]["name"]}}. - Google BigQuery Node Configuration: Ensure your
BigQuery Credentialsare set up. Provide yourprojectId(supple-cabinet-289219),datasetId(iss), andtableId(position). Specify the columns to insert:name, latitude, longitude, timestamp.
Apps Used
Workflow JSON
{
"id": "db96859e-0053-486e-b453-5cb939341be9",
"name": "Automate ISS Location Tracking to BigQuery",
"nodes": 26,
"category": "DevOps",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: db96859e-0053...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Automate Qualys Report Generation and Retrieval
Streamline your Qualys security reporting by automating the generation and retrieval of reports. This workflow ensures timely access to crucial security data without manual intervention.
Automated PR Merged QA Notifications
Streamline your QA process with this automated workflow that notifies your team upon successful Pull Request merges. Leverage AI and vector stores to enrich notifications and ensure seamless integration into your development pipeline.
Visualize Your n8n Workflows: Interactive Dashboard with Mermaid.js
Gain unparalleled visibility into your n8n automation landscape. This workflow transforms your n8n instance into a dynamic, interactive dashboard, leveraging Mermaid.js to visualize all your workflows in one accessible place.