Update or add rows

• Type sheets.upsertRows
• Group Apps
• Role action
• Risk acts outside MZBase
• Side effect has an effect each run
• Runs once per execution
• Needs network
• Credentials oauth2

Updates the rows whose match column equals the item’s value and adds the others

Also available to AI agents and over MCP as a tool.

Parameters

credentialId

Credential · string · optional

A saved credential from the vault; it adds the authentication for you.

spreadsheetId

Spreadsheet id · string · required

range

Range · string · required

matchColumn

Match column · string · required

columns

Columns · array · optional

valueInput

Values · string · optional · default userEntered · one of userEntered, raw

Outputs

• main

← All nodes