Help Please: Updating a Row and Moving to the Next Empty Row in Google Sheets

[Youssef_Enjri]

Hey everyone,

I’m working on an automation that integrates Notion and Google Sheets, and I need some help optimizing my workflow.

Goal:

1. Check Notion Database – Retrieve records where:

• The engaged property is checked (True).
• The lead engaged? property is not empty.

2. Update Google Sheets – Write the engaged status (“yes” or “no”) into a specific row starting from column C.

• If C2 is filled, move to D2.
• If D2 is filled, move to E2, and so on.
• When the row is completely full, move to the next empty row and repeat the process.

Current Scenario:

Here’s what I have set up so far: Notion - Watch Database Items → Retrieves records based on the filters above.
Set Variables → Extracts and formats the engaged and lead engaged? fields.
Google Sheets - Search Rows → Finds the correct row in the Google Sheet.
Google Sheets - Update Cell → Updates the first empty cell in that row only.

Problem:

• Right now, my setup only updates a single cell in the row.
• I need the automation to find the next empty row and continue updating from column C onward.
• Also I need depending on the lead name on the gsheet to automatically matches lead nae on gsheet with item name on notion and start updating.

Questions for the Community:

1. How can I find the next available cell when the current one is full?
2. Is there a way to loop through the sheet and dynamically choose where to insert the next value?
   What I want to do is match Lead name on the corresponding from Notion then, Fill C2 if C2 is full fill D2 if D2 is full fill D3
   it is as if I am taking a colom of all the data and wanna insert in a row
   
   

Thanks in advance guys. I feel I am so close yet so far
blueprint.json (88.9 KB)