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!
Page 1 / 1
Hi @PedMar
Try adding this Zap step: Formatter > Utilities > Line Items to Text
This will allow you to format the GSheet rows as you want for the Slack Channel Message.
Thank you Troy, when I use Line Items to Text I’m not getting any change, I believe it has to do with my Google Sheets information extracted (that appears to come all in bulk) but I’m not able to separate it.
@PedMar
Help us have more context by posting screenshots showing how your Zap steps are outlined, configured, and the DATA OUT from the GSheet step that you are trying to use.
Thank you Troy, here’s the screenshots (deleted client’s name due to NDA)
Hi @PedMar
Try adding this Zap step: Formatter > Utilities > Line Items to Text
This will allow you to format the GSheet rows as you want for the Slack Channel Message.
Thank you Troy, when I use Line Items to Text I’m not getting any change, I believe it has to do with my Google Sheets information extracted (that appears to come all in bulk) but I’m not able to separate it.
Here’s the table
Step 1 is just scheduler.
Step 2 config:
Step 3: Formatter setup
Step 4: Send Slack Message
@Troy Tessalone I initially wanted to send the message by combining data triggers, but didn’t work. Tried creating a column with the data I wanted to send and still doesn't work.
Not sure if this may be the reason, but this table is an array, meaning data its in a formula in 1 cell (A1).
I’m out of ideas on how to solve this that should be an easy cake automation 😭
@PedMar
Post screenshots showing the DATA OUT from the GSheet step so we can see how the data is formatted when it is returned from GSheets.
@PedMar
Give this a try…
App: GSheets
Action: Lookup Spreadsheet Rows (Advanced)
Field: If multiple search results are found
Value: Return first search result. Step run status is “success”. (Default)
Why this works:
Zap step is already set to return multiple results
Prevents a nested array from being returned
And then it continues until the final row, which is indeed row 13
@PedMar
Issue is because the Zap step settings is causing the data to be returned as a nested array, which becomes flattened when trying to use it in the Formatter step.
Give this a try…
App: GSheets
Action: Lookup Spreadsheet Rows (Advanced)
Field: If multiple search results are found
Value: Return first search result. Step run status is “success”. (Default)
Why this works:
Zap step is already set to return multiple results
Prevents a nested array from being returned
Awesome @Troy Tessalone ,
That indeed worked, now Im trying to figure out how to configure the slack message to include all line items.
I used formatter to split in newlines, but now I have several output items.
How can I automate to include in the slack message as many as they are available?
Fixed. Thank you @Troy Tessalone for your guidance
Thanks for following up here @PedMar to confirm everything’s all sorted. Glad to see Troy was able to help point you in the right direction - thanks for helping out with this @Troy Tessalone! 🙌
Feel free to reach back out if you need more help from the community. In the meantime, happy Zapping! ⚡
