n8n Workflow: Summarize Data with OpenRouter AI and Save to Baserow

This n8n workflow demonstrates how to leverage AI for data summarization using OpenRouter and then store the results in Baserow. It provides a flexible setup to process data, generate summaries, and maintain a structured record of the AI-generated content.

What it does

This workflow automates the following steps:

1. Trigger: The workflow can be initiated either manually or on a predefined schedule.
2. Fetch Data (Placeholder): An HTTP Request node is included, typically used to fetch data from an external API or source that needs summarization. Note: The current JSON does not specify the URL or method for this HTTP Request, so it acts as a placeholder for integration with your data source.
3. Prepare Data for AI: A Code node is used to transform or prepare the data fetched from the previous step into a format suitable for the AI model. This might involve extracting specific fields, formatting prompts, or combining information.
4. AI Summarization (OpenRouter): The prepared data is sent to an AI model via OpenRouter (implied by the directory name, though not explicitly an OpenRouter node in the JSON, the HTTP Request node would be configured for this). The AI processes the input and generates a summary.
5. Save to Baserow: The generated AI summary, along with any relevant metadata, is then stored as a new record in a Baserow database.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Baserow Account: Access to a Baserow instance and an API key for authentication. You'll also need a specific database and table set up in Baserow to store the summarized data.
• OpenRouter API Key: An API key for OpenRouter to access their AI models. The HTTP Request node will need to be configured with the appropriate OpenRouter endpoint and authentication.
• Data Source: An API endpoint or data source from which you want to fetch data for summarization (to be configured in the HTTP Request node).

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots menu (...) and select "Import from JSON".
   • Paste the JSON code and click "Import".
2. Configure Credentials:
   • Baserow: You will need to set up a Baserow credential. In n8n, go to "Credentials", click "New Credential", search for "Baserow", and provide your API Key.
   • OpenRouter (via HTTP Request): The HTTP Request node will need to be configured with the OpenRouter API endpoint, method (likely POST), headers (including your API key for authentication), and the body containing your prompt and data for summarization. You may need to create a generic "API Key" credential if OpenRouter requires a custom header for its key.
3. Configure Nodes:
   • HTTP Request (Data Source): Update this node to connect to your specific data source. Provide the URL, method (GET/POST), headers, and any authentication required to fetch the data you want to summarize.
   • Code: Modify the JavaScript code within this node to correctly extract and format the data from the previous HTTP Request node for your AI prompt. This is where you'll construct the prompt sent to OpenRouter.
   • Baserow:
     • Select your Baserow credential.
     • Specify the Database ID and Table ID where you want to save the summarized data.
     • Map the fields from the AI's output (from the Code node) to the columns in your Baserow table.
4. Activate the Workflow:
   • Once all configurations are complete, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.
5. Execution:
   • Manual Trigger: Click "Execute Workflow" to run it manually.
   • Schedule Trigger: Configure the "Schedule Trigger" node to run the workflow at your desired intervals (e.g., daily, hourly).

This workflow provides a robust framework for integrating AI summarization into your data management processes with Baserow.