Skip to main content

Generate AI math RPG quests from study logs with Google Sheets and OpenRouter

Workflow preview

Workflow preview
100%
Generate AI math RPG quests from study logs with Google Sheets and OpenRouter preview
Open on n8n.io

1. Workflow Overview

Generate AI math RPG quests from study logs in Google Sheets Who it's for This template is for educators, parents, or self learners who want to gamify their study routines. It turns boring study lo...

Best for

  • Content Creation automation workflows
  • Multimodal AI automation workflows
  • intermediate n8n builders looking for reusable templates

Tools used

@n8n/n8n-nodes-langchain.chainllm, @n8n/n8n-nodes-langchain.lmchatopenrouter, @n8n/n8n-nodes-langchain.outputparserstructured, n8n-nodes-base.googlesheets, n8n-nodes-base.formtrigger, n8n-nodes-base.stickynote

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by TAKUTO ISHIKAWA.

Original n8n.io source

1.1 Workflow description

Title
Generate AI math RPG quests from study logs with Google Sheets and OpenRouter
Workflow name
Generate AI math RPG quests from study logs with Google Sheets and OpenRouter

Generate AI math RPG quests from study logs in Google Sheets

Who it's for

This template is for educators, parents, or self-learners who want to gamify their study routines. It turns boring study logs into an interactive RPG math battle using AI.

How it works

This system consists of two workflows (Part 1: Quest Generation, Part 2: Quiz Battle). In this workflow, when a user submits their study time via an n8n Form, the system logs the data into Google Sheets, calculates total EXP, and retrieves the user's current level. Then, it uses a Basic LLM Chain to generate a math question tailored to that level, along with an RPG-style monster and flavor text. The generated quest is saved back to Google Sheets with a pending status, ready for the user to answer.

How to set up

  1. Create a Google Sheet with three tabs: StudyLogs, Users, and Quests.
  2. Connect your Google Sheets credential and select your spreadsheet in all Google Sheets nodes.
  3. Connect your OpenAI or OpenRouter credential.
  4. Run the "Study Log Input Form" to generate your first monster!

Requirements

  • A Google account (for Google Sheets)
  • An OpenAI or OpenRouter API key

How to customize the workflow

You can easily change the prompt in the "Generate RPG Quest" node to create language quizzes, history trivia, or any other subject instead of math!

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Basic LLM Chain

Type / Role
@n8n/n8n-nodes-langchain.chainLlm - chainLlm
Config choices
Version 1.7

Block 2 - OpenRouter Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenRouter - lmChatOpenRouter
Config choices
Version 1

Block 3 - Structured Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 4 - Add to StudyLogs

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 5 - Get User Status

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 6 - Save Quest

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 7 - Study Log Input Form

Type / Role
n8n-nodes-base.formTrigger - formTrigger
Config choices
Version 2.3

Block 8 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 10 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Generate AI math RPG quests from study logs with Google Sheets and OpenRouter
Complexity intermediate
Nodes 11
Categories Content Creation, Multimodal AI
Author TAKUTO ISHIKAWA
Published 20 Mar 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/14193/14193.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Generate AI math RPG quests from study logs with Google Sheets and OpenRouter do?

Generate AI math RPG quests from study logs in Google Sheets Who it's for This template is for educators, parents, or self learners who want to gamify their study routines. It turns boring study lo...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Multimodal AI use case.