I am new to this community and happy to be here. I was hoping to ask for a way to solve an automation problem. I have data in excel that I need to use to populate a web form. I have about 500 rows that need to be entered into the correct web form fields. The catch is that there are also dropdowns that need to be selected. The dropdowns are always the same so at least that is consistent.
Is there any non expensive tool that I can use to loop through the 500 rows and make the submissions into the web form. The web form requires that I login to the site first.
I am not a programmer but I am ok with learning, I would prefer a gui tool that could help navigate and record the clicks and to be able to loop through each row in the sheet.