Automated Invoice Portal Submission Tool — NetSuite Integration

Hello, I'm interested in having a developer build a tool that automates the process of submitting invoices to my customers' invoice portals. Additionally, I would like a confirmation that the process was successful and proper error flagging in order to easily identify the issue in the event of failures. Our tech stack uses NetSuite to store the information, and the portals include Coupa, VendorAccess, VendorCafe, and OPS Technology. My early research indicates that using Playwright to build this tool is the best solution, as we would like a custom product. My areas for further diligence that I would like to discuss before developing are: First, I am unsure whether it would be better to connect NetSuite to the middleware via a NetSuite API or a bulk CSV export — I'd welcome your recommendation on which approach is more practical and scalable. Second, what is the optimal process to prevent double invoicing? Third, how can we solve for the challenge of name discrepancies between NetSuite and the portals for the same customer (e.g., LLC, L.L.C., capitalization, etc.)? I am open to fielding your questions and solution alternatives if you can think of something better! Thanks, John