openclaw

Connect OpenClaw to Google Sheets and Jira

With Google Sheets and Jira wired into OpenClaw, the agent can keep a spreadsheet and your issue tracker in sync without manual data entry. It reads rows from a sheet and files matching Jira issues, or pulls Jira issue data back into a sheet for reporting. Planning spreadsheets and the backlog stop drifting apart.

Loading preview…
Opens a workflow with 212 tools ready to use.

Tools OpenClaw gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google Sheets

19 tools
Read Sheet Data

Configuration for reading data from a Google Sheet

Write Sheet Data

Configuration for writing data to a Google Sheet

Append Rows to Sheet

Configuration for appending rows to a Google Sheet

Clear Sheet Range

Configuration for clearing values from a range

Create New Spreadsheet

Configuration for creating a new spreadsheet

Fetch Spreadsheet Metadata

Configuration for getting spreadsheet metadata

Read Multiple Sheet Ranges

Configuration for reading multiple ranges at once

Write to Multiple Sheet Ranges

Configuration for writing to multiple ranges at once

Add Spreadsheet Sheet

Configuration for adding a new sheet/tab

Delete Spreadsheet Sheet

Configuration for deleting a sheet/tab

Copy Sheet to Spreadsheet

Configuration for copying a sheet to another spreadsheet

Rename Spreadsheet Sheet

Configuration for renaming a sheet/tab

Duplicate Sheet in Spreadsheet

Configuration for duplicating a sheet within the same spreadsheet

Find and Replace in Spreadsheet

Configuration for find and replace in a spreadsheet

Insert Sheet Rows

Configuration for inserting rows

Delete Sheet Rows

Configuration for deleting rows

Clear Multiple Sheet Ranges

Configuration for clearing multiple ranges at once

Insert Sheet Columns

Configuration for inserting columns

Delete Sheet Columns

Configuration for deleting columns

Jira

193 tools
Get Issue

Get a specific issue by key or ID

Search Issues with Jql

Search for issues using JQL

Create Issue

Create a new issue

Update Issue

Update an existing issue

Transition Issue Status

Transition an issue to a new status

List Issue Transitions

List available transitions for an issue

Add Comment to Issue

Add a comment to an issue

Delete Issue

Delete an issue

List Projects

List accessible projects

Get Project

Get project details

Search Users

Search for users

Get Current User

Get current user details

Get Attachment Metadata

Get metadata for an attachment

Download Attachment

Download an attachment (returns content as base64)

Delete Attachment

Delete an attachment

Add Attachment to Issue

Add attachment to an issue

List Issue Attachments

Get all attachments for an issue

Get Attachment Human Readable

Get attachment with expanded human-readable data

Add Worklog to Issue

Add worklog to an issue (time tracking)

Get Worklog

Get a worklog by ID

Update Worklog

Update a worklog

Delete Worklog

Delete a worklog

List Issue Worklogs

Get all worklogs for an issue

List Deleted Worklog Ids

Get list of IDs for deleted worklogs

List Updated Worklog Ids

Get list of IDs for updated worklogs

List Worklog Property Keys

Get all worklog property keys for a worklog

Create Project Component

Create a project component

Get Component

Get a component by ID

Update Component

Update a component

Delete Component

Delete a component

List Project Components

Get all components for a project

Get Component Issue Count

Get issue count for a component

Create Project Version

Create a project version/release

Get Version

Get a version by ID

Update Version

Update a version

Delete Version

Delete a version

List Project Versions

Get all versions for a project

Merge Project Versions

Merge two versions

Move Version Position

Move version position

Get Version Issue Counts

Get issue counts for a version

Get Version Unresolved Count

Get count of unresolved issues for a version

Get Issue Link

Get an issue link by ID

Link Two Issues

Create a link between two issues

Delete Issue Link

Delete an issue link

List Issue Watchers

Get watchers for an issue

Add Watcher to Issue

Add watcher to an issue

Remove Watcher from Issue

Remove watcher from an issue

List Priorities

Get all priorities

Get Priority

Get a priority by ID

List Resolutions

Get all resolutions

Get Resolution

Get a resolution by ID

List Statuses

Get all statuses

Get Status

Get a status by ID

List Issue Types

Get all issue types

Get Issue Type

Get an issue type by ID

List Project Issue Types

Get issue types for a project

Create Jql Filter

Create a filter (saved JQL query)

Get Filter

Get a filter by ID

Update Filter

Update a filter

Delete Filter

Delete a filter

Search Filters

Search for filters

Get Issue Comment

Get a comment by ID

List Issue Comments

Get all comments for an issue

Update Issue Comment

Update a comment

Delete Issue Comment

Delete a comment

List Fields

Get all fields

Create Custom Field

Create a custom field

List Boards

Get all boards

Get Board

Get a board by ID

List Board Issues

Get issues for a board

Get Board Backlog

Get backlog issues for a board

List Board Sprints

Get sprints for a board

Get Sprint

Get a sprint by ID

Create Sprint

Create a sprint

Update Sprint

Update a sprint

Delete Sprint

Delete a sprint

List Sprint Issues

Get issues in a sprint

Move Issues to Sprint

Move issues to a sprint

Get Epic

Get an epic by ID or key

List Epic Issues

Get issues in an epic

Move Issues to Epic

Move issues to an epic

List Issue Remote Links

Get remote links for an issue

Create Remote Link on Issue

Create a remote link on an issue

Delete Remote Link

Delete a remote link

Get Issue Labels

Get all labels for an issue

Add Labels to Issue

Add labels to an issue

Replace Issue Labels

Set labels for an issue (replaces existing)

