DOCUMENTATION

Google Sheets

Your AI agent can read from and write to Google Sheets. This is useful for building dashboards from spreadsheet data, automating data entry, or syncing information between your apps and Google Sheets.

Service Account Setup

A service account is a special Google account for programmatic access. It can read and write sheets you share with it.

1

Go to console.cloud.google.com and create a project (or use an existing one).

2

Enable the Google Sheets API in APIs & Services.

3

Go to IAM & Admin → Service Accounts. Create a service account and download the JSON key file.

4

Share your Google Sheet with the service account email (it looks like name@project.iam.gserviceaccount.com).

5

Upload the JSON key file to your Versors machine (drag and drop onto the desktop).

6

Tell your agent: "Connect to my Google Sheet using the service account key I uploaded. The sheet URL is [paste URL]."

ⓘ
About service account keys: The JSON key file is stored only on your private Versors machine. Service accounts have limited permissions -they can only access sheets explicitly shared with them. You can delete the service account from Google Cloud Console at any time to revoke all access. For extra safety, only share specific sheets (not entire drives) with the service account.

Example Prompts

"Read my sales data from Google Sheets and create a dashboard with charts"

"Add a new row to my inventory sheet every time I process an order"

"Sync my contacts spreadsheet with the CRM app we built"

"Create a weekly report from the data in my analytics sheet"

← Connecting to EmailDatabases →