Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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

Format email and slack actions that have line breaks

  • August 30, 2022
  • 3 replies
  • 1194 views
S

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Hi all, 

Can anyone help me understand why the email & slack message format is not being applied to the line break whenever someone submits a form? Below are screenshots of how the workflow works.

I’d like the email to show the line breaks, in the format that the person submitted in. - (ex. A,B)  

I’d like for Slack to quote the entire message, not just the first line. (ex. C)

  1. New form response in Google Forms (trigger) → 
Google Forms response (response has line breaks)
  1. Look up row in Google Sheets (action) → 
  1. Send Slack channel message (action) → 

 

  1. Send outbound email notification (action)

Any help would be appreciated. Thanks! 

Best answer by nicksimardBest answer by nicksimard

Hi @sliangemb!

I see that you reached out to our Support team and they were able to help you out with the Slack portion :)

For anyone else who finds this, here’s what they said:

Let's start with Slack.
 
Blockquote formatting in Slack has to be applied per line. Right now, the "Description" is coming in as one cell from Sheets, but has several separated lines within it - only the first of which is having the blockquote formatting applied to it.
 
ef67afb284716581c2a799c19673d2c4.png
 
To fix that, I recommend utilizing a different way to engage blockquotes in Slack for multiple lines. Instead of having a > before each new line, you can delete those and just use >>> before the first Form Submitter line. That should carry over to the new lines that follow it. 
 
Here's an example to show how that comes through:
 
6b276523a3b3d4be2327782dcc959513.png
 
2e7e4cb6adab37302db01f37897b1c3d.png
 

You said you also got your emails to be relatively close to your ideal outcome. If you have a second, we’d love to hear what the solution was there. Thanks!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

nicksimard
Forum|alt.badge.img+11
  • nicksimardZapier Staff
  • Zapier Staff
  • 2115 replies
  • August 30, 2022

Hi@sliangemb!

First, thanks for the immensely helpful screenshots! the perfect example of showing us what’s happening :)

I tested this by adding line breaks directly in Google Sheets (not via a form response) and it worked properly:

de86efaed281e40062dd1791cc99d566.png

On Mac, I used control + enter to add the line breaks. 

I then tested a form submission and here’s what I got in Slack:

246744871c44331fb7bef6fc9a265068.png

Same result when using your workflow of form submission followed by Google Sheets lookup. So I’m not able to replicate what you’re experiencing, oddly enough. You might want to get in touch with our Support team to see if they can dig into the logs or something, to get to the bottom of it.

Suggestion: is there a reason you’re using the Google Forms trigger then also a lookup step for Google Sheets? You could just use the fields from the trigger rather than add a search step in there. 

S
  • sliangembBeginner
  • Author
  • Beginner
  • 1 reply
  • August 31, 2022

Hi @nicksimard thanks for your response!

 

Can you try to format your entire slack message text with a quote and see if it picks up lines 2 and 3 of the single cell?

 

So the reason why I used a lookup step for Google Sheets is because I have a path rule set up. Is there a reason I shouldn’t do this?

 

nicksimard
Forum|alt.badge.img+11
  • nicksimardZapier Staff
  • Zapier Staff
  • 2115 replies
  • Answer
  • September 8, 2022

Hi @sliangemb!

I see that you reached out to our Support team and they were able to help you out with the Slack portion :)

For anyone else who finds this, here’s what they said:

Let's start with Slack.
 
Blockquote formatting in Slack has to be applied per line. Right now, the "Description" is coming in as one cell from Sheets, but has several separated lines within it - only the first of which is having the blockquote formatting applied to it.
 
ef67afb284716581c2a799c19673d2c4.png
 
To fix that, I recommend utilizing a different way to engage blockquotes in Slack for multiple lines. Instead of having a > before each new line, you can delete those and just use >>> before the first Form Submitter line. That should carry over to the new lines that follow it. 
 
Here's an example to show how that comes through:
 
6b276523a3b3d4be2327782dcc959513.png
 
2e7e4cb6adab37302db01f37897b1c3d.png
 

You said you also got your emails to be relatively close to your ideal outcome. If you have a second, we’d love to hear what the solution was there. Thanks!

Terms & Conditions