Integration
Connect Google Sheets to JIRA
When something happens in Google Sheets, your agent does the next thing in JIRA. Describe it in plain language and the automation is built, tested on every branch and kept running.
Build it
What do you want Google Sheets and JIRA to do together?
Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.
Ask the assistant
You'll sign in before anything runs. What you typed comes with you.
Or work from Claude Code
Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.
Connect Claude CodeEverything your agent can do with Google Sheets and JIRA
Triggers and actions 18 triggers · 182 actions
Trigger
Aggregate Metric ChangedFires when an aggregate metric (sum/avg/count/…) over a column changes. Managed by Composio (~15 min floor).
- Cell Range Values Changed
Fires when the values in a specific cell range change. Managed by Composio (~15 min floor).
- Conditional Format Rule Changed
Fires when a conditional-format rule changes. Managed by Composio (~15 min floor).
- Data Validation Rule Changed
Fires when a data-validation rule changes. Managed by Composio (~15 min floor).
- Developer Metadata Changed
Fires when developer metadata changes. Managed by Composio (~15 min floor).
- Filtered Range Values Changed
Fires when the values in a filtered range change. Managed by Composio (~15 min floor).
- New Rows
Fires when new rows are appended to a Google Sheet. Managed by Composio (server-side poll; ~15 min floor).
- New Sheet Added
Fires when a new sheet (tab) is added to a spreadsheet. Managed by Composio (~15 min floor).
- New Spreadsheet Created
Fires when a new spreadsheet is created in the account. Managed by Composio (~15 min floor).
- Spreadsheet Metadata Changed
Fires when spreadsheet metadata changes. Managed by Composio (~15 min floor).
- Spreadsheet Properties Changed
Fires when spreadsheet properties change. Managed by Composio (~15 min floor).
- Spreadsheet Row Changed
Fires when a row matching a query changes. Managed by Composio (~15 min floor).
- Spreadsheet Search Match
Fires when a spreadsheet matching search criteria is found. Managed by Composio (~15 min floor).
- Table Query Result Changed
Fires when the result of a SQL-style table query changes. Managed by Composio (~15 min floor).
- Table Schema Changed
Fires when a table's column schema changes. Managed by Composio (~15 min floor).
- Worksheet Names Changed
Fires when worksheet (tab) names change. Managed by Composio (~15 min floor).
- Add Row
Append a row to a Google Sheet
- Aggregate Column Data
Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).
- Auto-Resize Rows or Columns
Auto-fit row heights or column widths over an index range via autoResizeDimensions.
- Change Sheet Properties
Update a worksheet's grid properties (row/column count) using an explicit field mask.
- Clear Basic Filter
Remove the basic filter from a sheet via clearBasicFilter.
- Clear Spreadsheet Row(s)
Clear the values in a range (formatting preserved).
- Copy Range
Copy a source cell range to a destination range within the spreadsheet.
- Copy Worksheet
Copy a worksheet into a destination spreadsheet.
- Create Chart
Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.
- Create Conditional Formatting Rule
Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.
- Create Multiple Spreadsheet Rows
Append many rows in one call.
- Create Spreadsheet
Create a new Google Sheets spreadsheet with the given title.
- Create Spreadsheet Column
Insert a blank column at a given index.
- Create Spreadsheet Row
Append a single row of values to a sheet range.
- Create Spreadsheet Row at Top
Insert a blank row just below the header (row 2), then write the given values into it in one operation.
- Create Worksheet
Add a new worksheet (tab) to an existing spreadsheet.
- Delete Chart
Delete an embedded chart via deleteEmbeddedObject.
- Delete Sheet
Delete a worksheet from a spreadsheet by sheetId (gid).
- Delete Spreadsheet Row(s)
Delete a contiguous block of rows by index.
- Find and Replace
Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).
- Find Spreadsheet
Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).
- Find Worksheet
Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.
- Format Cell Range
Apply background color and bold formatting to a cell range via repeatCell.
- Format Spreadsheet Row
Apply a background color across an entire row via repeatCell over a row range.
- Get Conditional Format Rules
List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).
- Get Data Range
Read all values in a range.
- Get Data Validation Rules
Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).
- Get Many Spreadsheet Rows (Advanced)
Read multiple ranges at once via batchGet.
- Get Row by ID
Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.
- Get Sheet Names
Return the titles of all sheets (tabs) in the spreadsheet.
- Get Spreadsheet by ID
Fetch spreadsheet metadata (title, sheets, gids, grid properties).
- List Charts
List all embedded charts (chartId + title) across every sheet in the spreadsheet.
- Lookup Spreadsheet Row
Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).
- Lookup Spreadsheet Rows (Advanced)
Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).
- Move Chart
Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.
- Rename Sheet
Rename a worksheet's title.
- Search Spreadsheets
Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.
- Set Basic Filter
Apply a basic filter to a range on a sheet via setBasicFilter.
- Set Data Validation
Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.
- Sort Range
Sort a cell range by one column in ascending or descending order.
- Update Chart
Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.
- Update Conditional Format Rules
Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.
- Update Data Validation Rule
Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).
- Update Spreadsheet Row
Overwrite the values at a specific range.
- Update Spreadsheet Row(s)
Update one or more disjoint ranges in a single batch.
- Upsert Row
Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).
Trigger
New IssuePolls for newly created issues in a project (ordered by creation date).
- New or Updated Issue
Polls for issues created or updated recently (ordered by updated date).
- Add attachment
add an attachment to an issue
- Add comment
add a comment to an issue
- Add Comment to Issue
Adds a comment to the specified issue.
- Add filter as favorite
Add filter as favorite
- Add gadget to dashboard
Add gadget to dashboard
- Add user to group
add a user to a group
- Add vote
add the current user's vote to an issue
- Add worklog
add a worklog to an issue
- Archive issues by ID or key
archive issues by ID/key
- Archive issue(s) by JQL
Archive issue(s) by JQL
- Assign Issue
Assigns an issue to a user by account ID.
- Bulk create issue
bulk create issues
- Bulk create statuses
Bulk create statuses
- Bulk delete issues
bulk delete issues
- Bulk delete Statuses
Bulk delete Statuses
- Bulk delete worklogs
bulk delete worklogs on an issue
- Bulk edit dashboards
Bulk edit dashboards
- Bulk edit issues
bulk edit issue fields
- Bulk fetch issues
bulk fetch issues by ID/key
- Bulk move issues
bulk move issues
- Bulk move worklogs
bulk move worklogs
- Bulk transition issue statuses
bulk transition issue statuses
- Bulk unwatch issues
bulk unwatch issues
- Bulk watch issues
bulk watch issues
- Change filter owner
Change filter owner
- Copy dashboard
Copy dashboard
- Create component
Create component
- Create custom field
Create custom field
- Create dashboard
Create dashboard
- Create filter
Create filter
- Create group
Create group
- Create Issue
Creates a new issue in the specified project.
- Create issue link
create a link between two issues
- Create issue link type
create an issue link type
- Create issue type
create an issue type
- Create project
create a project
- Create project category
create a project category
- Create related work
Create related work
- Create user
create a user
- Create version
Create version
- Delete and replace version
Delete and replace version
- Delete attachment
delete an attachment
- Delete comment
delete a comment
- Delete component
Delete component
- Delete custom field
Delete custom field
- Delete dashboard
Delete dashboard
- Delete filter
Delete filter
- Delete Issue
Deletes an issue by its key or ID.
- Delete issue link
delete an issue link
- Delete issue link type
delete an issue link type
- Delete issue type
delete an issue type
- Delete project
delete a project
- Delete project asynchronously
delete a project asynchronously
- Delete project category
delete a project category
- Delete related work
Delete related work
- Delete user
delete a user
- Delete version
Delete version
- Delete vote
remove the current user's vote from an issue
- Delete watcher
remove a watcher from an issue
- Delete worklog
delete a worklog
- Export Archived Issues
Export archived issue(s)
- Get all dashboards
Get all dashboards
- Get all projects
Get all projects
- Get attachment content
get attachment content
- Get attachment metadata
get attachment metadata
- Get available transitions
Get available transitions
- Get bulk available transitions
get transitions available for bulk transition
- Get comment
get a single comment
- Get comments by IDs
get comments by IDs
- Get component
Get component
- Get create issue metadata
Get create issue metadata
- Get create metadata issue types for a project
get create-metadata issue types for a project
- Get dashboard
Get dashboard
- Get edit issue metadata
get edit metadata for an issue
- Get favorite filters
Get favorite filters
- Get filter
Get filter
- Get group
Get group
- Get Issue
Returns the details of a single issue by its key or ID.
- Get Issue Comments
Returns all comments for the specified issue.
- Get issue link
get an issue link
- Get issue link type
get an issue link type
- Get issue link types
list issue link types
- Get Issue Transitions
Returns the workflow transitions available for the specified issue.
- Get issue type
get an issue type
- Get issue watchers
get watchers of an issue
- Get issue worklogs
get worklogs on an issue
- Get is watching issue bulk
check watching status for multiple issues
- Get my filters
Get my filters
- Get Project
Returns the details of a single project by its key or ID.
- Get project components
get all components of a project
- Get project versions
get all versions of a project
- Get recent projects
get recently viewed projects
- Get related work
Get related work
- Get status
Get status
- Get status category
Get status category
- Get transitions
get available transitions for an issue
- Get user
get a user
- Get user groups
get groups a user belongs to
- Get users from group
list members of a group
- Get version
Get version
- Get votes
get votes on an issue
- Get worklog
get a worklog
- Get worklogs by IDs
get worklogs by IDs
- Get worklogs by issue ID and worklog ID
get worklogs by issue ID and worklog ID (internal)
- List Project Issue Types
Returns the issue types available, optionally for a given project.
- List Projects
Returns a paginated list of projects visible to the user.
- List users
Lists the users visible to the connected Jira account. Takes no search criterion.
- Merge versions
merge one version into another
- Move version
Move version
- Remove filter as favorite
Remove filter as favorite
- Remove gadget from dashboard
Remove gadget from dashboard
- Remove group
Remove group
- Remove user from group
remove a user from a group
- Restore custom field from trash
Restore custom field from trash
- Restore deleted or archived project
restore a deleted or archived project
- Search for dashboards
Search for dashboards
- Search for filters
Search for filters
- Search for issues using JQL enhanced search (GET)
Search for issues using JQL enhanced search (GET)
- Search for issues using JQL enhanced search (POST)
search for issues using enhanced JQL (POST)
- Search Issues (JQL)
Searches for issues using a JQL query.
- Transition Issue
Moves an issue to a new status by performing a workflow transition.
- Unarchive issues by keys or ID
unarchive issues by key/ID
- Update comment
update a comment
- Update component
Update component
- Update custom field
Update custom field
- Update dashboard
Update dashboard
- Update filter
Update filter
- Update gadget on dashboard
Update gadget on dashboard
- Update Issue
edit an issue
- Update issue link type
update an issue link type
- Update issue type
update an issue type
- Update project
update a project
- Update project category
update a project category
- Update related work
Update one related-work link on a Jira project version. Reads the version's existing related work, overlays only the fields you supply, then writes the merged object back — so anything you leave blank keeps its current value.
- Update version
Update version
- Update worklog
update a worklog
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews