Google Sheet

Overview

The Google Sheets connector lets your Agents and Autotasks read from and write to a spreadsheet — a lightweight way to track things like leads, orders, or inventory using a sheet you already have.

What you can do with it

• Create a new spreadsheet, or work with an existing one
• Read all rows and columns from a sheet
• Search a column for matching values
• Add new rows, one at a time or in bulk
• Update existing rows — search for a row and update it in one step
• Delete rows
• Add, remove, or clear worksheets within a spreadsheet
• Run quick totals, averages, or counts over a column of numbers

Connect Google Sheets

1. Go to Connectors in the side menu.
2. Click Add, then choose Google Sheet.
3. Click Connect with Google and sign in through the popup window.
4. Approve access to your spreadsheets.
5. Click Save Connector.

Once connected, Opsfly keeps your access refreshed automatically — you won't need to reconnect unless you revoke access from your Google account.

Next steps

With Google Sheets connected, recruit an Agent to read or update your data automatically, or build an Autotask around specific spreadsheet actions.