Solution to count number of rows

[arsachdeva]

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hi
Is there a way to count the number of rows in a sheet within a pabbly flow.

For example, I fetch all the rows in a flow using Get Rows action and then can I find how many rows were there in the fetch in the form of number, say 15, 25, 100 ?

Is it possible?

NOT Related to a particular flow. Just exploring if this is possible.

 

[Preeti Paryani]

Hello @arsachdeva,

Yes, this is possible. You can count the number of rows fetched from Get Rows in a few ways:

1. Use the “rowIndex” of the last row returned by the Get Rows action — this directly reflects the row count.
2. Capture the Get Rows response in Advanced Format, then:
   • Use a Code by Pabbly step to count the number of objects in the array, or
   • Use an Iterator followed by a Number Formatter (Counter) to increment by 1 for each item.
     The final counter output will give you the total row count.

Either method will allow you to get the exact number of rows.