PromptLoop works by using a set of input and output examples to inform the model what the output should look like. This structure can drive a huge variety of outputs and solutions and therefore is the most commonly used.
The parameters, (inputs, outputs, target cell etc.) work just like any other spreadsheet formula. You can think of PromptLoop like a LOOKUP formula - but instead of matching rows it infers the relationship in your input/output table and returns the result.
This simple formula takes a set or column of Inputs and a set or column of Outputs and returns the output for an new input or Target.
=PROMPTLOOP( inputRange, outputRange, target)
PromptLoop is made for text transformations. When working with numbers it is still easiest to use the formulas you are used to.
Set absolute reference like:
on the examples and use them for the rest of your task
To start using the formula. Set up the formula with the link below or see the guide here.
You must activate PromptLoop in any sheet you want to use the formula in. Navigate to the Add-on menu and click "Activate" to do so. More on enabling PromptLoop
This error message indicates that the inputs and/or output examples are not correctly formatted. For Promptloop to work - you must provide pairs of inputs and outputs, usually on the same row, as examples. You can include multiple columns combined as one input or output row, but they may not contain undefined values, blank cells, or #ERRORS!.
This message occurs when the Google Account being used is not linked to an active Promptloop account. It also may indicate that payment method is needed, even if free credits still remain on the account.
This error message indicates that PromptLoop is not Activated in this sheet - Navigate to the Add-on menu and activate or Re-activate to proceed. You may have to reload the sheet and delete / re-enter the formula if this persists.
Reach out to firstname.lastname@example.org and we will be happy to guide you through detailed set up and get started with a few examples so you can start using prompt loop for your specific needs. Or just say hello!
Reserve a session HERE ✅ and we can help!
or Email: email@example.com