Create Spreadsheet Block
Create Spreadsheet builds a spreadsheet file from manual rows or mapped variable sources.
At a glance
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}}fileCSV or XLSX file reference.
rowCountnumberNumber of rows written when reported by the runtime.
Example Flow
Create Spreadsheet usually follows extraction or collection.
- Extract or collect rows.
- Map fields into spreadsheet columns.
- 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.