Skip to main content
Question

How to automatically pull all outputs into Gmail body


OJT123

Hello,

I’m using ‘Find many records’ to search Airtable and return items to be used in an email (using Gmail).

I’ve added a Formatter step between to turn a string of names into separate outputs for the email. 

 

I want to automatically show ALL separate outputs in the email. For example, if the process returns 10 separate outputs I want to show all 10 in the email. Is there a way to do this? 

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.

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @OJT123 

Good question.

That would depend on how you want the email body to be formatted.

Can you provide an example for us to visualize with screenshots?


OJT123
  • Author
  • Beginner
  • 2 replies
  • August 10, 2023

Hi Troy

 

Thanks for helping with this. 

 

See attached 2 screenshots. You’ll see I’m using the formatter to take a ‘search for multiple records’ result and split it into separate items. I then want these items to appear as a list in the body of my email, which I can do successfully as a manual test but I can’t find a way to automate it so that ALL separate results from the multiple record search are moved into the email body automatically when I publish. 

 

Hope that makes sense. 


Troy Tessalone
Forum|alt.badge.img+14

@OJT123 

Try this Zap action: Formatter > Utilities > Line-Items to Text

Use <br> if you are using an HTML email body.

Use \n if you are using a TEXT email body.

 


OJT123
  • Author
  • Beginner
  • 2 replies
  • August 10, 2023

Which token are you thinking I use in the email body with this?

 

‘Output: text’ is the only one that captures ‘all’ matches, however it appears in the email as a string of names separated by commas.


Troy Tessalone
Forum|alt.badge.img+14

@OJT123 

We would need to see updated screenshots with how your Formatter step is configured along with your Gmail step.