Enrichments /
Makeup API
No-Code Enrichment with
Makeup API
Use Makeup API To Gather Additional Makeup Product Information
Sign Up Free

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.

makeup API at http://makeup-api.herokuapp.com/

Provider Website: http://makeup-api.herokuapp.com/
Provider Enrichment Docs:
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.

Gigasheet spreadsheet to be enriched using the api http://makeup-api.herokuapp.com/

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

curl request for the 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. 

customizing the Makeup API request

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.

previewing the response from the Makeup API

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. 

confirm execution of the Makeup API

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..

Gigasheet spreadsheet with Makeup API data
Try it Out

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Database
No Training
Sign Up, Free Forever