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
After you have added the PromptLoop plug-in you will need to Activate like this:
Next you will see the PropmtLoop Add-In under extensions with the same email that is linked to your PromptLoop email account, like this:
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 transform 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-on menu and click Activate 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 theGoogle account being used is not linked to an active Promptloop account. We recommend making sure that you have clicked the 'Activate Button' in the extension menu and see your email displayed there.
It also may indicate that you have hit the limit of your plan's credit usage. You can read more about plan options here in addition to how to monitor usage here. If you have just upgraded your subscription and continue to hit credit limits, we recommend going to the extension and clicking the 'Re-activate' option before trying to run your functions again. If you think your account is being incorrectly charged for credits please reach out.
If you are continuing to get account errors you may need to reinstall the PromptLoop Add In. You can find more information on how to do that here
This message occurs when there is an internal error and the request times out. You can commonly solve this issue by clearing out the cell before re-running the same function.
This error message indicates that PromptLoop is not Activated in this sheet - Navigate to the Extensions 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 help@promptloop.com and we will be happy to guide you through detailed set up and get started with a few examples so you can start using PromptLoop for your specific needs. Or just say hello!