How to get row number of lastest row in "Add a Row" Google Sheet?

[kieuminhnhat]

Hello, wonderful Make.com community!

I have a question regarding adding new rows using the “Add a Row” feature in Google Sheets. Each row I add should also include a formula in a specific cell. For instance, if the last row to be added is “row number”, I want the value in cell B(rownumber) to be calculated as A(rownumber) * (my custom function).

However, I’m unsure how to determine the number of rows to add dynamically. Could you please guide me on how to achieve this? Thank you!

[AnthonyatXRay]

You may need to do two different steps unless you already have a method of getting the most recent row number. You can add a new row first and then you can then reference that row in an “Update a Row” module in Make. You can then update that particular cell with the Row Number value from the previous step.

Choose Update a Row

Map the previous row in the module