PrompteryxBeta
    ⌘K
    PlatformSupport
    Menu
    IntroductionInstall Desktop & extensionQuick StartPlatform Overview
    OverviewWhat you can makeAI Browser Agent in the chatModels and AutoConnectorsSchedulesProjectsExplore and publishingShare linksMemory and SkillsPersonal agent (beta)Welcome, settings and skinsPlans, credits and top-upsPrompteryx DesktopGroups (pilot)Phone app (early access)
    OverviewCreating WorkflowsTesting & DebuggingScheduling
    OverviewGetting StartedCommandsRecordingSettingsStructured OutputParallel AgentsTips & Best Practices
    OverviewInstallationSidebar AgentUsing Attached FilesExecute on Current TabExporting to Visual Studio
    Overview
    OverviewOpen PageClickClick CoordinatesFillExtract TextScreenshotWaitPress KeyFocus ElementBlur ElementSelect TextHighlight ElementSet ViewportGet Bounding BoxScrollHoverSelect OptionAssertionsCookiesEvaluate JavaScriptExample Workflows
    OverviewPrompteryx Browser AgentOpenAI
    OverviewSchedule TriggerWebhook Trigger
    OverviewGoogle SheetsGoogle CalendarConnect Hub (3,000+ apps)Example Workflows
    AI Vision SettingsChrome Automation ProfilesCloud BrowserBrowser Profiles & Persistent ContextVideo RecordingExecution LogsSharing & CollaborationEdit History
    Selectors GuideVariables
    Start hereGet an API keyRun the AI browser agentDrive a cloud browserRun workflows from anywhereUse connected apps (Connect Hub)SDK (TypeScript)CLIMCP for AI assistants
    REST APIWebhooksMCP toolsCloud Browser APICloud Browser quickstartMigrate from Browserbasen8nZapierMake.com

    Need help? Contact Support

    1. Documentation
    3. Nodes
    5. Integrations
    7. Google Sheets

    Google Sheets

    Integration

    Read, write, and manage spreadsheet data

    Overview

    The Google Sheets integration allows you to read data from spreadsheets, write new rows, update existing data, and manage your Google Sheets documents. It's one of the most commonly used integrations for data storage and reporting.

    Built-in Google Sheets nodes are hidden for now
    The built-in Google Sheets nodes are currently hidden from the Node Library while Google verifies our sign-in. Workflows that already use them keep running, and this page documents their settings. To add Google Sheets to a new workflow, use the Google Sheets app in Connect Hub.

    Available Operations

    Sheet operations: Append Row, Append or Update Row, Clear, Create, Delete, Delete Rows or Columns, Get Row(s) and Update Row. Document (spreadsheet) operations: Create, Delete and Get. The most common ones are below.

    Get Row(s)
    Retrieve data from a spreadsheet
    Parameters
    Configuration options for this node
    Spreadsheet ID or URL
    String
    Required

    The ID of the spreadsheet (found in its URL), or the full URL

    Example: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
    Sheet Name
    String
    Required

    The sheet (tab) within the spreadsheet — pick it from the list or type its name or ID (gid)

    Default: Sheet1
    Range
    String

    A1 notation of the range to read. Leave empty for all data.

    Example: A1:Z100
    Filter Column / Filter Value
    String

    Only return rows where this column (name or letter) has this value

    Example: Status / pending
    Options → Header Row
    Number

    The row that contains the column headers (1-indexed). Options also include First Data Row and Return All Matches.

    Default: 1

    Returns an array of objects where keys are column headers.

    Append Row
    Add new data to the end of a sheet
    Parameters
    Configuration options for this node
    Spreadsheet ID or URL
    String
    Required

    The ID of the spreadsheet, or its full URL

    Example: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
    Sheet Name
    String
    Required

    The sheet to append to

    Default: Sheet1
    Data Mode
    Select

    Map Each Column Below (set each value yourself) or Auto-Map Input Data to Columns (when the incoming data's fields match your column names)

    Default: Map Each Column Below
    Values (JSON)
    String

    JSON object mapping column headers to values (used with Map Each Column Below)

    Example: {"Name": "John", "Email": "john@example.com"}
    Update Row
    Update existing data in a sheet
    Parameters
    Configuration options for this node
    Spreadsheet ID or URL
    String
    Required

    The ID of the spreadsheet, or its full URL

    Example: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
    Sheet Name
    String
    Required

    The sheet containing the row

    Default: Sheet1
    Column to Match On
    String
    Required

    The column used to find the row to update (e.g., an ID column)

    Example: ID, Email
    Value to Match On
    String
    Required

    The value to find in the match column

    Example: 123, john@example.com
    Values to Update (JSON)
    String

    JSON object mapping column names to new values

    Example: {"Status": "completed"}
    Delete Rows or Columns
    Remove rows or columns from a sheet
    Parameters
    Configuration options for this node
    Spreadsheet ID or URL
    String
    Required

    The ID of the spreadsheet, or its full URL

    Example: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
    Sheet Name
    String
    Required

    The sheet containing the rows or columns

    Default: Sheet1
    Delete Type
    Select

    Whether to delete rows or columns

    Default: Rows
    Start Index / End Index
    Number
    Required

    First and last row (or column) to delete, 1-indexed and inclusive

    Example: 5 / 5

    Usage Examples

    Example 1: Log Scraped Data
    Save extracted web data to a spreadsheet

    Workflow:

    1. Open Page: Product listing
    2. Extract Text: Product name → productName
    3. Extract Text: Price → price
    4. Google Sheets — Append Row:
    5. Values (JSON): {"Product": "{{productName}}", "Price": "{{price}}"}
    Example 2: Process Data from Sheet
    Read rows and process each one

    Workflow:

    1. Google Sheets — Get Row(s): get all rows
    2. For Each: loop over the returned rows
    3. ↳ Send an email to the row's email address
    4. ↳ Google Sheets — Update Row: match on the ID column and set Status to "sent"

    Setting Up Connection

    1. Open the Google Sheets node in your workflow
    2. In the Connection field, pick your Google Sheets credential
    3. Paste the spreadsheet ID or URL
    4. Pick the sheet from the Sheet Name list (or type its name)
    For new workflows, add the Google Sheets app through Connect Hub and use its Sign in with Google Sheets button.

    Best Practices

    Use Header Rows
    Always have a header row with column names. Rows come back as objects keyed by those headers, so you can reference data by column name instead of by column index.
    Add a Status Column
    Include a "status" or "processed" column to track which rows have been handled. Update it after processing to avoid reprocessing the same data.
    Use Unique IDs
    Add a unique ID column to easily find and update specific rows. Set it as the Column to Match On when you update a row.

    Related Documentation

    For Each Loop

    Process rows from sheets

    Variables Guide

    Use sheet data in workflows

    Schedule Trigger

    Run sheet processing on schedule