I'm looking for advice on how to best control a Chrome window for an important task at work. I have minimal programming experience, mostly with VBA in Excel and AutoHotkey. I need to download a stock list from a supplier's portal and then manually enter the items into our internal CRM, which operates through Chrome. I'm curious about the best method for automating this process. Should I use a Chrome extension with action buttons, run a script that opens Chrome and inputs the data, or perhaps something else? I'd appreciate any guidance in simple terms to help me understand the best approach.
5 Answers
Have you checked out Selenium? It's pretty handy for automating browser actions. You can record your interactions and then loop through entries from an Excel or CSV file. It could really simplify entering your stock list.
Alternatively, using an RPA Chrome extension or crafting a custom one might be the way to go. Running a script directly in the Chrome console could also do the trick. I'd lean towards writing a simple script that integrates some AI functionality for ease of use.
To keep track of your progress, consider what metrics you're interested in. Is it clicks per minute, entries per session, or something else? You could use Python with PyAutoGui or pynput for tracking mouse movements and entries. But remember: exercise caution when using AI tools for work-related tasks!
If you're entering a lot of products one by one, automating the workflow with a straightforward script would be ideal! It saves time and reduces the chance for errors.
Yeah, I agree! Selenium is a solid choice for this kind of task.