Scrapeer
Integrations

Create Google Sheet Block

Create Google Sheet writes rows into a new or existing Google spreadsheet using a configured Google connection.

At a glance

Best for
Google Sheets output
Requires
Google connection
Modes
Create, append, overwrite
Error handle
Yes

What it does

Create Google Sheet sends structured Flow data to Google Sheets.

It can create a spreadsheet or write into an existing spreadsheet depending on write mode and settings.

Use it when

  • Send Extract Data rows to a team spreadsheet.
  • Append scheduled run results over time.
  • Create a new sheet for a finished run.

Do not use it when

  • You need a downloadable file; use Create Spreadsheet.
  • No Google connection is configured.
  • The row data is not structured enough for columns.

Settings

Create Google Sheet needs a connection, spreadsheet/sheet settings, columns or rows, write mode, and output variable.

Google connection

Required: Yes
Variables
No
Description
Connection used to access Google Sheets.

Spreadsheet and sheet

Required: Yes
Variables
Yes
Description
Spreadsheet name or ID and sheet name.

Columns and rows

Required: Yes
Variables
Sources can use variables
Description
Data to write into the sheet.

Write mode

Required: No
Variables
No
Description
Create, append, or overwrite.

Output variable

Required: Recommended
Variables
Variable name
Description
Stores Google Sheets result metadata.

Outputs

Create Google Sheet returns sheet metadata.

{{outputVariableName}}object

updatedRows, spreadsheetUrl, spreadsheetId, and sheetName.

Example Flow

Use Create Google Sheet after extraction or collection when results should be shared in Sheets.

  1. Extract or collect rows.
  2. Map rows into columns.
  3. Write them to Google Sheets.

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.

Rows do not appear in the expected sheet.

Check
Check write mode, spreadsheet ID, and sheet name.
Fix
Use the intended mode and verify the target spreadsheet.

The Block fails on permissions.

Check
Check the selected Google connection.
Fix
Reconnect or choose a connection with access to the spreadsheet.

Local and cloud runs

Both runtimes use the configured Google connection and return Google Sheets metadata when the write succeeds.

Blocks

Understand how Blocks connect and pass state through a Flow.

Runs and outputs

Inspect Block output, errors, and variables after a run.