If your team still copies numbers from Google Sheets into Slack manually, you're losing time that adds up fast. Connecting the two tools through Make.com (formerly Integromat) eliminates that friction entirely. You can trigger a Slack message the moment a row is added, a status changes, or a deadline cell turns red — all without writing a single line of code. This guide walks you through the full setup, from creating your first scenario to adding filters and error handling that make the automation production-ready.
Why Connect Google Sheets to Slack (and When It Saves Hours)
Google Sheets is where data lives. Slack is where decisions happen. When those two systems don't talk, important updates get missed, action items sit unnoticed, and people waste time in status meetings that a well-timed notification would have made unnecessary.
Here are the most common use cases where this automation pays off immediately:
Sales pipeline updates: Notify the sales channel the instant a new lead or closed deal is logged in a shared tracker.
Project status changes: Alert a project manager when a task moves from In Progress to Blocked.
Inventory alerts: Ping the operations team when stock levels in a Google Sheet drop below a threshold.
Form response routing: Automatically post new form submissions (collected in Sheets via Google Forms) to the right Slack channel.
Weekly report delivery: Schedule a Slack digest every Monday morning summarizing the week's KPIs pulled directly from a Sheet.
According to Make.com's own data, their Google Sheets + Slack combination is consistently among the top five most-used automation pairs on the platform — and for good reason. Teams that implement it typically report saving 30–90 minutes per week on manual update communication alone.
Setting Up Your Make.com Scenario: Google Sheets Trigger
Before you start, you'll need three things: a Make.com account (the free tier supports up to 1,000 operations/month and is enough to test this fully), a Google account with a target spreadsheet, and a Slack workspace where you have permission to post messages.
If you don't have a Make.com account yet, you can create one free at Make.com — no credit card required to get started.
Step 1: Create a New Scenario
Log into Make.com and click Create a new scenario from your dashboard.
When the visual editor opens, click the large + circle in the center to add your first module.
In the search bar, type Google Sheets and select it.
Step 2: Choose the Right Trigger
Make.com offers several Google Sheets triggers. Choose based on your use case:
Watch Rows — fires whenever a new row is added. Best for form submissions or new entries.
Watch Changes — fires when any cell in a specified range is modified. Best for status updates.
Search Rows — used for polling-based lookups rather than real-time triggers.
For most notification workflows, Watch Rows is the right starting point.
Step 3: Connect Your Google Account
Click Add next to the Connection field.
Make.com will open a Google OAuth screen — sign in and grant the requested permissions (read access to Sheets).
Once connected, select your Spreadsheet from the dropdown, then choose the specific Sheet (tab) you want to watch.
Set Where to start to All if you want to process existing rows during testing, or From now on for production.
Step 4: Map the Columns
Make.com will automatically detect your column headers on the first run. You'll see fields like Column A, Column B, or named fields if your Sheet has a header row. Note these field names — you'll use them to build your Slack message in the next step.
Configuring the Slack Action: Sending Dynamic Messages
With your trigger configured, it's time to add the action that posts to Slack.
Step 5: Add the Slack Module
Click the + button after your Google Sheets trigger to add a second module.
Search for Slack and select it.
Choose the action Create a Message.
Step 6: Connect Your Slack Workspace
Click Add next to the Connection field.
Make.com will redirect you to Slack's OAuth page — authorize the app to post messages.
Choose whether to post as a bot (recommended) or as your personal account.
Step 7: Build Your Dynamic Message
This is where the automation becomes powerful. Instead of a static message, you'll use data from the Google Sheets trigger to build context-rich notifications.
In the Channel field, type or select the Slack channel where messages should appear (e.g., #sales-alerts).
In the Text field, click inside the input and use the variable picker to insert fields from your Sheet. A message might look like: New lead added: [Customer Name] from [Company] — deal value $[Amount]. Assigned to [Owner].
Optionally, set a Bot name (e.g., Sheets Bot) and upload a custom emoji or icon URL to make the notification visually distinct.
Step 8: Test the Scenario
Click Run once in the bottom toolbar.
Make.com will execute one cycle — it will read the most recent row from your Sheet and attempt to post to Slack.
Check your Slack channel for the notification. If it appeared, your core flow works.
Click Save and then Schedule to set how often Make.com checks for new rows (every 15 minutes on the free tier; paid plans support 1-minute intervals).
Advanced Tips: Filters, Formatters, and Error Handling
A basic scenario works, but production automations need guard rails. Here's how to add them.
Using Filters to Control When Notifications Fire
Filters let you add conditions between modules so the Slack message only sends when specific criteria are met.
Click the small filter icon (a funnel) on the arrow between your Google Sheets and Slack modules.
Set conditions like: Status equals Closed Won, or Amount is greater than 1000.
You can chain multiple conditions using AND/OR logic.
This prevents notification spam — your team only gets pinged when it actually matters.
Formatting Data with Make.com's Built-In Tools
Raw spreadsheet data is often messy. Make.com's Tools module lets you clean it up before it reaches Slack.
Use formatDate to convert serial date numbers into readable strings like March 15, 2025.
Use number formatting to turn 10000 into $10,000.
Use trim() to strip accidental whitespace from text fields.
Access these by adding a Tools > Set Multiple Variables module between your trigger and action.
Handling Errors Gracefully
Even well-built scenarios fail occasionally — a Slack API timeout, a deleted Sheet tab, an OAuth token expiring. Set up error handling so you're not caught off guard:
Right-click your Slack module and select Add error handler.
Choose Resume to skip failed operations silently, or Rollback to retry.
For critical workflows, add an Email or secondary Slack module in the error handler branch to alert you when something breaks.
Enable Incomplete Executions in your scenario settings — Make.com stores failed runs so you can replay them manually once the issue is resolved.
Scheduling vs. Instant Triggers
By default, Make.com polls Google Sheets on a schedule. If you need truly instant notifications (under 60 seconds), consider using a Google Apps Script webhook to push data to Make.com's Custom Webhook trigger instead of relying on polling. This approach requires a small script in your Sheet but eliminates polling delays entirely.
FAQ
How many operations does this automation use per month?
Each trigger check counts as one operation, and each Slack message sent counts as one more. A scenario that checks every 15 minutes and sends 10 messages per day uses roughly 3,000 operations per month — just over Make.com's free tier limit of 1,000. A Core plan ($9/month) includes 10,000 operations, which comfortably covers most small teams.
Can I send Slack messages to different channels based on the row data?
Yes. In the Slack module's Channel field, use a dynamic variable from your Sheet (e.g., a Slack Channel column that contains #sales, #ops, etc.) instead of a hardcoded channel name. Make.com will route each notification to the correct channel automatically.
What happens if my Google Sheet has thousands of existing rows?
When you first activate a Watch Rows trigger, Make.com asks where to start. Setting it to From now on ensures it only processes rows added after activation — it won't flood Slack with thousands of old entries.
Do I need a paid Slack plan?
No. The Make.com Slack integration works with free Slack workspaces. The only limitation is that free Slack workspaces cap message history at 90 days, but that's unrelated to the automation itself.
Can I format Slack messages with bold text or bullet points?
Yes. Slack uses mrkdwn format — wrap text in asterisks for bold, underscores for italics, and use bullet characters for lists. You can embed these formatting markers directly in the Make.com text field alongside your dynamic variables.
Conclusion
Automating Slack notifications from Google Sheets with Make.com is one of the highest-ROI automations you can build in under an hour. Once live, it eliminates manual update cycles, reduces missed information, and keeps your team reacting to data in real time instead of hunting for it.
Start with a single trigger and one Slack channel. Add filters to keep notifications relevant. Then expand — multiple Sheets, multiple channels, error handling, and scheduling — as your confidence grows.
Ready to get started? Create your free Make.com account and build your first scenario today.