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.
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:
Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from Spoonacular.
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.
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.
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. 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.