Skip to main content

Track and visualize daily moods with GPT-4o, Wolfram Alpha, Sheets, and Slack

Workflow preview

Workflow preview
100%
Track and visualize daily moods with GPT-4o, Wolfram Alpha, Sheets, and Slack preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

This workflow, "Mood Graph Studio," offers a comprehensive solution to track and visualize your emotional well being. By simply inputting a single sentence about your mood, this template uses AI to...

Best for

  • Personal Productivity automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.webhook, n8n-nodes-base.set, n8n-nodes-base.httprequest, n8n-nodes-base.googlesheets, n8n-nodes-base.respondtowebhook, n8n-nodes-base.code, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenai

Source and attribution

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

Original n8n.io source

1.1 Workflow description

Title
Track and visualize daily moods with GPT-4o, Wolfram Alpha, Sheets, and Slack
Workflow name
Track and visualize daily moods with GPT-4o, Wolfram Alpha, Sheets, and Slack

Overview

This workflow, "Mood Graph Studio," offers a comprehensive solution to track and visualize your emotional well-being. By simply inputting a single sentence about your mood, this template uses AI to perform a sentiment analysis, generates a visual graph via Wolfram Alpha, provides personalized feedback, and logs everything to Google Sheets.

It is designed for anyone interested in mindfulness, self-reflection, or quantified self-tracking.

How It Works

The workflow is divided into two main API functionalities and a manual trigger for easy testing.

  1. Analyze a Single Mood (/mood endpoint)
  • An AI Agent (OpenAI) quantifies your mood text into valence (positivity) and energy (activity).
  • A query is sent to Wolfram Alpha to generate a simple linear graph based on the score.
  • A second AI Agent provides short, encouraging advice in Japanese.
  • The complete entry is logged as a new row in Google Sheets.
  • Returns a JSON response containing the full analysis and the graph image.
  1. Generate Mood History Graph (/history endpoint)
  • Retrieves historical mood data for a specified user from Google Sheets.
  • A Code node formats the data into a time-series plot query.
  • Wolfram Alpha generates a line graph visualizing the mood trend over time.
  • The resulting graph is automatically posted to Slack.

How to Set Up

1. Credentials

You must add your own credentials for the following services in the respective nodes:

  • OpenAI: Used in both Chat Model nodes.
  • Google Sheets: Used in the "Log Mood" and "Get History" nodes.
  • Slack: Used in the "Send History" node.

2. Wolfram Alpha App ID

This workflow uses the HTTP Request node to call the Wolfram Alpha API.

3. Google Sheet Configuration

  • Create a new Google Sheet.
  • Paste the Sheet ID into the Document ID field in both Google Sheets nodes.
  • Crucially, ensure the first row has the following headers exactly (case-sensitive): userId, moodText, valence, energy, createdAt, wolframQuery, feedback

How to Use

For Testing: Use the Manual Trigger. Modify the sample text in the "Set Test Data" node and click "Execute Workflow" on the canvas.

For Production: Activate the workflow. Send POST requests to the Production URL of the Webhook nodes.

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 - Webhook: Mood Input

Type / Role
n8n-nodes-base.webhook - webhook
Config choices
Version 2.1

Block 2 - Parse AI Response

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 3 - Prepare Data Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 4 - Create Wolfram Query

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 5 - Generate Mood Graph

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 6 - Log Mood to Google Sheet

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

Block 7 - Return API Response

Type / Role
n8n-nodes-base.respondToWebhook - respondToWebhook
Config choices
Version 1.4

Block 8 - Webhook: History Request

Type / Role
n8n-nodes-base.webhook - webhook
Config choices
Version 2.1

Block 9 - Get History from Sheet

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

Block 10 - Create Time Series Query

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 11 - Generate History Graph

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 12 - AI: Analyze Mood to Numbers

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3

Block 13 - OpenAI Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 14 - AI: Generate Feedback

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 3

Block 15 - OpenAI Chat Model1

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 16 - Manual Trigger

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

Block 17 - Set Test Data

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 18 - Mood Graph Studio

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

Block 19 - Sticky Note

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

Block 20 - Sticky Note1

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

Block 21 - Sticky Note2

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

Block 22 - Sticky Note3

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

Block 23 - Sticky Note4

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

Block 24 - Upload a file

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

3. Summary Table

Workflow Track and visualize daily moods with GPT-4o, Wolfram Alpha, Sheets, and Slack
Complexity advanced
Nodes 24
Categories Personal Productivity, AI Summarization
Author koichi nagino
Published 17 Nov 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/10922/10922.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 Track and visualize daily moods with GPT-4o, Wolfram Alpha, Sheets, and Slack do?

This workflow, "Mood Graph Studio," offers a comprehensive solution to track and visualize your emotional well being. By simply inputting a single sentence about your mood, this template uses AI to...

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 Personal Productivity, AI Summarization use case.