# Google Sheets AI agent for Slack & Microsoft Teams Viktor is an AI employee that connects to Google Sheets in one click via OAuth and helps you build and maintain no-code apps, databases, or workflows, running 38 Google Sheets actions for you like Get Cell, Find Row, and Add Rows. Ask in plain English in Slack or Microsoft Teams; Viktor does the work in Google Sheets and reports back. Setup takes about two minutes. - Tool: Google Sheets - Category: Productivity - Connection: One-click OAuth - Actions available: 38 - Works from: Slack and Microsoft Teams - Page: https://viktor.com/integrations/google-sheets ## What can you ask Viktor to do in Google Sheets? - "Add these new records to the Google Sheets base and tag them by status." - "Build a simple Google Sheets view that shows only open items assigned to me." - "Watch Google Sheets for new records and post them to the channel as they come in." - "Set up a Google Sheets workflow that runs this check every morning and reports back." ## What can Viktor do in Google Sheets? (38 actions) - **Upsert Row** - Upsert a row of data in a Google Sheet. - **Update Row** - Update a row in a spreadsheet. - **Update Multiple Rows** - Update multiple rows in a spreadsheet defined by a range. - **Update Formatting** - Update the formatting of a cell in a spreadsheet. - **Update Conditional Format Rule** - Modify existing conditional formatting rule. - **Update Cell** - Update a cell in a spreadsheet. - **Set Data Validation** - Add data validation rules to cells (dropdowns, checkboxes, date/number validation). - **Read Rows** - Read rows from a Google Sheets worksheet. Returns data as objects (keys = column headers from row 1) by default, or as raw arrays. Use Get Spreadsheet Info first to discover worksheet names. Optionally specify a range in A1 notation (e.g., A2:D10) to read a subset. For searching rows by value, use Find Rows instead. - **New Spreadsheet** - Create a new Google Spreadsheet with an optional worksheet name and column headers. Returns the spreadsheet ID and URL. Use the spreadsheet ID with other tools to read/write data. - **Move Dimension** - Move a dimension in a spreadsheet. - **Merge Cells** - Merge a range of cells into a single cell. - **List Worksheets** - Get a list of all worksheets in a spreadsheet. - **List Spreadsheets** - List Google Spreadsheets accessible to the authenticated user. Optionally search by name. Returns spreadsheet IDs that can be used with all other tools. - **Insert Dimension** - Insert a dimension into a spreadsheet. - **Insert Comment** - Insert a comment into a spreadsheet. - **Insert an Anchored Note** - Insert a note on a spreadsheet cell. - **Get Values in Range** - Get all values or values from a range of cells using A1 notation. - **Get Spreadsheet Info** - Get the structure of a Google Spreadsheet — worksheet names, column headers (first row of each sheet), and row counts. Call this first before reading or writing data, so you know the worksheet names and column headers. The column headers are used as keys when writing data with Add Rows or Update Rows. The spreadsheet ID is the long string in the Google Sheets URL. - **Get Spreadsheet by ID** - Returns the spreadsheet at the given ID. - **Get Current User** - Retrieve Google Sheets account metadata for the authenticated user by calling Drive's about.get, returning the user profile (display name, email, permission ID) and storage quota information. Helpful when you need to verify which Google account is active, tailor sheet operations to available storage, or give an LLM clear context about the user identity before composing read/write actions. See the Drive API documentation. - **Get Cell** - Fetch the contents of a specific cell in a spreadsheet. - **Find Rows** - Search for rows matching a value in a specific column. Use Get Spreadsheet Info to discover column header names. Returns matching rows as objects with row numbers (useful for subsequent Update Rows calls). For simple reads without filtering, use Read Rows instead. - **Find Row** - Find one or more rows by a column and value. - **Delete Worksheet** - Delete a specific worksheet. - **Delete Rows** - Deletes the specified rows from a spreadsheet. - **Delete Conditional Format Rule** - Remove conditional formatting rule by index. - **Create Worksheet** - Create a blank worksheet with a title. - **Create Spreadsheet** - Create a blank spreadsheet or duplicate an existing spreadsheet. - **Copy Worksheet** - Copy an existing worksheet to another Google Sheets file. - **Clear Rows** - Delete the content of a row or rows in a spreadsheet. Deleted rows will appear as blank rows. - **Clear Cell** - Delete the content of a specific cell in a spreadsheet. - **Add Worksheet** - Add a new worksheet (tab) to an existing spreadsheet. Optionally set column headers. Use Get Spreadsheet Info to see existing worksheets before creating. - **Add Single Row** - Add a single row of data to Google Sheets. Optionally insert the row at a specific index (e.g., row 2 to insert after headers, shifting existing data down). - **Add Rows** - Append one or more rows to a Google Sheets worksheet. Pass rows as a JSON array. Preferred format: array of objects with column header keys (e.g., [{"Name": "Alice", "Email": "alice@example.com"}]). Use Get Spreadsheet Info first to discover the exact column header names — keys must match headers exactly (case-sensitive). Alternatively, pass rows as arrays of positional values matching column order. New rows are appended after the last row with data. - **Add Protected Range** - Add edit protection to cell range with permissions. - **Add Multiple Rows** - Add multiple rows of data to a Google Sheet. - **Add Conditional Format Rule** - Create conditional formatting with color scales or custom formulas. - **Create Column** - Create a new column in a spreadsheet. ## How does Viktor work with Google Sheets? 1. Add Viktor to Slack or Microsoft Teams. 2. Connect Google Sheets with one-click OAuth - Viktor handles authentication. 3. Ask in plain English. Viktor runs the Google Sheets actions, chains them with your other tools when needed, and reports back. Sensitive actions wait for your approval. ## What is a Google Sheets AI agent? A Google Sheets AI agent is an AI that connects to your Google Sheets account and completes work in it - it doesn't just answer questions about Google Sheets, it takes the actions. Viktor is that agent: an AI employee that works in Google Sheets on your behalf and delivers the finished result in Slack or Microsoft Teams. Unlike workflow builders such as Zapier or Make, there is nothing to configure - no triggers to map, no workflows to maintain. You describe the outcome in plain English, and Viktor picks the right Google Sheets actions, chains them with the other 3,200+ tools it connects to, and asks for approval before anything sensitive runs. ### About Google Sheets Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps ## Security and permissions - One-click OAuth - Viktor never sees your password, and you can revoke access at any time. - Review-first approvals: sensitive Google Sheets actions wait for your sign-off before they run. - Isolated compute per team, encrypted in transit and at rest - and your data is never used to train models. - SOC 2 Type 1 compliant, with Type 2 and ISO 27001 in progress. ## FAQ ### Does Viktor integrate with Google Sheets? Yes. Google Sheets is one of the 3,200+ tools Viktor connects to, via a managed connector. Once connected, anyone on your team can put Viktor to work in Google Sheets from Slack or Microsoft Teams - no workflow builder, no code. ### How do I connect Google Sheets to Viktor? Ask Viktor in Slack or Microsoft Teams to connect Google Sheets, then approve the one-click OAuth prompt. Viktor never sees your password, handles authentication itself, and starts working right away. Setup takes about two minutes, and you can revoke access at any time. ### What can Viktor do in Google Sheets? Viktor can run 38 Google Sheets actions, including Get Cell, Find Row, and Add Rows - and chain them with other tools in a single request. In practice that means Viktor helps you build and maintain no-code apps, databases, or workflows. If a task spans several actions, Viktor plans the sequence itself and reports back when the work is done. ### Do I need to build workflows to automate Google Sheets? No. Viktor isn't a workflow builder - there are no triggers to map and no workflows to maintain. You ask for the outcome in plain English in Slack or Microsoft Teams, and Viktor decides which Google Sheets actions to take, runs them, and reports back. ### Is my Google Sheets data secure with Viktor? Yes. Viktor connects to Google Sheets in one click via OAuth, runs in an isolated environment per team, and never trains models on your data. Sensitive actions wait for your approval, and you can revoke access at any time. Viktor is SOC 2 Type 1 compliant, with Type 2 and ISO 27001 in progress. ### How much does the Google Sheets integration cost? Nothing extra - every integration, including Google Sheets, is available on every plan. You can start free with up to $100 in credits, no credit card required; paid plans start at $50/month. ### Can Viktor use Google Sheets together with my other tools? Yes - that's the point. Viktor connects to 3,200+ tools and works across them in a single run: it can pull data from Google Sheets, cross-reference it with another tool - for example Slack or Gmail, and deliver the finished result in Slack or Microsoft Teams. ## Viktor uses Google Sheets together with - [Slack](https://viktor.com/integrations/slack) - [Gmail](https://viktor.com/integrations/gmail) - [HubSpot](https://viktor.com/integrations/hubspot) - [Notion](https://viktor.com/integrations/notion) - [Salesforce](https://viktor.com/integrations/salesforce) - [Stripe](https://viktor.com/integrations/stripe) ## More Productivity integrations - [GitHub](https://viktor.com/integrations/github) - [Asana](https://viktor.com/integrations/asana) - [Basecamp](https://viktor.com/integrations/basecamp) - [Monday.com](https://viktor.com/integrations/monday-com) - [Jira](https://viktor.com/integrations/jira) - [Linear](https://viktor.com/integrations/linear) - [Miro](https://viktor.com/integrations/miro) - [ServiceM8](https://viktor.com/integrations/servicem8) ## Get started Viktor is free to start - up to $100 in credits, no credit card required. All 3,200+ integrations are included on every plan. Sign up at https://viktor.com or browse all integrations at https://viktor.com/integrations.