Connect OpenClaw to Google Sheets and Jira

Configuration for reading data from a Google Sheet

Configuration for writing data to a Google Sheet

Configuration for appending rows to a Google Sheet

Configuration for clearing values from a range

Configuration for creating a new spreadsheet

Configuration for getting spreadsheet metadata

Configuration for reading multiple ranges at once

Configuration for writing to multiple ranges at once

Configuration for adding a new sheet/tab

Configuration for deleting a sheet/tab

Configuration for copying a sheet to another spreadsheet

Configuration for renaming a sheet/tab

Configuration for duplicating a sheet within the same spreadsheet

Configuration for find and replace in a spreadsheet

Configuration for inserting rows

Configuration for deleting rows

Configuration for clearing multiple ranges at once

Configuration for inserting columns

Configuration for deleting columns

Configuration for formatting a range of cells

Configuration for sheet-level display properties

Configuration for auto-sizing columns or rows to fit their contents

Configuration for setting an explicit column width or row height

Configuration for merging cells

Configuration for unmerging cells

Configuration for drawing borders on a range

Configuration for alternating row colours

Configuration for adding a filter to a range

Configuration for removing a filter

Configuration for a conditional formatting rule

Configuration for sorting a range

Configuration for adding a dropdown or input rule to a range

Configuration for removing dropdowns / input rules from a range

Configuration for removing conditional formatting rules

Configuration for removing alternating row colours

Configuration for turning a range into a Sheets table

Configuration for removing a table

Configuration for editing or reordering a conditional formatting rule

Configuration for recolouring existing banding in place

Configuration for changing a table's name, range or column types

Configuration for spreadsheet-level properties

Configuration for naming a range

Configuration for changing a named range

Configuration for removing a named range

Configuration for protecting a range from edits

Configuration for changing a protected range

Configuration for removing range protection

Configuration for putting a hover note on cells

Configuration for inserting people or link smart chips

Configuration for anchoring a pivot table

Configuration for copying a range onto another

Configuration for moving a range

Configuration for pasting delimited text

Configuration for extending a series

Configuration for splitting a column of text

Configuration for trimming whitespace

Configuration for removing duplicate rows

Configuration for shuffling rows

Configuration for inserting cells and shifting the rest

Configuration for deleting cells and shifting the rest

Configuration for moving rows or columns

Configuration for appending blank rows or columns

Configuration for adding a chart

Configuration for changing an existing chart

Configuration for moving or resizing a chart

Configuration for a chart's border colour

Configuration for removing a chart

Configuration for appending rows of cells after the last row of data

Configuration for creating a saved filter view

Configuration for changing a filter view

Configuration for copying a filter view

Configuration for removing a filter view

Configuration for grouping rows or columns

Configuration for collapsing or expanding a group

Configuration for ungrouping rows or columns

Configuration for adding a slicer control

Configuration for changing a slicer

Configuration for tagging a sheet, row or column with durable metadata

Configuration for changing developer metadata

Configuration for removing developer metadata

Configuration for connecting a BigQuery data source

Configuration for repointing a data source

Configuration for disconnecting a data source

Configuration for refreshing connected data

Configuration for cancelling a running refresh

Get a specific issue by key or ID

Search for issues using JQL

Create a new issue

Update an existing issue

Transition an issue to a new status

List available transitions for an issue

Add a comment to an issue

Delete an issue

List accessible projects

Get project details

Search for users

Get current user details

Get metadata for an attachment

Download an attachment (returns a stored file reference)

Delete an attachment

Add attachment to an issue

Get all attachments for an issue

Get attachment with expanded human-readable data

Add worklog to an issue (time tracking)

Get a worklog by ID

Update a worklog

Delete a worklog

Get all worklogs for an issue

Get list of IDs for deleted worklogs

Get list of IDs for updated worklogs

Get all worklog property keys for a worklog

Create a project component

Get a component by ID

Update a component

Delete a component

Get all components for a project

Get issue count for a component

Create a project version/release

Get a version by ID

Update a version

Delete a version

Get all versions for a project

Merge two versions

Move version position

Get issue counts for a version

Get count of unresolved issues for a version

Get an issue link by ID

Create a link between two issues

Delete an issue link

Get watchers for an issue

Add watcher to an issue

Remove watcher from an issue

Get all priorities

Get a priority by ID

Get all resolutions

Get a resolution by ID

Get all statuses

Get a status by ID

Get all issue types

Get an issue type by ID

Get issue types for a project

Create a filter (saved JQL query)

Get a filter by ID

Update a filter

Delete a filter

Search for filters

Get a comment by ID

Get all comments for an issue

Update a comment

Delete a comment

Get all fields

Create a custom field

Get all boards

Get a board by ID

Get issues for a board

Get backlog issues for a board

Get sprints for a board

Get a sprint by ID

Create a sprint

Update a sprint

Delete a sprint

Get issues in a sprint

Move issues to a sprint

Get an epic by ID or key

Get issues in an epic

Move issues to an epic

Get remote links for an issue

Create a remote link on an issue

Delete a remote link

Get all labels for an issue

Add labels to an issue

Set labels for an issue (replaces existing)

Get a property value for an issue

Set a property value for an issue

Delete a property from an issue

Get all property keys for an issue

Get permissions for the current user

Get all permissions in the system

Check if user has specific permissions

Get all permission schemes

Get a permission scheme by ID

Create a new permission scheme

Delete a permission scheme

Get all groups

Get a group by name

Create a new group

Delete a group

Add a user to a group

Remove a user from a group

Get members of a group

Get all project roles for a project

Get a specific project role

Add actors (users/groups) to a project role

Remove actors from a project role

Get all screens

Get a screen by ID

Get all tabs for a screen

Get all fields for a screen tab

Get all issue security schemes

Get an issue security scheme by ID

Get all notification schemes

Get a notification scheme by ID

Get all workflows

Get a workflow by name

Get all workflow schemes

Get a workflow scheme by ID

Get all dashboards

Get a dashboard by ID

Create a new dashboard

Update a dashboard

Delete a dashboard

Get audit log records

Search for projects

Get an application property

Get Jira server information

Get all issue link types

Get an issue link type by ID

Create a new issue link type

Update an issue link type

Delete an issue link type

Get all field configurations

Get a field configuration by ID

Get all field configuration schemes

Get a field configuration scheme by ID

Get all issue type schemes

Get an issue type scheme by ID

Create an issue type scheme

Update an issue type scheme

Delete an issue type scheme

Get all issue type screen schemes

Get an issue type screen scheme by ID

Get a priority scheme by ID

Get all priority schemes

Archive a project

Restore an archived project

Get a project category by ID

Get all project categories

Create a project category

Update a project category

Delete a project category

Assign an issue to a user

Get changelog for an issue

Send notification for an issue

Get votes for an issue

Add vote to an issue

Remove vote from an issue

Get a user by account ID

Get groups that a user belongs to

Get all properties for a user

Get a property for a user

Set a property for a user

Delete a property from a user

Create multiple issues in bulk

Update multiple issues in bulk

Delete multiple issues in bulk

Get all avatars for a project

Get all avatars for an issue type

Get all application properties

Set an application property

Get global configuration

Get issue security level by ID

Create a new status

Update a status

Delete a status

Create a new resolution

Update a resolution

Delete a resolution

Create a new priority

Update a priority

Delete a priority

Create a new issue type

Update an issue type

Delete an issue type

Validate a JQL query

Get auto-complete suggestions for JQL

Get current user preferences

Set a user preference

Get Jira license information