
How it works
The primary purpose of the sidebar is to bring your ideas to life by actually adding steps to the canvas on your behalf. Through the sidebar, you can add new steps, edit existing steps, or delete steps that are no longer needed. It can change how arrows are connected, and re-arrange steps on your canvas. The sidebar can also be used to chat about your flow. If you don’t know what a flow does, or how it is producing a certain result, just ask the sidebar! It can help summarize logic and direct you towards salient parts of your flow. In new flows, use the sidebar to chat about your overall use case - what data you are going to need to access, what your ultimate goal is, and any considerations you already know about. You can talk through your use case to create a plan of action, and then let the chat take it from there.Best practices: Writing effective prompts for Parabola’s AI chat & Custom transform step
Overview
There are two main ways to write prompts in Parabola:- AI chat sidebar: Your AI teammate that helps you build and troubleshoot flows in plain language.
- Custom transform step: A flexible step that translates plain language prompts into deterministic code that transforms your data.
Core Prompt Structure
Every strong prompt answers three basic questions:What’s the use case or goal?
What’s the use case or goal?
- Be specific about the outcome you’re trying to achieve.
What data are you working with?
What data are you working with?
- Mention sources, formats, relevant columns, and assumptions.
What should the output look like?
What should the output look like?
- Describe final column names, data formats, and any visualizations or exports.
Example Prompts
✅ Good Prompts
Pulling data:Help me build a sales report broken down by SKU using the last 30 days of data imported from Shopify.
Filter out any sales where the “Gift card?” value is not blank.
Export this report via email by sending an Excel file to sam@acme.com. Also, let’s create a data visualization showing sales by week.
Create a new column titled “WoW Change” based on the following logic:
- For each customer, calculate the # shipments from the previous week
- Compare it to the current week’s shipments
- Calculate the % change
- Format as a percentage with 2 decimal points
- Return all original columns
Best Practices for Writing Prompts
1. Be Specific, Not Vague
- ❌
“Make a report.” - ✅
“Create a sales report by SKU, using the last 30 days of Shopify data.”
2. Reference Exact Columns
- Use double quotes to refer to columns, e.g.,
"Order Date","Gift card?".
3. Describe the Logic Clearly
Break down logic into steps:- Add a column “Profit”
- Subtract “Cost” from “Revenue”
- Format as currency with 2 decimal places
4. Call Out Formats and Edge Cases
- Specify currency, date, percentage, casing, etc.
- If null values or duplicates need special handling, say so explicitly.
5. Use Clean Formatting
Structure your prompt like you’re writing an SOP:- Bullets or numbered lists
- Line breaks between steps
- Avoid paragraphs of dense text
Tips from the Parabola Team
Prompt Optimization Checklist
When in doubt, check if your prompt includes: ✅ Clear use case or outcome✅ Mention of data source(s)
✅ Specific columns referenced
✅ Desired format (currency, %, casing, date, etc.)
✅ Any edge cases or assumptions
✅ Clean formatting (bullets, newlines)
Final Word: When in Doubt, Try it Out
Prompts are iterative by nature. You won’t get it perfect on the first try—and that’s okay.“You’re not going to break anything. Everything you do can be undone. Just describe your goal, try it out, and iterate as you go.”— Isaac Wyatt, Automation Engineering Lead at Parabola
Additional example prompts
Example prompts
- Pulling data:
- ” Help me build a sales report broken down by SKU using the last 30 days of data imported from Shopify.”
- “I want to pull gift card data from Shopify and push data to a Google Sheet. Help me pull in data and set up the flow.”
- “I want to connect to the ShipHero API — help me pull in shipments.”
- Transforming data:
- “Filter out any sales where the ‘Gift card?’ value is not blank.”
- “Calculate the number of weekdays between the ‘Order Date’ and ‘Ship Date’ columns.”
- “How do I classify all of my products by product type?”
- Exporting data:
- **“**Export this report via email by sending an Excel file to jj@parabola.io.”
- “Create a data visualization showing sales by week.”
- “Let’s send this data as a Slack message every time the flow runs.”
- Understanding flows:
- “What is happening in this flow?”
- “Explain how the ‘Calculate revenue by SKU’ card works and break down the steps”
- “What columns are we using to calculate COGS?”
- Troubleshooting flows:
- “Fix the error in the math step”
- “Why am I seeing an error in this step?”