Enrichments /
No-Code Enrichment with
Use Spoonacular API to Enrich Your Grocery List with Recipe Ideas
Sign Up Free

Use Spoonacular API For Recipe Ideas to Clean Out the Fridge

Spoonacular is the only food managment system you need when it comes to the foot you eat, with information about dining out, eating store bought food, and cooking at home. The Spoonacular API makes information about individual ingredients or recipes readily available to use with Gigasheet. Let's use the ingredient search to find some candidates for getting rid of those leftover green beans.

spoonacular api docs

Provider Website: https://www.spoonacular.com/
Provider Enrichment Docs: https://spoonacular.com/food-api/docs
Endpoint curl https://api.spoonacular.com/recipes/complexSearch?includeIngredients=pasta -H "x-api-key: your_api_key_here"
Token / Registration Required: Yes, free at https://spoonacular.com/food-api/console with more info here.

How To Enrich A Spreadsheet With Spoonacular:

In this case we're starting with various leftovers I've got in the fridge and pantry:

data to enrich with the spoonacular api

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

past in cURL request spoonacular 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 the pngredient, “pasta”, in the input, and then select our Ingredient column and click +Insert Column Reference. We also need to highlight the “your_api_key_here” and paste our real key from Spoonacular API. Then click Next.

customizing cURL request for spoonacular api
ready to execute spoonacular api

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Spoonastic API 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.

preview of results from spoonacular 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 spoonacular api

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. We'll see our sheet has Spoonacular's reference id for the ingredient and a suggested recipe. If it sounds tasty we can then pull the full recipe with another enrichment by submitting the recipe id.

sheet enriched with data from spoonacular api
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