Automate Fitness API Weekly Reports with n8n
detail.loadingPreview
This workflow automates the generation of weekly fitness API reports. It uses a Webhook Trigger to receive data, processes it with Text Splitter and Embeddings, stores it in Supabase, and uses an OpenAI Chat Model and RAG Agent to generate a report, finally logging it to Google Sheets. Error handling is included with a Slack Alert.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to automate the process of generating weekly reports from a Fitness API. It leverages a webhook to receive data, employs text splitting and embedding for data processing, and utilizes Supabase for vector storage. The core of the report generation involves an OpenAI Chat Model and a RAG Agent, which process the data and generate a summary. The final report is then appended to a Google Sheet for historical tracking. The workflow includes robust error handling via a Slack alert to notify users of any issues during execution.
Key Features
- Automated Data Ingestion: Receives data from a Fitness API via a Webhook Trigger.
- Intelligent Data Processing: Utilizes Text Splitter and Embeddings (Cohere) for efficient data preparation.
- Vector Storage: Stores processed data embeddings in Supabase for retrieval and context.
- AI-Powered Reporting: Employs OpenAI's Chat Model and RAG Agent for generating insightful weekly reports.
- Automated Logging: Appends the generated report summary to a specified Google Sheet.
- Error Notification: Sends alerts to Slack in case of any workflow execution failures.
How To Use
- Configure Webhook Trigger: Set up your Fitness API to send data to the provided webhook URL.
- Set up Supabase: Ensure your Supabase instance is correctly configured with an API key and a vector table named 'fitness_api_weekly_report'.
- Configure OpenAI and Cohere: Provide your API keys for OpenAI and Cohere in the n8n credentials.
- Set Google Sheets Credentials: Authenticate your Google Sheets account in n8n and specify the Sheet ID and Log sheet name.
- Set Slack Credentials: Configure your Slack API credentials to receive error alerts.
- Activate the Workflow: Once all configurations are in place, activate the n8n workflow.
Apps Used
Workflow JSON
{
"id": "20e27ef5-0d25-4435-9214-daa4a7aae0ee",
"name": "Automate Fitness API Weekly Reports with n8n",
"nodes": 0,
"category": "Data Processing & Automation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 20e27ef5-0d25...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Automate Habit Form Weekly Summary with Webhook and Supabase
This n8n workflow automates the processing of weekly habit form submissions. It uses a Webhook Trigger to receive data, a Text Splitter and Embeddings node to prepare it for vector storage, and Supabase Insert to store it. A RAG Agent then summarizes the data, which is appended to a Google Sheet via Append Sheet, with Slack Alert for errors.
Twitter Sentiment Analysis Pipeline to Database and Slack Notification
Automate Twitter sentiment analysis on #OnThisDay tweets. This workflow fetches tweets, stores them in MongoDB, analyzes sentiment with Google Cloud Natural Language, saves results to PostgreSQL, and notifies Slack based on sentiment score.