I want to use Make to migrate customer data from Google Sheets to Clover. We have, at most, 300 new customers per month, which would be under the 1000 operation limit. Make continuously ran the same operations repeatedly until I hit the 1000 limit. Is there a way to get it to only run the operation if a certain condition is met?
I did put in a filter for if a specific column contains a specific character that is not filled if there is no appointment for that customer, but it seems to ignore that and run regardless of whether or not that is the case.
I’m not sure how to amend this & can’t test anything out until next month.
You are using the search module as a trigger—each scheduled run costs you operations, whether or not the search returns data. The easiest way to reduce this is to decrease the number of executions per month.
Additionally, you can learn how to count the number of operations here.
I did put in a filter for if a specific column contains a specific character that is not filled if there is no appointment for that customer, but it seems to ignore that and run regardless of whether or not that is the case.
If you are talking about filter between “Clover POS” and “Ignore” module- it is filter used only in case of error.
You can solve this issue by adding a status column in the sheet with the option - Uploaded.
Then, add a module “Update a Row” at the end of the workflow to update the status to “Uploaded”. This will provide you with a provision to apply filtering at the first module (with the option “not equal to” uploaded) to grab new ones.
Regards, Msquare Automation - Gold Partner of Make