Google Sheets + AutoGPT

Actions

Steps your experts and workflows can take in Google Sheets.

• Add Column

  Add a new column with a header. Can add at the end or insert at a specific position.

  Docs

• Add Dropdown

  Add a dropdown list (data validation) to cells. Useful for enforcing valid inputs.

  Docs

• Add Note

  Add a note to a cell in a Google Sheet

  Docs

• Append Row

  Append or Add a single row to the end of a Google Sheet. The row is added after the last row with data.

  Docs

• Batch Operations

  This block performs multiple operations on a Google Sheets spreadsheet in a single batch request.

  Docs

• Clear

  This block clears data from a specified range in a Google Sheets spreadsheet.

  Docs

• Copy To Spreadsheet

  Copy a sheet from one spreadsheet to another.

  Docs

• Create Named Range

  Create a named range to reference cells by name instead of A1 notation.

  Docs

• Create Spreadsheet

  This block creates a new Google Sheets spreadsheet with specified sheets.

  Docs

• Delete Column

  Delete a column by header name or column letter.

  Docs

• Delete Rows

  Delete specific rows from a Google Sheet by their row indices. Works well with FilterRowsBlock output.

  Docs

• Export Csv

  Export a Google Sheet as CSV data

  Docs

• Filter Rows

  Filter rows in a Google Sheet based on a column condition. Returns matching rows and their indices.

  Docs

• Find

  Find text in a Google Sheets spreadsheet. Returns locations and count of occurrences. Can find all occurrences or just the first one.

  Docs

• Find Replace

  This block finds and replaces text in a Google Sheets spreadsheet.

  Docs

• Format

  Format a range in a Google Sheet (sheet optional)

  Docs

• Get Column

  Extract all values from a specific column. Useful for getting a list of emails, IDs, or any single field.

  Docs

• Get Notes

  Get notes from cells in a Google Sheet

  Docs

• Get Row

  Get a specific row by its index. Returns both list and dict formats.

  Docs

• Get Row Count

  Get row count and dimensions of a Google Sheet. Useful for knowing where data ends.

  Docs

• Get Unique Values

  Get unique values from a column. Useful for building dropdown options or finding distinct categories.

  Docs

• Import Csv

  Import CSV data into a Google Sheet

  Docs

• Insert Row

  Insert a single row at a specific position. Existing rows shift down.

  Docs

• List Named Ranges

  List all named ranges in a spreadsheet.

  Docs

• Lookup Row

  Look up a row by finding a value in a specific column. Returns the first matching row and optionally specific columns.

  Docs

• Manage Sheet

  Create, delete, or copy sheets (sheet optional)

  Docs

• Metadata

  This block retrieves metadata about a Google Sheets spreadsheet including sheet names and properties.

  Docs

• Protect Range

  Protect a cell range or entire sheet from editing.

  Docs

• Read

  A block that reads data from a Google Sheets spreadsheet using A1 notation range selection.

  Docs

• Remove Duplicates

  Remove duplicate rows based on specified columns. Keeps either the first or last occurrence.

  Docs

• Set Public Access

  Make a Google Spreadsheet public or private

  Docs

• Share Spreadsheet

  Share a Google Spreadsheet with users or get shareable link

  Docs

• Sort

  Sort a Google Sheet by one or two columns. The sheet is sorted in-place.

  Docs

• Update Cell

  Update a single cell in a Google Sheets spreadsheet.

  Docs

• Update Row

  Update a specific row by its index. Can use list or dict format for values.

  Docs

• Write

  A block that writes data to a Google Sheets spreadsheet at a specified A1 notation range.

  Docs

How it works

1. Connect Google Sheets

   Sign in or add your key once, under Settings, Integrations.

2. Ask for what you need

   Tell Otto or an AI Expert what to do, and they use Google Sheets as part of the work.

3. Make it routine

   Schedule it as a routine, or build it into a workflow in the agent builder.

Related integrations

• Todoist
• Google Docs
• Airtable
• Notion
• Google Calendar
• Atlassian

Browse all integrations →

Questions