Fill My Tokens in an email with a CSV upload | Community
Skip to main content
M
Mx_Braze
Level 2
September 6, 2024
Solved

Fill My Tokens in an email with a CSV upload

  • September 6, 2024
  • 1 reply
  • 2708 views

I've got some emails I send regularly that take a lot of time to set up. Simply put, each email is a list of 10 Headline/paragraph combos and each week, I have to copy and paste this text from a new spreadsheet into the headlines and paragraphs. What I would like to do is automate this process using tokens or something similar.

Ideally, I'd like to take a CSV which contains the headlines and paragraphs, upload that to Marketo, and then have it autofill an email template that has a token for each headline and paragraph. I've been looking at the documentation on tokens and I can't find anything like what I'm describing. Does anybody know of a way to do something like what I'm describing here?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

CSV, no. But JSON, sure! You can populate a Velocity {{my.token}} with a JSON array* of your content, parse it using another Velocity token, and output it anywhere you want.

Alternately, and this is a stretch, you could use a shared Custom Object which would allow you to use a CSV to update it. However, this would require you to create junction objects for every newly created lead. Wouldn't be my move.

 

 

*ArrayList, technically

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
September 6, 2024

CSV, no. But JSON, sure! You can populate a Velocity {{my.token}} with a JSON array* of your content, parse it using another Velocity token, and output it anywhere you want.

Alternately, and this is a stretch, you could use a shared Custom Object which would allow you to use a CSV to update it. However, this would require you to create junction objects for every newly created lead. Wouldn't be my move.

 

 

*ArrayList, technically

    M
    Mx_BrazeAuthor
    Level 2
    September 10, 2024

    Thanks for the reply. I'm assuming I would need access to an API to send that JSON array to Marketo right? I don't currently have access to something like that. I'm hoping to find a solution that can just be done from within the Marketo interface without having to pipe data in via another mechanism like an API.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    September 10, 2024

     I'm assuming I would need access to an API to send that JSON array to Marketo right?

     Not at all. In fact, it’s impossible to do via API. You do it right in Script Editor.

      Terms & ConditionsAccessibility statement

      Loading footer...