Workflow: automate with n8n workflow for Http Googlebigquery Automation Scheduled
Integrations: cron, googleBigQuery, httpRequest, set

{"nodes": [{"name": "Google BigQuery", "type": "n8n-nodes-base.googleBigQuery", "position": [1010, 240], "parameters": {"columns": "name, latitude, longitude, timestamp", "options": {}, "tableId": "position", "datasetId": "iss", "projectId": "supple-cabinet-289219"}, "credentials": {"googleBigQueryOAuth2Api": "BigQuery Credentials"}, "typeVersion": 1}, {"name": "Set", "type": "n8n-nodes-base.set", "position": [810, 240], "parameters": {"values": {"number": [{"name": "latitude", "value": "={{$node[\"HTTP Request\"].json[\"0\"][\"latitude\"]}}"}, {"name": "longitude", "value": "={{$node[\"HTTP Request\"].json[\"0\"][\"longitude\"]}}"}, {"name": "timestamp", "value": "={{$node[\"HTTP Request\"].json[\"0\"][\"timestamp\"]}}"}], "string": [{"name": "name", "value": "={{$json[\"0\"][\"name\"]}}"}]}, "options": {}, "keepOnlySet": true}, "typeVersion": 1}, {"name": "HTTP Request", "type": "n8n-nodes-base.httpRequest", "position": [610, 240], "parameters": {"url": "https://api.wheretheiss.at/v1/satellites/25544/positions", "options": {}, "queryParametersUi": {"parameter": [{"name": "timestamps", "value": "={{Date.now();}}"}]}}, "typeVersion": 1}, {"name": "Cron", "type": "n8n-nodes-base.cron", "position": [410, 240], "parameters": {"triggerTimes": {"item": [{"mode": "everyMinute"}]}}, "typeVersion": 1}], "connections": {"Set": {"main": [[{"node": "Google BigQuery", "type": "main", "index": 0}]]}, "Cron": {"main": [[{"node": "HTTP Request", "type": "main", "index": 0}]]}, "HTTP Request": {"main": [[{"node": "Set", "type": "main", "index": 0}]]}}}