Amistio
Get started
All connectors

Google Sheets

Connect your account

Append rows to a Google Sheet using a service-account key. Connect a Google Sheets account under Connections by pasting the service-account JSON, then share the target sheet with the account's client_email.

Publisher: Amistio (built-in) - version 1.0.0 - Apache-2.0

Operations (1)

  • Append a row to a sheet

    googlesheets.values.append

    Append one row to a sheet range. Provide the spreadsheet id, a range (e.g. Sheet1!A:C), and a values array (JSON list of cell values).

    Inputs

    • spreadsheet_id * (string) - The spreadsheet id from its URL.
    • range * (string) - A1 range to append into.
    • values * (object) - JSON array of cell values for the new row.

    Returns

    • updates (number) - Number of cells updated.

    Safety rules

    • The service account must have edit access to the sheet (share it with the account email).

Use Google Sheets from the agent builder - add the block, and reviewed operations run with your own connected account.

Open the builder