Hi everyone,
I’m trying to build a Zap that sends daily Slack alerts for job vacancies that are at risk of breaching SLA (data stored in Google Sheets).
Here’s what I need:
-
Scheduled to be send daily (on business days)
-
Data pulled from a Google Sheet that has a table, each vacancy has a row and each vacancy with risk or out of SLA has a “ALERT” mark in column F
-
Take this information and send it through slack with a format:
Client XX | Vacancy XX | “Alert Message” (pulled from Column E)
What I’ve tried so far:
-
Trigger: Schedule by Zapier (every day).
-
Action: Google Sheets → Lookup Spreadsheet Rows (return all matches).
-
Problem: the output is grouped by column, so Zapier shows me one long string of all clients, one long string of all positions, etc.
-
I tried Looping and Digest, but it still concatenates everything instead of giving me row-by-row messages.
How can I properly structure the Zap so that each row from Google Sheets is treated separately (Client, Position, SLA Status) and then combined into one nicely formatted Slack message?
Thank you!
