Hey guys, I’m quite new - I’ve set up a zap where it gets triggered when a row is updated in a Gsheet.
I’m trying to send notifications via DM in Slack and I need the Zap to fetch the users’ Slack ID from the same row that has been triggered. I’ve tried choosing ‘Pick username’ → ‘Custom’ → and chose the column but it says ‘No data’. (Screenshots provided below)
Any idea how to fetch the Slack ID from the same row that has been triggered?
Red - Trigger; Blue - Slack ID
Zap screenshot wasn’t uploaded in the above.
Check out this article about changing your Zap trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger
Make sure to review the available articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help