flowtemplates

n8n · Data Sync

Fetch and extract API data

  • n8n
  • beginner
  • 3 nodes
  • ~3 min setup
Download .json Free · no signup

Tested on n8n 2.25.7 · Last verified 2026-06-21 · v1.0

The workflow: Manual Trigger → HTTP Request → Edit Fields n8n
  1. Trigger Manual Trigger Run on demand Swap for a Schedule Trigger to run on a timer
  2. Action HTTP Request GET a public API Sends a User-Agent header; no auth needed
  3. Action Edit Fields (Set) Extract the fields you need Map nested JSON into flat items
The exact node chain — verified on n8n 2.25.7.

What it does

Call any public REST API and pull just the fields you need into clean items. This example fetches USD exchange rates and extracts the date and EUR rate — swap the URL for any API, and the Manual Trigger for a Schedule to run it on a timer.

  • Manual Trigger
  • HTTP Request
  • Edit Fields

How to import it into n8n

  1. Copy the workflow JSON Use the Copy JSON button above (or download the .json file).
  2. Open your n8n canvas In n8n, open Workflows and create a new, empty workflow.
  3. Paste to import Press Ctrl/Cmd+V on the canvas, or use the ⋯ menu → Import from File / Import from URL. n8n recreates every node.
  4. Connect your credentials Open each node flagged with a credential placeholder and select your own account — see the credentials table below.
  5. Test, then activate Run once with test data to confirm the path end-to-end, then toggle the workflow Active.

Notes for this template

  • Swap the URL in the HTTP Request node for any API you want to pull from.
  • Replace the Manual Trigger with a Schedule Trigger to run it on a timer (e.g. daily at 08:00).
  • Edit the "Edit Fields" node to extract the exact fields your API returns.
  • For APIs that need a key, add it under the HTTP Request node’s Authentication — this example needs none.

Credentials you’ll connect

No external credentials required.

Live execute on n8n 2.25.7

Request

GET https://api.frankfurter.app/latest?from=USD&to=EUR

Response

{ "base": "USD", "date": "2026-06-19", "usd_to_eur": 0.87207 }

Frequently asked questions

Do I need any credentials?

No — this example calls a public API with no authentication. For APIs that need a key, add it in the HTTP Request node.

Can I run it on a schedule?

Yes. Replace the Manual Trigger with a Schedule Trigger and set your interval — the rest of the workflow is unchanged.

Has this really been tested?

Yes. On a real n8n 2.25.7 instance it called the live API and extracted the fields shown above.

How do I extract different fields?

Edit the "Edit Fields" node — reference any path from the API response with an expression like {{ $json.some.field }}.

Is it free?

Yes — free to download and use, no signup and no email required.

More Data Sync templates