Automation of Amazon Shipping Label Generation Using SP API

I'm a dropshipper on Amazon who works with multiple suppliers, and I'm looking to automate my shipping label process utilizing Amazon SP API. I would want a script that handles all of the following: Automate shipping label purchases for my Amazon orders, including: - Pulling the correct "Ship-From" address based on which supplier handles that specific ASIN (different ASINs ship from different suppliers) - Ensuring only the allowed shipping carriers can be purchased per ASIN (some ASINs can use USPS or UPS, some are USPS-only, some are FedEx-only, etc., so it can't be a blanket setting) - Purchasing the shipping option where if a label is not the cheapest, but it arrives one day sooner than the cheapest and it is under $0.50 more expensive than the cheapest label, then that label should be chosen instead. If it arrives 2 days sooner but is under $1.00 more expensive than the cheapest label, choose that option, and so on. Otherwise, purchase the cheapest option. - Applying the correct pre-set package dimensions and weight for each ASIN before purchasing the label - Saving the generated label PDF with a specific filename based on the product name I have set for that ASIN - For orders only from a specific supplier, also generate the packing slip PDF that matches that specific filename for the shipping label but add "slip" to the end of the filename. My existing setup: I already maintain a master Google Sheets (can also change this to an Excel sheet if you're not able to work with Google Sheets) that contains all the data the script would need, with the following columns for each ASIN: - ASIN - Supplier name (matches the "Ship-From" name I have set in Amazon for that ASIN) - Allowed shipping carrier(s) for that ASIN - PDF filename for the shipping label - Package dimensions and weight Additional requirements: - The script should pull from this Google Sheet (or Excel sheet) to determine all the values for each order I need to be able to add new ASIN rows to the Google Sheet (or Excel sheet) over time, and the script should automatically work with any new entries without needing to be re-coded