Chapter
9
 · 
Workflows & Sheets
 · 
08:12
min

Do bulk work with Sheets

Run your workflows on many rows at once, chain them, and review the results in one sheet.

What a sheet is

A sheet looks like a spreadsheet. Each row is one job, like a keyword, a page or a competitor. Some columns hold your data. Others run a workflow on every row, and the results land in new columns next to it. Teams use sheets to write dozens of articles, refresh a whole blog section, or build a set of programmatic pages in one go.

Create a sheet

  1. Build and publish the workflows you need first (see the Workflows lesson).
  2. Open Automate, then Sheets.
  3. Click Create, and start with a blank sheet or import your rows from a CSV file.

Shortcut: on a published workflow, click Add to sheet, then Create new sheet. Slate makes a sheet with that workflow already in it.

Add rows and a workflow column

Add one row per job. In the video, Northwind adds one row per competitor, with the competitor's name and website.

  1. Click Add, then Workflow, and pick one. Only published workflows show up.
  2. Map each input to a column, like the competitor's name to the Competitor column.
  3. Click Create.

Run it

  • Run all runs every row.
  • Run 10 is a good first test.
  • Run failed retries only the rows that broke.
  • You can also run a single cell. Each cell shows its status as it goes.

Results land in the columns next to the workflow. If it returns several fields, like a title, a slug and the page text, each gets its own column. Click a cell to read the full output.

Chain workflows

Add a second workflow column, like a banner image workflow, and map its input to the first workflow's output column. Turn on Run next on success, and each row moves to the next workflow as soon as the one before it finishes. Put a publishing workflow last, and approved pages go to Webflow, WordPress or Sanity.

Review in the sheet

If a workflow has a Human Review step, its cells wait for you. Click Review, check the output, and click Approve & continue. You can also edit the text in the cell editor, leave comments and mention a teammate.

Let Cowork set it up

Ask Cowork to create a sheet from your keyword list, add your article workflow as a column, and run it. Cowork creates the sheet, adds and maps the column, and starts the run. You check the results.

Getting started

  1. Publish one workflow you trust.
  2. Create a sheet with 10 rows and add the workflow as a column.
  3. Run 10, review the outputs, then Run all.

Try it in Slate