About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

If a cell in google sheets matches then input data from another cell

  • 14 January 2021
  • 1 reply
  • 486 views
J

Hello!

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. 

Thanks!

 

 

icon

Best answer by Liz_Roberts 18 January 2021, 16:13

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Liz_Roberts
Userlevel 7
Badge +8

Hi @jjwood ,

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:

  1. A recruiter adds their own name as the "Requestor" in Column A of your spreadsheet, then enters the candidate's name in Column B
  2. That triggers a Zap that messages your HR team, to tell them to check the spreadsheet
  3. Then, a member of the HR team will select one of the options in Column C (Yes/No/Maybe)
  4. That should then trigger a Zap that messages the original Requestor in Slack, letting them know about the updat

Is that about right? If so, it looks like you'll want to have two separate Zaps here:

  • The first Zap should use the Google Sheets "New Spreadsheet Row" trigger to run when a new row is added to the spreadsheet, then the Slack "Send Channel Message" action to alert your HR team. Here's a Zap template that can help you make that Zap quickly.
  • Then, the second Zap would use the Google Sheets "Updated Spreadsheet Row" trigger, so that it will run specifically when Column C is changed. "Updated Spreadsheet Row" lets you set a "Trigger Column", so that only changes to that column will trigger the Zap.


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.

Terms & Conditions