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