SkyvernSkyvern Google Sheets logoGoogle Sheets

    Integrate Google Sheets with Skyvern

    Read inputs from a sheet and write results back, in the same agent.

    Connect Google Sheets

    Opens the Integrations page of the Skyvern app.

    Maintained by
    Built by Skyvern
    Works with
    Skyvern Cloud
    You need
    A Google account

    Who calls whom

    1. Rows in your sheet
    2. Skyvern agent
    3. Website
    4. Results written to the sheet

    How it works

    Skyvern reads and writes your spreadsheet inside an agent. You connect a Google account once with Google sign-in. A Google Sheets Read block gives the agent its rows, the agent does the work on the website for each row, and a Google Sheets Write block appends the results or updates a range.

    Example: a sheet holds 200 invoice numbers. The agent reads the rows, looks up each invoice on a vendor portal, and appends the status and amount to a results tab.

    What you can do

    Blocks and their options

    Google Sheets Read

    Read a tab or an A1 range. With a header row, each row comes back as an object keyed by column name.

    Google Sheets Write

    Append rows below the existing data, or overwrite a range. Map fields to columns by letter or header.

    Create sheet if missing

    Create the tab before writing, for sheet names that change per loop iteration.

    Setup

    Before you start

    • A Skyvern account (14-day free trial)
    • A Google account with access to the spreadsheet
    1. 01

      Click Connect

      In the Skyvern app, open Integrations and click Connect on the Google Sheets tile.

      Skyvern app
      Page:
      Integrations
      Category:
      Workspace
      Button:
      Connect
    2. 02

      Name the connection

      Enter a name such as "Finance Sheets". You pick the account by this name in your agent's blocks. Then click Continue to Google.

      Name the connection
      Name:
      Finance Sheets
      Button:
      Continue to Google
    3. 03

      Approve access

      Sign in and approve every permission on the consent screen. Skyvern asks to read and write spreadsheets and to read Drive file metadata.

      Google consent screen
      Spreadsheets:
      read and write
      Drive:
      file metadata, read only
    4. 04

      Add a Google Sheets block

      In your agent, add Google Sheets Read or Google Sheets Write, pick the account and the spreadsheet, and name the tab.

      Google Sheets Read
      Google Account:
      Finance Sheets
      Spreadsheet:
      search or paste a URL
      Sheet Name:
      Sheet1
      Range:
      A1:D10 (optional)

    FAQ

    What access does Skyvern ask for?

    Read and write access to spreadsheets, and read access to Drive file metadata.

    Can I connect more than one Google account?

    Yes. Add another account on the connected card and give each one a name. Agent blocks show the names in their account picker.

    Can an agent write to a different tab on each loop?

    Yes. Turn on Create sheet if missing in the Write block's Advanced Settings, and use a sheet name that changes per iteration.

    What happens if I disconnect the account?

    Disconnecting cannot be undone. Agents that use the account fail on their next run until you reconnect it or pick another account in their blocks.

    Who can connect an account?

    By default every Admin and Member. With role-based access control turned on, only roles that were granted it. A Member can still pick an already connected account in an agent's blocks.

    Ready to automate your portal workflows?

    14-day free trial. Cancel any time.