• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

How trigger in Google sheet when total number of rows greater than 100

Status
Not open for further replies.

tisaigon

Member
Hi,
i want to create trigger when total number of rows in sheet >100 or value of cell A1 > 100?
How can i do it?
Thanks
 

Attachments

  • shot_230323_211135.png
    shot_230323_211135.png
    39.1 KB · Views: 133
Last edited:

tisaigon

Member
@Supreme
example: when insert row to google sheet, and in cell A1 = count of total rows.
When A1>100 (means total rows in sheet greater than 100 rows), trigger flow in Pabbly.
Thanks
 
P

Pabblymember11

Guest
So you want to count the number of rows in each other row to see how many columns they have? Or do you want the 100th column to come in the trigger response to process further action steps?
 

tisaigon

Member
@Supreme Thank you. i used formula "count the number of rows" in google sheet, and next step is trigger with Pabbly.
Your comment is Correct: "Or do you want the 100th column to come in the trigger response to process further action steps?"
 
P

Pabblymember11

Guest
Hey @tisaigon

If you want the 100th row to pass through your workflow, then you could use the RowIndex field in the filter step.

1679899388798.png
 
Status
Not open for further replies.
Top