Process overview
With this integration, we’ll create menu items linked to Apps Script functions, rather than a custom function. You can also create a function as we showed earlier, but we’ll explore a different style here.
We’ll start by looking at the raw input data. In our scenario, we want to extract the color from a product description:
Description (C2):
WHITE HANGING HEART T-LIGHT HOLDER
We’ll then create a prompt column that includes the instructions, concatenated with the input data.
ColorPrompt (I2):
"Extract the color(s) from the product description, all in capital letters... If there are multiple, return a valid comma separated list of colors (without the word and). Here is the product description: " & C2
Here’s an example response from this prompt, that we’ll place in the cell directly to the right of the prompt cell.
Color (J2):
WHITE
To make this happen, select “Query” from the menu with prompt cells selected: