Templates / Benchmark LLM performance on legal documents with Google Sheets and OpenRouter

Benchmark LLM performance on legal documents with Google Sheets and OpenRouter

Ready for 3.0

by Adam Janes ✓ · 860 views · created 2025-06-20 · Engineering, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

Nodes used (13)

Google SheetsStructured Output ParserBasic LLM ChainGoogle DriveOpenRouter Chat Model

What it does

This workflow demonstrates a simple way to run evals on a set of test cases stored in a Google Sheet. The example we are using comes from an info extraction task dataset, where we tested 6 different LLMs on 18 different test cases. This workflow extends the functionality of my simple eval for benchmarking legal tasks here. Rather than running executions sequentially (waiting for each one to respond before making another request), we use parallel processing to fire 2 requests every second. You can see our sample data in this spreadsheet here to get started. Once you have this working for our dataset, you can plug in your own test cases matching different LLMs to see how it works with your own data. How it works - Pull our test cases from Google Sheets. - For each case, fire off an HTTP request to a webhook. - That webhook grabs the relevant source file from Google Drive and converts it to text. - The text gets sent to an LLM via Open Router (so we can easily swap out models). - Results come back and are logged in Google Sheets. Set up steps: - Add your credentials for Google Sheets, Google Drive, and OpenRouter. - Make a copy of the original data spreadsheet so that you can edit it yourself. You will need to plug your version in the Update Results node to see the spreadsheet update on each run of the loop.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.