I’m hoping for assistance with a Google Sheet push to/from Slack Zap. I have one currently that is basically if a cell/row is updated in one sheet, push some of that information to a specific slack channel. It’s working fine but now I’m looking for another variation of this.
For context, here is what I’m going for: I have a google sheet that my company uses to check rehire eligibility. My google sheet is very simple, in the main tab I have a column for A ) Requestor, B ) Candidate name, C ) HR approval (drop down/data validation), D ) HR Notes. A recruiter will add their name as requestor in A, then type the candidate name in B. From there my current zap pushes that candidates name to a slack channel to let the HR team know to check the sheet for that name. Once they check their system/notes for eligibility, they make a selection in Column C which is set up for a list data validation (Yes/No/Other). From here I need a zap to let the requestor know that there is an update on the sheet for that candidate via Slack direct message.
First is to have Zapier identify which Slack user/Requestor to send a notification to. My first attempt was to simply have the action send to someone but found that I need to have a Slack ID to send to. The next thought was to create a 2nd tab in my sheet, with column A being the requestor names available in sheet 1, and their Slack ID in column B and do a reference deal to get Zapier to find the requestor name in sheet 2, then input the Slack ID next to it in column B into the Zaps action section on who to send it to. I’ve been messing with find actions to get me there but I’m stuck in getting it to match the requestor names and then utilize the Slack ID.
I’m likely making this too complicated, but at this point I’m lost and would appreciate assistance from the masters.
Best answer by Liz_RobertsView original
Thanks for reaching out! I see that Tyler from Support has been in touch and suggested the below Zaps which I am sharing to help other members who may have a similar question/workflow in the future:
To make sure we're on the same page, here's my understanding of the workflow you outlined:
Is that about right? If so, it looks like you'll want to have two separate Zaps here:
When the Zap is triggered, it will receive all of the cells from the row that was updated, including the original Requestor's name. To help make things easier for yourself, I might also add a column to the spreadsheet where the requestor can add their Slack username. That way, you can go straight into a Slack "Send Direct Message" action to message them about the update.