Use Open Food Facts API To Return Food Facts

Open Food Facts is a food products database made by everyone, for everyone, that can help you make better choices about what you eat. The Open Food Facts API allows you to retrieve information from the Open Food Facts database. Some of the information available through the Open Food Facts API include:

• Ingredients analysis
• Nutrient levels
• Allergen detection
• Product packaging
• Brand information

By calling the API using Gigasheet, you can enrich your sheet with food and nutrition information.

‍

Provider Website:  https://world.openfoodfacts.org/data
‍Provider Enrichment Docs:  https://openfoodfacts.github.io/openfoodfacts-server/api/tutorial-off-api/
‍Endpoint: https://world.openfoodfacts.net/api/v2/product/3017624010701
Token / Registration Required: No

‍

How To Enrich A Spreadsheet With Open Food Facts API 
‍

For this example, my data looks like this:

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from the Open Food Facts API  docs. Be sure your request starts with curl or http. It should contain your API when copy/pasted. 

‍Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. Highlight the Bar Code and insert your column with food bar codes.

‍Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the response. At this point, select the fields you want to be inserted into your sheet. 

‍

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.

Here’s an example of the results. Columns have been added with ingredients and nutrition information.