Track The International Space Station's Location In Real-Time With BigQuery
detail.loadingPreview
Automate the tracking of the International Space Station's (ISS) live position and store this valuable data in Google BigQuery. This workflow provides a reliable way to log historical ISS locations for analysis or visualization.
About This Workflow
This n8n workflow empowers you to continuously monitor the International Space Station's journey across the globe. It begins by fetching the ISS's current latitude, longitude, and timestamp using a public API every minute. The retrieved data is then intelligently mapped and prepared for storage. Finally, this meticulously organized information is inserted into a Google BigQuery table, allowing you to build a historical database of the ISS's movements. This solution is ideal for space enthusiasts, researchers, or anyone interested in visualizing and analyzing satellite trajectories.
Key Features
- Real-time ISS Location Fetching: Get the latest position data every minute.
- Automatic Data Formatting: Streamlines data for insertion.
- Google BigQuery Integration: Securely store historical location data.
- Customizable Scheduling: Easily adjust the data refresh interval.
- Effortless Automation: Set up and forget, while building a valuable dataset.
How To Use
- Cron Node: Configure this node to trigger the workflow at your desired interval (e.g.,
everyMinute). - HTTP Request Node: Set the
URLtohttps://api.wheretheiss.at/v1/satellites/25544/positions. Add a query parametertimestampswith the value={{Date.now();}}. - Set Node: Map the incoming
latitude,longitude, andtimestampfrom the HTTP Request node to new fields. Also, set thenameto a static value like "ISS" or dynamically if needed. - Google BigQuery Node: Configure the
Project ID,Dataset ID(e.g.,iss), andTable ID(e.g.,position). Ensure yourcolumnsincludename, latitude, longitude, timestamp. Set up your BigQuery credentials.
Apps Used
Workflow JSON
{
"id": "8a671e8c-069a-4bd1-bfd9-37c35c0fbfd9",
"name": "Track The International Space Station's Location In Real-Time With BigQuery",
"nodes": 29,
"category": "Personal",
"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: 8a671e8c-069a...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Smart Expense Tracking with Telegram & AI
Automate your personal finance management by turning your Telegram chat into an intelligent expense tracker. Simply send a photo of a receipt or a text message, and this workflow uses AI to categorize your spending, extract crucial details, and provide instant summaries.
Send Obsidian Notes as Emails with Dynamic Attachments
This workflow empowers you to transform your Obsidian notes into dynamic emails, complete with custom metadata from YAML frontmatter and automated attachment handling. Seamlessly share your thoughts and files directly from your preferred note-taking environment.
Automate Your Daily Briefing: News, Emails, and Tasks
Streamline your day by automatically fetching the latest news from Times of India, important emails from your Gmail, and your upcoming Todoist tasks. Get a consolidated, beautifully formatted daily digest delivered straight to your inbox.