How to Send Slack Messages to Google Sheets
Automatically tackle bugs, requests, or feedback by logging Slack messages into a Google Sheet.
Who is this for?
Product managers and support teams tracking issues.
Top Use Cases
- Log bug reports from a #bugs channel directly into a tracker.
- Archive feedback or feature requests for later review.
- Track employee sentiment or kudos given in Slack.
Common Issues & Fixes
Ensure the bot is invited to the specific private channel you are monitoring.
If you add columns to Sheets, refresh the fields in Zapier to map them correctly.
Use a Connector Tool (Zapier/Make)
Direct integration requires a custom bot. The easiest method is using Zapier. Create a new Zap.
Set the Trigger
In Zapier, choose Slack as the trigger app. Select the 'New Message Posted to Channel' event and choose the specific channel (e.g., #bugs).
Set the Action
Choose Google Sheets as the action app. Select 'Create Spreadsheet Row' as the event.
Map the Fields
Connect your Google account. Map the Slack 'Message Text' to the 'Description' column in your Sheet, and 'User Name' to the 'Reporter' column.
Common Questions
Can I do this without Zapier?
Yes, but it requires using Slack Workflow Builder (paid plans) or writing a custom Google Apps Script.