Workflows
Save a task you repeat as steps GPTExcel follows every time, then run it in one click, in the background, or on a schedule.
A workflow is a task you do more than once, saved as a list of steps. Each time it runs, GPTExcel follows the same steps on the files you give it, plus any files kept with the workflow, and every run happens in a chat of its own. A monthly sales summary, a weekly cleanup of an export, or a report that always uses the same template are good candidates.
Make a workflow from a chat
The quickest way is to do the task once in a chat, then ask:
Save this as a workflow I can run every monthGPTExcel writes the steps from what it just did and shows a workflow card with its name, how many steps it has, the files it needs and any files kept with it. The card has Run, Edit and Schedule. Schedule opens the schedule, or the editor with what to change when the workflow still needs a file attached each run.
To change a saved workflow, ask in the same chat, for example "change the workflow to also add a chart". It updates the workflow in place rather than making a new one.
Make a workflow on the Workflows page
Open Workflows in the sidebar and click New workflow. The editor has these parts:
| Field | What it's for |
|---|---|
| Name and What it produces | A name, and a sentence about the result, such as "A one-page summary of last month's sales by region, with a chart." |
| Steps | Up to 12. Each has a title, an instruction, the tool it uses, the inputs it works on and, optionally, a file name it saves as (such as Report-{Month}.xlsx). |
| Inputs | Up to 5 files the workflow works on, each with a role: Data, Template or Reference. |
| Files kept with the workflow | Up to 5 files saved with the workflow itself, such as a template or a lookup table. You can add them once the workflow is created. |
| Agents to switch on | The agents its runs need, such as Pivot Builder or Slide Deck Builder. |
| Model | Fast, Standard or Expert. Tiers your plan doesn't include are locked. |
| Who can use it | Only you, or your team on a Team plan. |
Each step's tool can be AI decides, Read files, Python (clean, calculate and build Excel files with code), Pivot agent, Slides agent, Web search or Save to cloud (save results to Google Drive or OneDrive). Enhance rewrites a step's instruction more clearly, using the workflow's other steps as context.
Where each input comes from
Every input has a source:
- Attached each run: you attach the file when you run it.
- Kept file: one of the files kept with the workflow.
- Team file, or Newest file in a team folder (team workflows only): a file from your team's shared files, or whichever file in a folder is newest, such as this month's export.
A workflow with a required input that is attached each run is marked Needs you each run. One that gets all its files from kept or team files is marked Runs on its own, and only those can run in the background or on a schedule.
Run a workflow
Click Run
Click Run on the Workflows page or on the workflow card in a chat. A new chat opens with the workflow in the message box and its agents switched on.
Attach the inputs
Attach the files the workflow asks for. Typing a message is optional: add one if this run needs something different, such as "only the North region this time".
Send
GPTExcel follows the steps on your files and answers in the chat as usual. A run is an ordinary chat message: it uses the workflow's model tier and costs the same credits as any message on that tier, plus any agents or web searches it uses.
Run it in the background
For a workflow that Runs on its own, Background on the Workflows page runs it without opening a chat. It still runs in a new chat, which you can open while it's running or afterwards. One background run of a workflow runs at a time.
Run history
The history button next to a workflow lists its runs and how each started: From chat, In background or Scheduled, marked as a re-run when it was one. Details on a run shows:
- each step, with any errors,
- the files it started with and the files it produced, with download links for your own runs,
- the credits it used.
Re-run with the same inputs starts the run again in the background, in a new chat. Files you attached are copied into the new chat, and kept and team files are fetched again. Only the person who ran it can re-run it.
Schedules
A workflow that Runs on its own can run on a schedule. Click the schedule button on the Workflows page, or Schedule on the workflow card, then choose:
- Repeats: Once, Every day, Every week or Every month (on a day you choose),
- the time, in a Time zone you pick,
- whether to use top-up credits if plan credits run out (off unless you turn it on).
Each scheduled run starts a new chat, as you and on your workspace's plan. A chat from a run you didn't watch has a dot in the sidebar until you open it. You can Pause and Resume a schedule at any time.
If a run can't start or fails 3 times in a row, the schedule pauses itself. You get a notification (the bell) when a background or scheduled run fails, when a run is skipped, and when a schedule pauses.
| Plan | Active schedules |
|---|---|
| Free | None (you can still run workflows yourself) |
| Plus | 3 |
| Pro, Team and Business | No limit |
Each workflow has one schedule. See Pricing for what each plan includes.
Workflows for teams
On a Team plan, set Who can use it to your team to share a workflow. Everyone on the team can see and run it; the person who made it and the team's admins can edit, schedule and delete it. Team workflows can take their inputs from the team's shared files, and their background and scheduled runs use the team's credits.
Limits
- 100 workflows per person, personal and team together.
- 12 steps, 5 inputs and 5 kept files per workflow. Kept files follow your plan's file size limit.
Tip: start from a chat
Doing the task once in a chat and then saving it gives the AI a worked example to copy, so the saved steps are usually closer to what you want than ones written from scratch. Run it once on a new file to check it before you schedule it.