Trouble updating a Google Sheet cell

Getting Started
1

I’m a newbie and learning quickly.

I have a simple scenario.

Step 1: Grab 1s row with the status of “go”.
Step 2: Using value from the “topic” column, create an SEO title.
Step 3: Using the generated title with ChatGPT, generate an article
Step 4: Post to my Wordpress blog as a draft for review.
Step 5: Update the SAME row in the Google sheet with “posted” in the status column… meaning change from “go” to “Posted”.

The idea is to have the scenario run daily and choose the next row in the sheet.
The spreadsheet is populated with topics already, all set to a status of “go”.
Each day the scenario would post a new article to the blog and update that record to “posted”, so that the next day’s scenario doesn’t try to write about that same topic.

Everything is working great except the last step. Instead of updating the correct cell, it updates the header row cell.

How do I reference the row that I initially pulled from so that it updates the correct row.
I’m not sure what I’m doing wrong.

Also, is the best way to accomplish this?

Thanks in advance.

image
image2560×1392 331 KB

2

Welcome to the Make community!

Try using the “Update Range Values” module instead.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Thank you for taking the time to respond. I don’t follow. I looked for the Update range values module but did not see one. Any other suggestions?

4

Sorry, that’s the “Update a Cell” module.

You can insert the column, e.g.: “D” and the row number from the trigger module.

Screenshot_2024-10-29_081013
Screenshot_2024-10-29_081013470×157 16.3 KB

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

5

Thanks, again.
How to I get the correct row number? It doesn’t look like that is being recorded or pulled when I get the information from the sheet.

Sorry if this is an ignorant question.