Track Vendor Inquiries Automatically in Google Sheets
Vendor questions get mixed with regular chat and important details get forgotten. This automation appends vendor inquiries to a tracking sheet so you have a complete record and can respond systematically.
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 managing multiple vendor relationships in Slack lose track of pending questions and deadlines, leading to slow vendor relationships and missed deadlines.
- All vendor inquiries in one organized sheet
- Track response time and follow-up status
- Build a vendor relationship history
- Reduce time spent searching Slack for vendor questions
- Systematic approach to vendor management
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 #vendors or #partnerships channel.
- 4Write your prompt: 'When a vendor shares an inquiry or question, append the date, vendor name, category (pricing, technical, delivery, etc.), the question, and status (Pending) to my vendor tracking sheet.'
- 5Send a test vendor inquiry and verify it logs correctly.
Questions about this workflow
Can I track vendor response deadlines automatically?
Yes. Ask Notis to include a 'Due Date' column and calculate it based on your policy (e.g., '3 business days from today'). You can then filter Sheets to show overdue items.
Should I create separate sheets for different vendor types?
Absolutely. You can create automations for different vendors or vendor categories, each logging to its own sheet for easier management.
How do I know when to follow up with a vendor?
Set up a weekly Google Sheets reminder, or create a second Notis automation that reads your vendor sheet and alerts you about items still marked Pending after 5 days.
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.