Pulling Data From Services That N8N Doesnt Have A Pre Built Integration For

Who is this for?

You own automation pulling 20 pages from a tool with no connector on manual run, and this HTTP pagination workflow loops, fetches and logs to Sheets. Each pull needs endpoints tested, pages turned, and results pasted.

What problem does this solve?

You test endpoints, turn pages, then paste results into Sheets. When you run it manually, the flow loops with If-Are-we-finished, fetches each page, extracts fields, and logs to Sheets. You just check the pattern reuse for the next API instead of clicking each page in turn.

What this workflow does

1. HTTP Request - Get Mock Albums (HTTP API)
2. HTTP Request - Get Wikipedia Page (HTTP API)
3. HTTP Request - Get my Stars (HTTP API)
4. Google Sheets - Audit Log (Google Sheets)
- Includes Daniel Grey pack: Slack - Error Alerts, Google Sheets - Audit Log, Wait - Rate Limit, Set - Audit Trail (all wired).

How it works

You run it manually from the n8n editor → Set, HTTP Request - Get my Stars, Item Lists - Fetch Body, ending in If - Are we finished?.

Setup

1. Open danielgrey.shop/app/templates/dg-0035 → Copy JSON → n8n → Import from Clipboard (or Push to n8n)
2. Connect credentials: Google Sheets, Slack
3. Run once manually to verify each branch — it imports clean and goes green first try — then a 10-minute review and activate.

Requirements

- n8n 2.37 or later
- Credentials for Google Sheets, Slack
- Free — import and run.

Customising

- Adjust the branch condition in If - Are we finished? to match your own cutoff.
- Adjust field extraction in Item Lists - Fetch Body for the API you paginate.

v2.0 (Sep 2026, n8n 2.x): Legacy $node[] expressions modernized to $() syntax (n8n 2.x). Tested on n8n 2.37 (2.x).