@wajeeh There are a few different ways to workaround the 100 record limit. One way is to use an external automation tool like Make. This is likely the easiest & quickest way to do it, once you get over the learning curve of using Make.
Alternatively, if you want to stay within Airtable’s automations, you can workaround this limit by writing a script.
Also, Airtable’s looping section of automations has an 8,000 record limit if all of your records are within a linked record field. So you might be able to do something creative here by always having your records automatically link to a single master record in another table. (If you need more help, I don’t read the posts here too frequently, so post questions for me here.)
