Get Home Depot product details (brand name, model number, description, photos, price, inventory & more) from a list of SKUs. This is useful if you need to look up product data in bulk but don’t want to sit and manually search for each product one-by-one on the Home Depot website.
This formula contains 2 workflows which need to be used together, the first workflow accepts a list of SKUs to search for on Home Depot. It will filter the results and only return back results that match the SKU exactly, so you probably won’t get 100% coverage if Home Depot doesn’t carry the exact SKU you want. Also be warned that sometimes SKUs will differ by leading zeros or other strange characters, so you may need to make edits to your input list if that’s the case.
From your list of matching results, you need to copy and paste the Item IDs (Home Depot’s internal identifier for products) into the product details lookup workflow, which takes a list of Home Depot Item IDs and gets back the details for them, one-by-one, as the second step.
Start by importing this formula, which will add 2 workflows to your account. Start by entering your SKUs into the search workflow to see the execution plan for what the worfklow could do if executed.