Get Issue Property

Get a property value for an issue

Set Issue Property

Set a property value for an issue

Delete Issue Property

Delete a property from an issue

List Issue Property Keys

Get all property keys for an issue

Get Current User Permissions

Get permissions for the current user

List All Permissions

Get all permissions in the system

Check User Permissions

Check if user has specific permissions

List Permission Schemes

Get all permission schemes

Get Permission Scheme

Get a permission scheme by ID

Create Permission Scheme

Create a new permission scheme

Delete Permission Scheme

Delete a permission scheme

List Groups

Get all groups

Get Group

Get a group by name

Create Group

Create a new group

Delete Group

Delete a group

Add User to Group

Add a user to a group

Remove User from Group

Remove a user from a group

List Group Members

Get members of a group

List Project Roles

Get all project roles for a project

Get Project Role

Get a specific project role

Add Actors to Project Role

Add actors (users/groups) to a project role

Remove Actors from Project Role

Remove actors from a project role

List Screens

Get all screens

Get Screen

Get a screen by ID

List Screen Tabs

Get all tabs for a screen

List Screen Tab Fields

Get all fields for a screen tab

List Issue Security Schemes

Get all issue security schemes

Get Issue Security Scheme

Get an issue security scheme by ID

List Notification Schemes

Get all notification schemes

Get Notification Scheme

Get a notification scheme by ID

List Workflows

Get all workflows

Get Workflow

Get a workflow by name

List Workflow Schemes

Get all workflow schemes

Get Workflow Scheme

Get a workflow scheme by ID

List Dashboards

Get all dashboards

Get Dashboard

Get a dashboard by ID

Create Dashboard

Create a new dashboard

Update Dashboard

Update a dashboard

Delete Dashboard

Delete a dashboard

Get Audit Log

Get audit log records

Search Projects

Search for projects

Get Application Property

Get an application property

Get Jira Server Info

Get Jira server information

List Issue Link Types

Get all issue link types

Get Issue Link Type

Get an issue link type by ID

Create Issue Link Type

Create a new issue link type

Update Issue Link Type

Update an issue link type

Delete Issue Link Type

Delete an issue link type

List Field Configurations

Get all field configurations

Get Field Configuration

Get a field configuration by ID

List Field Configuration Schemes

Get all field configuration schemes

Get Field Configuration Scheme

Get a field configuration scheme by ID

List Issue Type Schemes

Get all issue type schemes

Get Issue Type Scheme

Get an issue type scheme by ID

Create Issue Type Scheme

Create an issue type scheme

Update Issue Type Scheme

Update an issue type scheme

Delete Issue Type Scheme

Delete an issue type scheme

List Issue Type Screen Schemes

Get all issue type screen schemes

Get Issue Type Screen Scheme

Get an issue type screen scheme by ID

Get Priority Scheme

Get a priority scheme by ID

List Priority Schemes

Get all priority schemes

Archive Project

Archive a project

Restore Archived Project

Restore an archived project

Get Project Category

Get a project category by ID

List Project Categories

Get all project categories

Create Project Category

Create a project category

Update Project Category

Update a project category

Delete Project Category

Delete a project category

Assign Issue to User

Assign an issue to a user

Get Issue Changelog

Get changelog for an issue

Send Issue Notification

Send notification for an issue

Get Issue Votes

Get votes for an issue

Add Vote to Issue

Add vote to an issue

Remove Vote from Issue

Remove vote from an issue

Get User

Get a user by account ID

List User Groups

Get groups that a user belongs to

List User Properties

Get all properties for a user

Get User Property

Get a property for a user

Set User Property

Set a property for a user

Delete User Property

Delete a property from a user

Bulk Create Issues

Create multiple issues in bulk

Bulk Update Issues

Update multiple issues in bulk

Bulk Delete Issues

Delete multiple issues in bulk

List Project Avatars

Get all avatars for a project

List Issue Type Avatars

Get all avatars for an issue type

List Application Properties

Get all application properties

Set Application Property

Set an application property

Get Global Configuration

Get global configuration

Get Issue Security Level

Get issue security level by ID

Create Status

Create a new status

Update Status

Update a status

Delete Status

Delete a status

Create Resolution

Create a new resolution

Update Resolution

Update a resolution

Delete Resolution

Delete a resolution

Create Priority

Create a new priority

Update Priority

Update a priority

Delete Priority

Delete a priority

Create Issue Type

Create a new issue type

Update Issue Type

Update an issue type

Delete Issue Type

Delete an issue type

Validate Jql Query

Validate a JQL query

Get Jql Autocomplete Suggestions

Get auto-complete suggestions for JQL

Get Current User Preferences

Get current user preferences

Set Current User Preference

Set a user preference

Get Jira License Info

Get Jira license information

What you can build

Read each row in a planning sheet and create a Jira issue with the summary, assignee, and priority
Pull open Jira issues for a project and write them into a Google Sheet for a status report
Find rows marked done in the sheet and transition the linked Jira issues to Done
Append new Jira issue keys back into the sheet so the two stay matched

About OpenClaw

OpenClaw is an open command-line agent. NoClick runs it hosted and lets you connect your apps to it as tools, so it can take real actions across your systems. Wire an integration into the agent and OpenClaw can call that app’s operations directly. It is a good fit when you want an open, no-fuss agent with real tool access and nothing to install.

Open and approachable
Simple to point at a task
Solid general tool use
Hosted, with nothing to install

Frequently asked questions

Build a custom OpenClaw agent

Open your OpenClaw agent in one click

NoClick runs OpenClaw for you with Google Sheets and Jira wired in as tools. Connect your account and run.