Personalized Baserow Calendar View Generator - n8n Workflow

Baserow power users and administrators needing scalable view generation.
Operations specialists who manage tasks, appointments, or deadlines for individual team members or clients.
Users looking for high-level technical n8n templates that involve complex API interactions and authentication.
Developers who need to dynamically create and configure database views without manual intervention.

Managing deadlines, appointments, or tasks across many different entities (like employees or customers) can become cumbersome when views are not personalized. This n8n workflow solves this by automating the creation of personalized calendar views in Baserow. Instead of manually creating filtered views for every employee or customer, this powerful n8n automation leverages the Baserow API to generate a unique calendar view and a corresponding shareable ICS feed URL for every record in a designated 'Filter table'.

This specific n8n workflow handles authentication using a JWT token derived from Baserow credentials, ensuring secure communication across all steps. It is a prime example of leveraging the n8n node structure to manage configuration variables and sequential API calls, providing reusable n8n templates for complex database operations.

This comprehensive n8n workflow executes a multi-step process involving data setup, authentication, iteration, and API interaction to configure Baserow views.

1. Trigger and Credentials: The n8n workflow is initiated by the Manual n8n trigger. Following the trigger, the 'Set Baserow credentials' n8n node configures the API host, username, and password.


2. Authentication: The 'Create a token' HTTP Request n8n node uses the credentials to call the Baserow authentication endpoint, retrieving a required JWT access token.


3. Configuration: The 'Set table and field ids' n8n node stores the JWT token alongside crucial Baserow IDs (Database ID, Date table ID, Filter field ID, etc.).


4. Iteration Setup: The 'Get all records from filter table' Baserow n8n node fetches all records from the table you wish to filter upon (e.g., a list of Employees). The subsequent steps will run for every item returned.


5. View Creation: The 'Create new calendar view' HTTP Request n8n node calls the Baserow API to instantiate a new calendar view for the 'Date table', dynamically naming it using the current item's name.


6. Personalization Filter: The 'Create filter' HTTP Request n8n node applies a critical filter to the newly created view, linking it back to the specific record currently being processed (using the linkrowhas type filter). This ensures the view is personalized.


7. Decoration and Sharing (Optional): Subsequent HTTP Request n8n nodes ('Set background color' and 'Share the view') optionally apply background color decorations based on a status field and, crucially, make the calendar public (ical_public: true) to generate the ICS feed URL.


8. Final Update: The final 'Update the url's' Baserow n8n node updates the original record in the 'Filter table' with the newly generated ICS feed URL and the Baserow view link, completing the automated process for that item.

To install and execute this advanced n8n workflow, follow these steps:

1. Import: Copy the JSON provided and import it into your n8n instance via the 'Import Workflow' option.


2. Baserow Credentials: Locate the 'Set Baserow credentials' n8n node. Replace the placeholder values username> and password> with your actual Baserow login details. Verify the 'API host' path.


3. Baserow API Connection: Ensure you have a Baserow API credential configured in n8n (used by the Baserow n8n node).


4. Configure IDs: Open the 'Set table and field ids' n8n node. You must replace the sample numeric values with the actual IDs from your Baserow setup:

1. Execution: Once configured, you can test the entire n8n workflow using the 'Execute Workflow' button on the manual n8n trigger.

This n8n workflow relies on a mix of foundational and specialized n8n node types to achieve API-driven configuration:

When clicking ‘Execute workflow’ (Manual Trigger n8n trigger):
Function: Starts the n8n workflow manually for testing and initial setup.
Key Configuration: Simple, designed to be easily swapped out for a webhook or schedule n8n trigger for production.

Set Baserow credentials / Set table and field ids (Set n8n node):
Function: Used extensively for managing environment variables, credentials, and Baserow IDs, passing them securely between n8n nodes.
Key Configuration: Stores JWT Token prefix JWT {{ $json.accesstoken }} and numerous numeric Baserow resource IDs.

Create a token / Create new calendar view / Create filter / Share the view (HTTP Request n8n node):
Function: Performs critical API interactions with the Baserow service, essential for authentication and dynamic view creation/configuration.
Key Configuration: Each n8n node uses dynamic expressions (={{$('Node Name').item.json[...]}}) to construct the URL, headers (Authorization: JWT Token), and JSON body for API calls. For example, Create filter uses type: linkrowhas and dynamically references the ID of the record currently being iterated upon.

Get all records from filter table (Baserow n8n node):
Function: Fetches the list of entities (e.g., customers or employees) for whom personalized views must be generated. This n8n node dictates the number of iterations for the rest of the workflow.

Update the url's (Baserow n8n node):
Function: Updates the original record with the outputs of the API process, storing the newly created icalfeed_url and Baserow view link.
Key Configuration: Operation: update, uses dynamic field IDs (e.g., Ics field) and the row ID of the current item to ensure precise data update.