Leo has the n8n assistant, powered by Gemini 4 Argon, build a quote request workflow that scores leads, drafts email replies, stores results in a data table and pings Slack for urgent ones.
Build a scheduled daily weather-log workflow in n8n
Oli Morris builds an n8n workflow that fetches Berlin's weather at 8 a.m. every day, turns it into a one-line report and saves it to a data table, first by prompting the n8n Assistant, then node by node by hand.
n8n · YouTube · published Oct 30, 2026 · Automation & Agents
▶ Watch on YouTubePrompt
Build a workflow called Weather Log that runs every day at 8:00 a.m. Get the weather for Berlin from this URL: <your weather API URL>. Add a report field with the city, temperature and conditions, for example "The temperature in Berlin is 10 degrees C and it's currently overcast." Then save the data to a new data table.
Visual breakdown
Oli Morris builds the same workflow twice in n8n: once by prompting the n8n Assistant, once by hand. It runs every morning at 8:00, fetches Berlin's weather, formats a one-line report and saves it to a data table.
The problem: You want a small automation that runs on its own every day, and you want to understand how n8n workflows actually work.
The Berlin weather workflow, node by node
- Schedule triggerStarts the workflow every day at 8:00 a.m., renamed "Every day at 8:00 a.m."
- HTTP RequestCalls the weather endpoint and returns city, date, temperature, humidity, wind, conditions
- Edit FieldsAdds a report field using expressions like {{ $json.city }} dragged from the input
- Data table: Insert RowMaps the incoming report to a Report column automatically
- Published workflowAdds a new weather row each morning once published
Data / toolsSetup / manualAI agentResult
Concepts explained
- A workflow is a collection of connected nodes; a node does one action
- An expression is a snippet swapped for its real value at run time
- All data in n8n is a JSON object passed from node to node
- Rename nodes as you go so the workflow reads clearly
By the numbers
Build it yourself
Do it once with the n8n Assistant, then once by hand to see what happens on the canvas.
- In n8n Assistant, write the prompt: workflow name, 8:00 a.m. schedule, weather URL, report format, save to a data table
- Allow the Assistant's permission requests, including creating the data table and a test run
- Check the data table for the new row, then ask the Assistant to publish it
- By hand: add a Schedule trigger at 8:00 a.m., an HTTP Request node, and an Edit Fields node
- Create a data table with a Report column and add an Insert Row node with automatic mapping
- Execute end to end, rename the workflow and press Publish
Published workflows run on the schedule you defined.
Tips from the video
- Rename nodes as you go so each one says what it does.
- Use Execute step on each node to check its output before moving on.
- Drag fields from the input panel to build expressions instead of typing them.
- A workflow that isn't published won't run on its schedule.
- The Assistant asks permission before acting, and offers to run a test.
Jump to the part you need
0:00Build a Berlin weather workflow0:31Create with n8n Assistant1:28Write the workflow prompt2:54Approve and test actions4:07Publish the Assistant workflow5:05Build the workflow manually6:33Fetch weather with HTTP Request8:18Create reports with expressions11:19Understand data flow and JSON12:24Store reports in data tables14:42Publish the scheduled workflow
Distilled from the video’s captions
How to try it
- Open n8n.
- Copy the prompt and fill in the [placeholders].
- Watch n8n's video for the full walkthrough and setup.
Related use cases
Liam asks the n8n Assistant in plain language for a workflow that posts a Slack bot message on every new GitHub star, then tests, publishes and verifies it.