Google Sheets - Add new Row - retrieve row number

[erh]

I'm using the Google Sheets action "Add new row" -- is there a way to use a variable which represents the row number that was just added to?

Right now I have to do something rather complicated: =INDIRECT("AnotherSheet!A" & ROW())

This fetches the value in the sheet "AnotherSheet", in column "A", at the Row of the currently edited cell. Alas, the =INDIRECT function causes the entire spreadsheet to re-calculate, and is sort of janky.

Is there a variable available in the "Add new row" function that can represent the row being added to?

At the very least to allow later actions to use the Row# to retrieve data without requiring a "Lookup SPreadsheet Rows" action?

 

[ArshilAhmad]

Hi @erh,

The 'Google Sheets: Add New Row' action step does provide you with the row in which the data has been added. You can extract it in the manner suggested below.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[erh]

Hi @erh,

The 'Google Sheets: Add New Row' action step does provide you with the row in which the data has been added. You can extract it in the manner suggested below.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

Great idea. I think it can be even easier, actually, using Text Formatter: Extract Pattern

I was able to use this to extract the last digit: (\d+)$

This is an example string from your linked workflow:

2. Updates UpdatedRange : Sheet1!A19:D19

The result was 19.

Question, do you know for a fact that the Add New Row action's UpdatedRange return string's Last Row variable will always be the row that was just recently added to?

 

[ArshilAhmad]

Yes, the Last Row variable will always be the row in which data was added.