n8n Daily Mood Tracker with AI Analysis and Reports

This n8n workflow provides a robust system for tracking daily moods, analyzing them using AI, storing the data, and generating reports. It allows users to log their mood via a webhook, which then triggers an AI analysis of the mood description, stores the data in a data table, and can optionally send a daily summary report via email.

What it does

This workflow automates the following steps:

1. Receives Mood Entries: It listens for incoming mood entries via a webhook, which typically includes a mood description.
2. Sets Initial Data: It prepares the incoming data, potentially adding a timestamp or other default fields.
3. Analyzes Mood with AI: It sends the mood description to OpenAI for sentiment analysis or other relevant AI processing, extracting insights like sentiment, keywords, or a summary.
4. Stores Data: It records the original mood entry and the AI analysis results into an n8n Data Table for persistent storage.
5. Generates Daily Report (Optional): On a scheduled basis (e.g., daily), it can retrieve all mood entries from the Data Table.
6. Summarizes Report (Optional): It can use OpenAI to generate a summary or analysis of the collected mood data for the reporting period.
7. Sends Email Report (Optional): It can then send this summary report via Gmail to a specified recipient.
8. Responds to Webhook: After processing, it sends a response back to the initial webhook caller, confirming receipt and processing.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• OpenAI API Key: For the OpenAI node to analyze mood descriptions.
• Gmail Account: Configured as a credential in n8n if you wish to send email reports.
• n8n Data Table: This workflow utilizes a built-in n8n Data Table for storage. No external database is strictly required, but you could adapt it to use one.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the "Import from JSON" button and paste the workflow JSON or upload the file.
2. Configure Credentials:
   • OpenAI: Create an OpenAI credential in n8n and select it in the OpenAI node.
   • Gmail: Create a Gmail OAuth2 credential in n8n and select it in the Gmail node if you plan to use email reports.
3. Configure Webhook:
   • The "Webhook" node will generate a unique URL when activated. This URL is where you will send your mood entries (e.g., from a custom application, a form, or another automation).
   • Ensure the webhook is set to the appropriate HTTP method (e.g., POST) and expects the mood data in its body.
4. Configure Data Table:
   • The "Data table" node will automatically create a table if it doesn't exist. You might want to define the schema in the node configuration to match the data you expect to store (e.g., moodDescription, sentiment, timestamp).
5. Configure Schedule Trigger (for reports):
   • The "Schedule Trigger" node is currently not connected in the provided JSON, but it's present. To enable daily reports, connect it to the relevant nodes (e.g., "Data table" to read data, "OpenAI" to summarize, "Gmail" to send). Configure its interval (e.g., daily at a specific time).
6. Activate the Workflow:
   • Once configured, activate the workflow by toggling the "Active" switch in the top right corner of the n8n editor.

Example Webhook Payload

To trigger the mood logging part of the workflow, you would send a POST request to the Webhook URL with a JSON body similar to this:

{
  "moodDescription": "I had a fantastic day today! Everything went smoothly and I felt very productive. Really happy with my progress."
}