Developer & DevOps
Schedule Mattermost messages export to Google Sheets
4 nodes
290
163
Scheduled trigger
Workflow Description
Automates periodic extraction of messages from Mattermost channels on a defined schedule, processes them through a custom function, and automatically stores the data in Google Sheets for documentation and analysis purposes.
How it works
- 1.Interval trigger executes the automation at scheduled times
- 2.Retrieves messages from specified Mattermost channels via API
- 3.Processes extracted data using a custom function for formatting
- 4.Appends formatted messages to Google Sheets spreadsheet
Use cases
- Archive team channel discussions for compliance and audit trails
- Create searchable documentation of decisions and important conversations
- Build a centralized communication log accessible to stakeholders
Requirements
- Active Mattermost account with message access permissions
- Google account with edit permissions on target spreadsheet
- API credentials and authentication tokens for both services
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Mattermost
Google Sheets
Interval
Details
Trigger
Scheduled trigger
Nodes
4
Apps
3
Views
290
Downloads
163
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (4)
Send message
Mattermost
Check if new data
Function
Read data
Google Sheets
Execute every 45 mins
Interval