All you need to do (in Google Sheets because I only use Google Sheets), is to have a new column to track the date that the row/item was last used.
Then, you can begin with a Google Sheets “Search Rows” module, and sort by the date column ascending, limit to one result, so that you get the oldest item (which is the next item) to be used.
Hope this helps! Let me know if there are any further questions or issues.
Note: I see hundreds of posts, notifications, and messages daily on this forum, so if I missed your reply, please message me to look at your reply.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!