I have a list of invoices on my google sheet. I want to run a scneario everyday to use HTTPS “GET” module and check if the status of any has changed from “issued” to “paid” and everytime it happens I want to update my google sheet to change the invoice’s status.
What is the problem & what have you tried?
Everytime I download a whole list of invoice’s from a whole month so the number of them may change. To help it I wanted to use iterator to seperate them to seperate bundles so each invoice is a bundle. But when i get to the “search rows” to map the data I can only map data from only one invoice and there’s no boundles to map from, but in the Summary of the iterator module everything works fine. What do I do to have the all other boundles possible to map.
I have them in seperate bundles as I want to and it’s like this in iterrator module summary. But I don’t have it like this while mapping data in the next module.
Google Sheets - Search rows → Iterator → Google Sheets - Search rows → HTTP
If I understood your requirement correctly, all you need is:
Google Sheets - Search rows → HTTP GET → Google Sheets - Update a row
“Google Sheets - Search rows” already acts as an Iterator and produces one bundle for each row found. Just do what you want with the row values and then update the spreadsheet using the rownumber.
If that doesn’t make sense, please post screenshots of your scenario so we can better understand the issue.
So the first module is http GET request where I download the list of all invoices from one month from another website to check if the status of any of them has changed from “issued” to “paid”. If it did I wanted to search the inovice by it’s number that’s already in the sheet and change it’s status in the sheet.The output is one bundle that separates them as each collection is a different invoice. Then I wanted to use the iterator to separate them to make every invoice a different bundle. After that I wanted to use the “Search row’“ module to find the invoice by it’s number. The problem is that there’s a possibility that more than one invoice might have changed it’s status and I don’t know how to map it so that no matter how many inovices has changed it’s status, all of them are found in the sheet and their’s status get changed. When i try to map anything I only get to map the data from only the first invoice on the list and that’s it. The iterator separates them in different boundles but the next module doesn’t see it that way. It only sees the one specific boundle with one invoice’s data. I hoped I explained it well enough for you to get it!
First of all, invalidate your API key, as it was exposed in the image.
You’re going to map id to the filter in Google Sheets. The green pill is the field your mapping. The value beside it is just an example of one of the executions, so that you make sure you’re mapping the right field.
Your solution works. Credit-wise it’s not the best option, however. You can try to flatten the structure of Data to an array that contain only the ids of “paid” invoices and iterate over that.
Thank you so much. Actually I think there was some glitch in make.com, beacuse it didn’t work with all the data sent. It’s working now when I rebuilt the whole scenario. Thank you so much for help!
What is your goal?
What is the problem & what have you tried?
Screenshots (scenario flow, module settings, errors)
