Log Team Updates Automatically to Google Sheets
Team updates scatter across Slack and get lost. This automation captures team update announcements posted in your #updates channel and appends them to a tracking sheet so you have a searchable team update history.
Trigger
Channel Message Received
Triggered when a message is posted in a Slack channel (public, private, or multi-party IM). Does NOT match direct messages.
Action
Append Values to Spreadsheet
Tool to append values to a spreadsheet. use when you need to add new data to the end of an existing table in a google sheet.
Why this helps
ADHD founders miss team announcements in Slack and can't quickly reference what was communicated when, leading to miscommunication and rehashing of updates.
- Searchable team update history
- No manual update transcription
- Single source of truth for announcements
- Easy to reference past updates
- Reduce re-explaining updates
Setup
Build it in a few focused steps.
- 1Connect Slack and Google Sheets to Notis.
- 2Create a new automation with 'Channel Message Received' as the trigger.
- 3Set it to monitor your #team-updates or #announcements channel.
- 4Write your prompt: 'When an update is posted, append the date, update category (hiring, product, process, culture, etc.), the update text, and posted by (the person's name) to my team updates sheet.'
- 5Test by posting a sample update and confirming it appears in Sheets.
Questions about this workflow
How do I filter for actual updates vs. casual chat?
In your automation, specify: 'Only log messages that are at least 2 sentences and include a topic header, or use a specific prefix like "Update:".'
Can I include attachments or links from the Slack message?
Yes. Ask Notis to append a 'Links' column and capture any URLs or file links from the original Slack message.
Should I archive old updates?
You can keep all updates for history or set up a monthly archival process to move older updates to an Archive sheet.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Slack to Google Sheets. A trigger fires from one place; an action lands in another.
Slack triggers
Google Sheets actions
New Channel Created Trigger
Triggered when a new channel is created in Slack.
Add Sheet to Spreadsheet
Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.
Channel Message Received
Triggered when a message is posted in a Slack channel (public, private, or multi-party IM). Does NOT match direct messages.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Direct Message Received
Triggered when a new direct message (DM) is sent to a user in Slack. Catches all DMs across all DM channels.
Append Dimension
Tool to append new rows or columns to a sheet, increasing its size. use when you need to add empty rows or columns to an existing sheet.
Message Reaction Added
Triggered when a reaction is added to a message in Slack. Supports optional filtering by channel and emoji name.
Batch get spreadsheet
Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.
Message Reaction Removed
Triggered when a reaction is removed from a message in Slack. Supports optional filtering by channel and emoji name.
Batch update spreadsheet
Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.
Reaction Added Trigger
DEPRECATED: use `SLACK_MESSAGE_REACTION_ADDED` instead. Triggered when a reaction is added to a message in Slack.
Batch Update Values by Data Filter
Tool to update values in ranges matching data filters. use when you need to update specific data in a google sheet based on criteria rather than fixed cell ranges.
Reaction Removed Trigger
DEPRECATED: use `SLACK_MESSAGE_REACTION_REMOVED` instead. Triggered when a reaction is removed from a message.
Clear Basic Filter
Tool to clear the basic filter from a sheet. use when you need to remove an existing basic filter from a specific sheet within a google spreadsheet.
New Bot Message Received Trigger
DEPRECATED: use `SLACK_CHANNEL_MESSAGE_RECEIVED` with `is_bot_message=true` instead. Triggered when a new bot message is posted to a Slack channel.
Clear spreadsheet values
Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.
Connect any two apps with Notis in the middle.
Not just Slack and Google Sheets. Any combination from 985+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Google Sheets.