• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

  • Please note that the team will not be available on 17th June 2024, due to a public holiday.

    During this period, support assistance may experience some delays.

Inventory Update using Google Sheets

zest83

Active member
If there are more than 1000 rows in a google sheet with
product name:
item quantity:
Need to keep a condition wherein, if the item quantity reduces below a certain threshold, an email should be sent to a specific person

Is there any video on the same?
Can we check 1000 rows at the same time?
Is this done using Lookup?

Request advice
 

zest83

Active member
So there is no way to check 1000 rows at the same time to check if value is less by 10... in any of the cells (in that specific column)?
 

zest83

Active member
Is the column specific to finding the value?
Suppose column A being updated with different numbers received from other google sheets.

Column A shows the Quantity.
There is a threshold of 25. (should not go below 25)

So if the quantity falls below 25, those specific email addresses should be sent an email.

If more than 1000 rows, how can this be achieved.
The lookup function using google sheets searches only 100 rows
 

zest83

Active member
What have you understood, please could you tell me... so i know we are talking about the same thing
 

Supreme

Well-known member
Staff member
Please check the message again, we have checked the use case before and on the basis of that, we have told you the scenario. So if you think that users if possible then you may proceed as per your need.

Further, we only provide the necessary support to assist all of our clients in fixing problems and errors. We are unable to help our customers in creating workflows from the start.

To develop your workflow and use case from scratch and handle everything for you, we advise hiring an automation specialist - see https://forum.pabbly.com/threads/pabbly-connect-experts-and-consultants.22/
 

zest83

Active member
I don't need to do it from scratch.
I just needed a yes or no possibility for my problem.
I can understand your answer is "no" there is no oslution to my challenge since there is a limitation on the lookup trigger of 100 rows only!
 
Top