Enrichments /
Open Food Facts
No-Code Enrichment with
Open Food Facts
Use Open Food Facts API To Look Up Ingredients and Nutrition Data
Sign Up Free

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.

Open Food Facts API To Look Up Ingredients and Nutrition Data

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:

How To Enrich A Spreadsheet With Open Food Facts API 

For this example, my data looks like this:

barcodes to pass into open food facts api for enrichment

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. 

paste in the open food facts api request

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.

customize the request to open food facts api

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. 

select columns to add to your sheet containing  open food facts api data

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 open food facts api

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

 open food facts api data in Gigasheet
Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever