Getting Started with PromptLoop
Welcome to PromptLoop, where we empower you with cutting-edge AI tools to automate and enhance your data tasks. Our platform is designed to cater to a wide range of use cases, from web scraping and content analysis to complex data transformations, all within the familiar environment of Google Sheets.
We are always adding capabilities to our platform, and unlike an app store, you will automatically be able to access new and improved capabilities with every request.
Overview of PromptLoop's Capabilities
PromptLoop offers a comprehensive suite of AI-driven functions that enable you to:
- Turn a spreadsheet into a list of tasks for AI models: With our file uploader and spreadsheet functions, you can run specific formatted AI tasks to return web results for research and categorize data.
- Create Custom Tasks: PromptLoop works by taking a set of your instructions and building out a model "task" for you to run on each row of data or set of inputs. This could be a block of text, name of company, website, or anything.
- Integrate with Spreadsheets and Datasets: You can use PromptLoop capabilities right in your spreadsheet apps, and drag and drop an Excel or CSV file to create a dataset that you can run your AI tasks on and view in our web platform
By harnessing AI's power, PromptLoop transforms how you interact with data, making it more efficient, accurate, and insightful.
Create a custom AI tool with a prompt
Datasets is our platform too that allows you to schedule and automate your data processing tasks. Describe what you want once, test it immediately in the web editor, and let the AI do the heavy lifting, ensuring your data is always up-to-date and actionable. More here.
Custom Tasks are the cornerstone of PromptLoop's versatility. They provide a flexible framework for creating AI-driven automation specifically designed to meet your unique business challenges. Whether you're looking to scrape web data, analyze customer feedback, or create custom datasets, Custom Tasks rapidly adapt to your objectives. More here
Seamless Spreadsheet Integration - Guide for AI in Google Sheet and Excel
PromptLoop's AI integration with Google Sheets brings the power of AI directly to your spreadsheets. Adding AI functions to your data toolkit allows you to perform complex operations like text categorization, data extraction, and content generation without ever leaving your spreadsheet. This seamless integration ensures that your data remains centralized and accessible while also benefiting from the advanced capabilities of AI.
Ready to revolutionize the way you work with data? Follow the steps below to enable PromptLoop in Google Sheets and explore the AI functions that will transform your data tasks.
1. Enable PromptLoop
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
2. Activate
After you have added the PromptLoop plug-in, you will need to Activate it like this:
3. Email Linked
Next, you will see the PropmtLoop Add-In under extensions with the same email that is linked to your PromptLoop email account, like this:
PromptLoop Functions
Once installed, you can access several functions powered by various AI models.
Choosing the proper function depends on what you are trying to accomplish. These questions can help you get started selecting 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 AI models that can browse the web, read, research, and return what you are looking for. This information is current, accurate, and not based on any training data set.
Want something else? Visit the tasks page to create a custom task for your inputs.
You must activate PromptLoop in any sheet you want to use the formula. 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 you recall the model and reload your sheet.
Note: PromptLoop is made for text transformations. When working with numbers, it is still most straightforward to use the formulas you are used to.
Error Messages
This error message indicates that the input, output examples, and 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 Google account being used is not linked to an active Promptloop account. We recommend ensuring 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 running your functions again. Please reach out if you think your account is being incorrectly charged for credits.
If you continue getting 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 an internal error occurs and the request times out. You can commonly solve this issue by clearing the cell before rerunning 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. If this persists, you may have to reload the sheet and delete/re-enter the formula.
Need Help?
Reach out to [email protected], and we will be happy to guide you through a detailed setup and get started with a few examples so you can begin to using PromptLoop for your specific needs. Or just say hello!