Integrate Google Sheets with Skyvern
Read inputs from a sheet and write results back, in the same agent.
Connect Google SheetsOpens the Integrations page of the Skyvern app.
- Maintained by
- Built by Skyvern
- Works with
- Skyvern Cloud
- You need
- A Google account
Who calls whom
- Rows in your sheet
- Skyvern agent
- Website
- 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
- 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
- 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
- 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
- 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.