I’ve created the following automation which takes info from the RSS feed, runs it through ChatGPT where I ask for 4 different variations of a specific text. And then I want to have each variation in a separate column (same row). So far I was able to add each variation to a separate row, but same column.
How can I do this the way I want?
1 Like
Hi @jkurtev Welcome to the community!
Can you share screenshot of that 4 different text outputs from OpenAI module?
Hi jkurtev, if you want to add them in the same row, you’ll need to add a Array Aggregator module, select Value in the Array Aggregator, then map the array values on the Add a row module with the corresponding index
Hi @jkurtev If your Open AI module returns the array no need to iterator or array aggregator map those directly in google sheet. You can set that up like this.
-
Set up instructions to output JSON with JSON structure :
-
Enable “Show Advanced Settings” options at the bottom > for JSON parsing choose response format as “JSON object” and select Yes in "Parse JSON response"
-
This is how output will look like with inbuilt parsing
-
Map those values directly in sheet
This way you are saving operations as well.
This will help you in setup.
Best,
@Prem_Patel
2 Likes
Thanks both of you. @Prem_Patel your solution worked very well.
Can I ask one more question - after I have the 4 different prompts, I want to create Pinterest pins with them using Ideogram (this part I was able to do). But when it comes to the pinterest creation, how can I pick the right board?
On theory it should be taken from the article category in the RSS module. For example, if the category contains “Gardening” create pin in the “Gardening” board, but on the Pinterest module, the boards are listed as dropdowns.
2 Likes
Glad that it worked! @jkurtev
Please mark the previous reply which helped you in solving your problem as Solution using this option
For Pinterest you can create new post.
Best,
@Prem_Patel