TimescaleDB ISS Data Retrieval
detail.loadingPreview
Retrieves International Space Station (ISS) latitude, longitude, and timestamp data from a TimescaleDB instance.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow connects to a TimescaleDB database to retrieve specific columns (latitude, longitude, timestamp) from the 'iss' table. It's designed to fetch real-time or historical ISS location data.
Key Features
- Connects to TimescaleDB using provided credentials.
- Selects specific columns from the 'iss' table.
- Triggers execution every minute to ensure up-to-date data.
- Includes basic error handling for workflow execution failures.
How To Use
- Configure your TimescaleDB credentials in n8n.
- Ensure the 'iss' table exists and contains 'latitude', 'longitude', and 'timestamp' columns.
- Set the
BASE_URLenvironment variable if the HTTP Request node is intended for use (currently unused in core logic). - Adjust the Cron trigger frequency as needed.
Apps Used
Workflow JSON
{
"id": "7454b9c4-77cf-422f-baae-fd74fa91a58b",
"name": "TimescaleDB ISS Data Retrieval",
"nodes": 0,
"category": "Database & Data",
"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: 7454b9c4-77cf...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automated Multi-Platform Influencer Discovery & Qualification
This powerful n8n workflow automates the entire process of discovering, scoring, and qualifying ideal influencers across Instagram, TikTok, and YouTube for your marketing campaigns. Streamline your talent acquisition by leveraging custom criteria and a sophisticated scoring algorithm.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
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.
AI-Powered Accounts Receivable Reporting for Sabre EDI
This n8n workflow automates the extraction of Accounts Receivable (AR) data from complex Sabre EDI (Interface User Record) files stored in Google Drive. It leverages an AI agent, powered by OpenAI, to intelligently process financial information and generate structured AR reports. The workflow ensures accuracy by utilizing a Pinecone vector database for contextual understanding of EDI guidelines.
Automate JSON Data Import to Google Sheets
Seamlessly import data from local JSON files directly into Google Sheets. This workflow automates the process of reading structured JSON data and appending it to your chosen spreadsheet, keeping your data up-to-date effortlessly.