Slack and Google Sheets, ready to switch on
A row added to the sheet you share is posted to the Slack channel you choose with the columns you name, a change in the columns you watch lands in the row's thread, and the person in the owner column gets a direct message. You paste two keys in your account and it runs, in about ten minutes.
No setup fee, cancel any month, and a person on live chat if a key doesn't work.
More with these apps: all Slack integrations · all Google Sheets integrations
Slack's Workflow Builder can already use Google Sheets.
It can: Slack's help says Workflow Builder steps can send data from a workflow into a spreadsheet or pull data from one. That's a workflow somebody builds and maintains in Slack. This pair watches the sheet and posts on rules, with threads per row and direct messages to owners, and a person keeps it working. If a workflow does the job, build the workflow.
What moves, and when
The details you would normally get after a sales call. Here they are up front.
| What | Direction | When | Rule |
|---|---|---|---|
| New row | Google Sheets to Slack | Within a minute | The columns you name, in the channel you choose, with a link to the row |
| Changed cells | Google Sheets to Slack | Within a minute | Only the columns you watch, posted in that row's thread |
| Owner gets a direct message | Google Sheets to Slack | Within a minute | The email in the column you nominate is matched to a Slack user, who gets the row privately |
| Rows due today | Google Sheets to Slack | Weekday mornings at 09:00 | From the date column you name, in one message |
| Reading only | Google Sheets to Slack | Always | Nothing typed in Slack changes the sheet |
How to set up Slack and Google Sheets
Ten minutes of your time, then it's ours.
- Choose Slack and Google SheetsPress Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
- Pay and open your accountCard or invoice, about two minutes. The account opens with this integration waiting for its two keys.
- Paste the Slack bot token and the Google Sheets link
- Slack bot token: open api.slack.com/apps and create an app from scratch in your workspace. Full Slack guide
- Google Sheets link: create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. Full Google Sheets guide
Each screen carries the full guide with the exact menu names, about seven minutes for both. - We check both keysEach key is checked against Slack's and Google Sheets's own API the moment you paste it. If one doesn't pass, the screen says what to fix, and a person joins the chat if that isn't enough.
- Add one test row, then it's RunningA minute or two. Add a row in Google Sheets and wait for the post in the channel. It runs on a short schedule, so give it a minute.
When Slack or Google Sheets changes its API, we fix it within a working day. You don't get a ticket to solve.
- Everything in the table above, with monitoring on.
- Fixes when either app changes its API.
- A person on live chat, replies within a working hour.
- Custom logic beyond the table is priced separately.
No setup fee, cancel any month
Ways to connect Slack and Google Sheets
Three ways people connect these two, and what each one asks of you. The built-in app is described above.
Before you decide
Why within a minute rather than instantly?
Google Sheets does not tell anyone when a cell changes, so we check on a short schedule. For a sheet that fills from a form, that is plenty.
Will it fill the channel?
Only the columns you watch post, and each row keeps one thread. A sheet that changes all day usually goes to a channel of its own.
Does Slack integrate with Google?
With Google Sheets, yes. A row added to the sheet you share is posted to the Slack channel you choose with the columns you name, a change in the columns you watch lands in the row's thread, and the person in the owner column gets a direct message. Nothing typed in Slack changes the sheet. $39 a month.
How do I link my Google account to Slack?
For this pair you don't link accounts. You share the spreadsheet, either with anyone who has the link or only with the address our engineer sends you, paste the sheet link and a Slack bot token in your Dovetly account, and invite the bot to the channel. Nobody signs in to Google from Slack.
Can I integrate Gmail with Slack?
Not ready-made: Gmail isn't in our catalog yet. If you need mail in Slack, describe it and a person replies within a working hour with whether we can build it and at what price.
Anything to know about Slack?
The bot has to be invited to a channel before it can post there; that's one command in Slack.
Anything to know about Google Sheets?
Google Sheets doesn't tell anyone when a cell changes, so anything we read back out of a sheet is picked up on a short schedule rather than the moment you type it.
What if mine is a bit different?
Tell us what should go where in plain words. Small changes to the rules above are usually free; bigger ones we price the same day and build into the same account.