Value from other than previous module (Google Sheet) not visible in last module (Medium)

Getting Started
,
1

Hi!
I am relatively new to make, and I currently want to build the following:

  • I have a list of titles and extracts for blog post ideas in Google Sheets
  • Make observes, If there is a now row coming to the list
  • I send new rows to ChatGPT to write a blog post about each topic
  • I publish it on Medium

I have the following problem:
I can’t map the title from the Google Sheet to the Medium module. Does anyone have an idea why?

image
image1356×482 46.5 KB

image
image736×630 72.8 KB

Blueprint
blueprint.json (25.5 KB)

Output bundles:
[
{
“0”: “Test”,
“1”: “”,
“2”: “”,
“3”: “This is a Test”,
“ROW_NUMBER”: 9,
“SPREADSHEET_ID”: “1UGh9QnJ3PeJEgu6Ac4G_8fdEvBWmZG6R4ZlyO43RE7Q”,
“SHEET”: “Publication Plan”
}
]

Many thanks for your help!

Cheers
Felix

1 Like
2

Hi @Felix_B

If you’re looking to map the title from the sheet to Medium and can’t find the variable to map, you can try hardcoding it like this instead.

{{3.`0`}}

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

3

Hi,
I am not sure if I got it right, but it doesn’t work, unfortunately when I put this in the title field in the Medium module.

Best regards

1 Like
4

Hi @Felix_B
Alternatively, since you’ve already mapped the value in the ChatGPT module, you can simply copy the variable and paste it into the Medium module.
image

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

1 Like