What I’m Trying to Do:
I’m automating a daily Slack message that announces the winners of a sales competition (Spiff). The number of winners varies daily (sometimes 3, sometimes 15+). I need Zapier to pull the winners from a Google Sheet and list them each on a new line in Slack.
What I’ve Tried:
-
Step 1: "Get Many Spreadsheet Rows" (Google Sheets)
- This correctly pulls all the winners from Column A of my "Yesterday’s Spiff Winners" sheet.
- The output is comma-separated (CSV format) rather than separate lines.
-
Step 2: "Formatter – Text to Line Item"
- I used the Formatter by Zapier (Utilities > Text to Line Item) to split the CSV into separate line items.
- This works in the Formatter preview, but Slack still receives a single comma-separated line.
-
Step 3: "Formatter – Line Item to Text" (Using
\n
as a separator)- I tried converting the list back to text with
\n
as the separator. - However, Slack doesn’t interpret
\n
as a new line and displays it as plain text instead.
- I tried converting the list back to text with
The Current Issue:
Instead of displaying each winner on a separate line, Slack formats them as:
“Yesterdays Spiff Winners: Rep 1, Rep 2, Rep 3”
I need it to appear like this:
“Yesterdays Spiff Winners
Rep 1
Rep 2
Rep 3”
What I Need Help With:
- How can I properly format and send the list with line breaks so that each name appears on a new line in Slack?
- Is there a workaround in Zapier, or do I need to adjust my formatting differently?
I’d really appreciate any help or workarounds from those who have solved this before! Thanks in advance. 🙏