You can the AI data proccesor to include OpenAI in any Sheetgo automation. By default, it uses the GPT 4o-mini model, which can only handle 128K tokens at a time. To customize the AI model or access your GPTs, set up an OpenAI account.
Building an automation with AI processing
Create a Blank workflow.
Choose Create an automation.
Select your data source.
Choose the AI data processing.
Provide a prompt to determine a set of tasks for the AI to perform. Keep reading for a list of best practices for prompt generation.
Write "@column" in the instructions box to display a dropdown with all the columns in the source. Adding column headers becomes quick and error-free.
Play around with the Most popular options, which provide prompt templates to start with tried and tested use cases.
Select a spreadsheet destination for your data.
Click Finish.
Creating effective prompts to process your data
To get good results, apply best practices for prompt generation:
✔️ Break down tasks into steps and provide them in a list.
✔️ Whenever possible frame actions positively (for example, instruct AI to "use descriptive language" instead of telling it to "avoid using filler words").
✔️ Provide context and be very specific about the intended outcome.
And remember, this is a process. You may need to tweak the prompt to get the results you expect.
FAQ
How many transfers does the AI processor consume?
How many transfers does the AI processor consume?
If you use the basic AI processor, it costs 1 transfer per 100K tokens to run. If you use your own OpenAI account, it costs 1 transfer per processor.
How to fix the error "Data is too large to be processed by AI: Try to use your own credentials and models."?
How to fix the error "Data is too large to be processed by AI: Try to use your own credentials and models."?
This message is shown when a data source exceeds 128K tokens. Filter out unnecesary data using other data processors to stay within this limit. Alternatively, you can set up your own OpenAI account to choose a model that can process more tokens.