Use Makeup API To Enrich Data about Available Makeup Products

The Makeup API is a public API that provides information about makeup products from various brands. The API has endpoints for retrieving a list of all makeup products, filtering products by brand or type, and searching for products by name or ingredient. The Makeup API can be used to create a wide range of applications, including makeup e-commerce sites, product recommendation engines, and makeup tutorial sites.

Provider Website: http://makeup-api.herokuapp.com/
Provider Enrichment Docs: http://makeup-api.herokuapp.com/
Endpoint: curl ‘http://makeup-api.herokuapp.com/api/v1/products.json?brand=Maybelline&name=Maybelline%20Face%20Studio%20Master%20Hi-Light%20Booster%20Bronzer’
Token / Registration Required: No

‍

How To Enrich A Spreadsheet With Makeup AI:

For this example, my data looks like this. It is a list of all the cosmetic products sold within the state of California.

‍

‍Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from Makeup API.

‍Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight brand name “Maybelline”, in the text area, and then select our Brand Name column and click +Insert Column Reference. We will repeat this process for the name. 

‍Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Makeup AI response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

‍Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

‍Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the Makeup API. Makeup has added the category, product descriptions, price, product colors, and product links for each matching product..