Use the PromptLoop Formula to use a few rows of examples to complete any text transformation or analysis with AI.
If you haven't already done so, add PromptLoop to a new or existing spreadsheet. Navigate to "Get Add-Ons" and search for PromptLoop or use this template sheet 🍿 Intro Video on Youtube
Once installed, you have access to several functions powered by various AI models.
Choosing the right function depends on what you are trying to accomplish. These questions can help get started choosing the right function.
Looking to label and categorize text data? Start with the Label Function. Use AI models designed to find the closest and most appropriate match to any row or text string. This works across formats and languages and will always return an exact match, instead of generating a new response like a chat model.
Want to research or answer a question? Use the Browsing Function. These web agents are powered by a series of AI models that can browse the web, read, research, and return what you are looking for. This information is current and accurate and not based on any training data set.
Looking to generate or analyze text? For writing and generative tasks like writing marketing or sales copy, summarizing information, or editing formatting on text, the Inference Function is the best solution.
Looking to extract or summarize text? The Extract Function is best for when you want to extract or summarize information from a block of text.
Looking to generate dummy data? If you are trying to generate dummy or realistic sounding fake data, the Replicate Function is the best solution.
You must activate PromptLoop in any sheet you want to use the formula in. Navigate to the Add-in menu and click Add to do so.
Every time you change the inputs, PromptLoop will rerun the model. If you are getting errors, tweaking the inputs will help recall the model and reload your sheet.
Note: PromptLoop is made for text transformations. When working with numbers it is still easiest to use the formulas you are used to.
The Promptloop inference function revolves around examples (your data). The better the input and output examples you provide, the better the outputs the formula will provide.
=PROMPTLOOP( inputRange, outputRange, target)
Once you have fine-tuned your examples and you are getting the outputs you want, you should lock the examples in for the rest of the sheet. If you change the examples the formula will be recalled and your outputs will reload.
Set absolute references like:
$A$10:$A$11,$B$10:$B$11
on the examples and use them for the rest of your task
You can explore common use cases from current customers here or get started using one of our ready-made templates.
If you are interested in running the inference model on a large data set, we recommend reaching out to us about a custom model as this will be the most accurate and efficient way to analyze your data.
This error message indicates that the input, output examples, and/or target value are not correctly formatted or are of the wrong type. For Promptloop to work - you must provide inputs based on the documentation of each Promptloop function. They may not contain undefined values, blank cells, or #ERRORS!.
This message occurs when the Microsoft account being used is not linked to an active Promptloop account. It also may indicate that you have hit the limit of your plan's credit usage. If you have just upgraded your subscription and continue to hit credit limits, we recommend going to the Promptloop task pane in your Excel notebook and clicking the 'Refresh Account' button before trying to use the functions again.
This error message indicates that the model timed out before it could find your request. We recommend waiting a few seconds and trying again.
This error message indicates that there is a processing error with one of the AI models used in this function. We suggest checking your syntax, reloading the cells, or if the problem persists you can reach out to help@promptloop.com for further support.
Reach out to help@promptloop.com and we will be happy to guide you through detailed set up and get you started with a few examples so you can start using Promptloop for your specific needs. Or just say hello!