How can I paginate the HTTP Request node to update a Google Sheet with successive API calls?

Below is an example of how to configure the HTTP Request node to update the page query parameter on each request using pagination:

1. Enable Pagination
   In your HTTP Request node, open the node’s settings and select Add Option > Pagination.

2. Configure Pagination Mode
   Set Pagination Mode to Update a Parameter in Each Request.

3. Set the Parameter Type
   Choose Query since your API expects a query parameter.

4. Configure the Query Parameter

   • For Name, enter page (or the exact key required by your API).

   • Hover over the Value field, toggle Expression on, and enter the following expression:

     JAVASCRIPTCopied
     {{ $pageCount + 1 }}

   This tells n8n to start with page 1 on the first request (since $pageCount starts at 0) and increment the page number on each subsequent request.

5. Finalize and Test
   Save your configuration and run the workflow. With these settings, n8n should automatically fetch page 1, then page 2, and so on, allowing your subsequent nodes (like your Google Sheet node) to receive and process all records.

Make sure that the API’s response structure supports this pagination strategy. If your API provides a URL for the next page instead, consider using the Response Contains Next URL mode with a corresponding expression.

This setup should resolve the issue where only the first 10 records are being fetched.