Enhance Julius Automation Script
Budget: ₹1,500 – ₹12,500 INR
My existing Julius automation script only gets part of the job done. It can reach the target web page most of the time, but feeding that page with the workbook information fails, so the upload-validate-write-back loop still happens by hand. I need the script either fixed or rebuilt so the entire cycle—from reading the workbook to updating the final price column—runs reliably.
Right now:
• Navigation is only partially working.
• Uploading the data/file, validating the response, and writing the price back to the sheet are not automated at all.
• The workbook holds text, numerical values all of which must be handled.
What I expect when we are finished:
1. The script pulls every required field (text, numbers) from the workbook.
2. It navigates to the correct page every time, even if a session times out or the site layout shifts slightly.
3. It uploads the file or data, waits for the site’s confirmation, and captures any returned values.
4. It validates that response (e.g., correct format, non-empty, within expected range).
5. It writes the confirmed price or status back into the workbook in the proper row.
Clean logging, concise error handling, and short in-line comments are all I need for maintainability; the language or framework is up to you as long as it is scriptable and can interact with Excel and a browser (Selenium, Playwright, or a similar tool are fine). Once it runs headless and passes a simple repeatability test on my machine, the project is done.
Right now:
• Navigation is only partially working.
• Uploading the data/file, validating the response, and writing the price back to the sheet are not automated at all.
• The workbook holds text, numerical values all of which must be handled.
What I expect when we are finished:
1. The script pulls every required field (text, numbers) from the workbook.
2. It navigates to the correct page every time, even if a session times out or the site layout shifts slightly.
3. It uploads the file or data, waits for the site’s confirmation, and captures any returned values.
4. It validates that response (e.g., correct format, non-empty, within expected range).
5. It writes the confirmed price or status back into the workbook in the proper row.
Clean logging, concise error handling, and short in-line comments are all I need for maintainability; the language or framework is up to you as long as it is scriptable and can interact with Excel and a browser (Selenium, Playwright, or a similar tool are fine). Once it runs headless and passes a simple repeatability test on my machine, the project is done.