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.
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.
AI-Powered Abandoned Cart Recovery & Nurturing
This n8n workflow intelligently identifies customers who've abandoned their shopping carts, leverages AI to craft personalized recovery emails, and automatically sends them. It then logs all activity to Google Sheets for seamless tracking and optimization of your sales recovery efforts.
AI-Powered Amazon Competitor Review Analysis
Automate competitor insights by scraping Amazon product reviews, storing them in Google Sheets, and leveraging AI for intelligent summarization. This workflow provides a seamless solution to stay ahead of the competition and inform your product strategy with real-time customer feedback.
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.