How To Use Pipedreamer
Write better prompts, review and revert changes, see credits, and understand how the AI works.
Prompt Clearly
Give Pipedreamer a clear task, background, and sheets/cells to look at.
Good prompts
- Create attendee table in A with Name, Email, Status, Dietary Needs
- Split B into First and Last Name in C/D, add header row
- From sheet "Sales", summarize revenue by region in table starting G1
Bad prompts
- Fix this sheet"Clean dates in B2:B200"
- Make a graph"Pie chart of expenses by department"
View Changes and Revert
Review changes by clicking the "eye" icon, and roll back with the revert button.
- •Icons are only visible when you mouse over them!
- •Green = empty cell was filled
- •Red = cell was cleared
- •Orange = cell changed
- •Yellow = calculated value changed
Settings and Credits
- •Select the top-left gear icon to see credits and usage
- •Securely top up credits with Stripe
- •Send feedback - we read every message
- •Switch accounts, if needed
How Does the AI Work?
Pipedreamer uses LLMs, which generate text based on some input. If the output text is "readCells(A1:A10)", our software will send the the values in cells A1:A10 back to the LLM as an input. This and other "Tool Calls" allow the LLM to be more than a chatbot.
- •We print out a readable version of each tool call - "Writing to cells" instead of "writeCells(A1:A10)"
- •Green dots mean that the tool call worked
- •Red dots mean that something went wrong
- •Tools include: read and write to cells, set formatting, edit charts, and more!
- •We are adding more tools all the time!
