Help me understand if what I'm trying to accomplish is even possible (dynamic JSON structure)

Hello automators!

I have this json, that is used in an API call to create campaign copy sequences in smartlead.
I’d like to know if with make is possible to create an automation that dynamically creates the JSON without having to tinker with it once it’s setup.

The variable that the automation has to consider for:

  • There can be multiple sequences (one sequence is one email);
  • Each sequence can have multiple variants (A, B, C etc)

The data is take from a notion database that has the following structure:

  • Campaign DB → sequences DB → variants DB

TIA! :pray:

Here’s the JSON for reference:

Sure, yes it is possible.

I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

@samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

2 Likes