Files and output

Create Spreadsheet Block

Create Spreadsheet builds a spreadsheet file from manual rows or mapped variable sources.

At a glance

Best for
CSV/XLSX output
Input
Columns and rows
Output
Spreadsheet file reference
Error handle
Yes

What it does

Create Spreadsheet converts structured data into a file your team can download or send to another tool.

Use columns to control which fields appear and in what order.

Use it when

  • Export Extract Data rows as CSV.
  • Create an XLSX file from manually mapped fields.
  • Prepare a file for upload, storage, or email.

Do not use it when

  • You want to write directly to Google Sheets; use Create Google Sheet.
  • You need JSON output; use Save File.
  • There are no valid columns to write.

Settings

Create Spreadsheet needs columns, file format, filename, data mode, destination, and output variable.

Columns

Required: Yes
Variables
Sources can use variables
Description
Column definitions and data sources.

Format

Required: No
Variables
No
Description
CSV or XLSX output.

Filename

Required: No
Variables
Yes
Description
Spreadsheet file name.

Destination

Required: No
Variables
No
Description
Local or cloud destination depending on runtime.

Output variable

Required: Recommended
Variables
Variable name
Description
Stores the spreadsheet file reference.

Outputs

Create Spreadsheet outputs a file reference and row metadata.

{{outputVariableName}}file

CSV or XLSX file reference.

rowCountnumber

Number of rows written when reported by the runtime.

Example Flow

Create Spreadsheet usually follows extraction or collection.

  1. Extract or collect rows.
  2. Map fields into spreadsheet columns.
  3. Save, upload, or email the generated file.

Errors and fixes

Start with symptoms visible in the editor or Inspector, then check the earliest Block that produced the wrong page state, variable, or output.

The Block fails with no columns.

Check
Check that at least one valid column is configured.
Fix
Add the columns you want to export.

Cloud Run cannot save locally.

Check
Check the destination.
Fix
Use cloud storage for Cloud Runs.

Local and cloud runs

Both runtimes create spreadsheet files from configured columns. Cloud artifact output includes row and column metadata when available.