Google Sheets + Jira Software Cloud
Manage updated Jira Software Cloud issues by creating corresponding rows in Google Sheets
Stay organized and efficient with this workflow that streamlines the tracking of issue status changes in Jira Software Cloud. Once set up, every time an issue status changes in Jira, a new row is created in your Google Sheets spreadsheet. This seamless process ensures you're always on top of any changes, saving you time while keeping your data consistently updated.
Stay organized and efficient with this workflow that streamlines the tracking of issue status changes in Jira Software Cloud. Once set up, every time an issue status changes in Jira, a new row is created in your Google Sheets spreadsheet. This seamless process ensures you're always on top of any changes, saving you time while keeping your data consistently updated.
- When this happens...
Issue Status ChangedTriggers each time an issue changes status in a project.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
ProjectRequired
Status
Assignee
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planIssueRequired
AttachmentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IssueRequired
Form actionRequired
Submit formRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IssueRequired
User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Format Info
ProjectRequired
Issue TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IssueRequired
Project
BoardRequired
SprintRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Format Info
IssueRequired
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Attachment IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSummary
Key
Fields
ActionThis is an event a Zap performs.SearchFind existing data in your appJQLRequired
Fields
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter Name
Owner Name
ActionThis is an event a Zap performs.SearchFind existing data in your appBoardRequired
SprintRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSummary
Key
Fields
Format Info
ProjectRequired
Issue TypeRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
IssueRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First IssueRequired
Link TypeRequired
Second IssueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IssueRequired
Time SpentRequired
Work Description
Started Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IssueRequired
FormRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IssueRequired
FormRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProjectRequired
NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilterRequired
Max Results
Fields
ActionThis is an event a Zap performs.SearchFind existing data in your appKey
Fields
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch by ParameterRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appKeywordRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Jira Software Cloud
Related categories
Related Zap Templates
- Create Jira Software Cloud issues from new Google Sheets rows
- Create Google Sheets spreadsheets rows from new Jira Software Cloud issues
- Update Jira Software Cloud issues from new or updated Google Sheets rows
- Create Jira Software Cloud issues for new or updated Google Sheet rows
- Create Google Sheets spreadsheet rows from new Jira Software Cloud issues (via JQL)
- Create Jira Software Cloud issues with new Google Sheets rows (Team Drive)
- Post Glide submissions to Webhooks by Zapier
- Create rows in Google Sheets for updated issues in Jira Software Cloud
- Add new Jira Software Cloud issues to Google Sheets as multiple rows
- Create copies of Google Sheets worksheets for new Jira Software Cloud issues
- Add attachments to Jira Software Cloud issues from new Google Sheets team drive rows
- Track new Jira Software Cloud issues by updating spreadsheet rows in Google Sheets
- Update Google Sheets rows when new Jira Software Cloud issues arise
- Update Google Sheets rows when Jira Software Cloud issues are updated
- Update Google Sheets rows with updated Jira Software Cloud issues
- Update Google Sheets rows for updated Jira Software Cloud issues
- Update Jira Software Cloud issues from new or updated Google Sheets spreadsheet rows in team drive
- Create multiple Google Sheets rows for new Jira Software Cloud issues via jql
- Add comments to Jira Software Cloud issues from new or updated Google Sheets rows
- Create new issues in Jira Software Cloud from new spreadsheets in Google Sheets
- Create new issues in Jira Software Cloud from new worksheets in Google Sheets
- Update Google Sheets rows when issues are updated in Jira Software Cloud
- Create spreadsheets in Google Sheets from updated issues in Jira Software Cloud
- Create Google Sheets spreadsheets from new Jira Software Cloud issues via jql
- Create Google Sheets rows for new comments in Jira Software Cloud
- Create spreadsheets in Google Sheets for every new issue in Jira Software Cloud
- Create Google Sheets rows from updated comments in Jira Software Cloud
- Add comments to issues in Jira Software Cloud when new rows appear in Google Sheets
- Create spreadsheet columns in Google Sheets for new comments in Jira Software Cloud
- Create Google Sheets spreadsheets for updated Jira Software Cloud comments
- Create issues in Jira Software Cloud from new or updated rows in Google Sheets
- Manage new or updated Google Sheets rows by adding work logs to Jira Software Cloud issues
- Update Google Sheets rows at top when issues are updated in Jira Software Cloud
Related Zap Templates
- Create Jira Software Cloud issues from new Google Sheets rows
- Create Jira Software Cloud issues for new or updated Google Sheet rows
- Post Glide submissions to Webhooks by Zapier
- Create copies of Google Sheets worksheets for new Jira Software Cloud issues
- Update Google Sheets rows when new Jira Software Cloud issues arise
- Update Google Sheets rows for updated Jira Software Cloud issues
- Add comments to Jira Software Cloud issues from new or updated Google Sheets rows
- Update Google Sheets rows when issues are updated in Jira Software Cloud
- Create Google Sheets rows for new comments in Jira Software Cloud
- Add comments to issues in Jira Software Cloud when new rows appear in Google Sheets
- Create issues in Jira Software Cloud from new or updated rows in Google Sheets
- Create Google Sheets spreadsheets rows from new Jira Software Cloud issues
- Create Google Sheets spreadsheet rows from new Jira Software Cloud issues (via JQL)
- Create rows in Google Sheets for updated issues in Jira Software Cloud
- Add attachments to Jira Software Cloud issues from new Google Sheets team drive rows
- Update Google Sheets rows when Jira Software Cloud issues are updated
- Update Jira Software Cloud issues from new or updated Google Sheets spreadsheet rows in team drive
- Create new issues in Jira Software Cloud from new spreadsheets in Google Sheets
- Create spreadsheets in Google Sheets from updated issues in Jira Software Cloud
- Create spreadsheets in Google Sheets for every new issue in Jira Software Cloud
- Create spreadsheet columns in Google Sheets for new comments in Jira Software Cloud
- Manage new or updated Google Sheets rows by adding work logs to Jira Software Cloud issues
- Update Jira Software Cloud issues from new or updated Google Sheets rows
- Create Jira Software Cloud issues with new Google Sheets rows (Team Drive)
- Add new Jira Software Cloud issues to Google Sheets as multiple rows
- Track new Jira Software Cloud issues by updating spreadsheet rows in Google Sheets
- Update Google Sheets rows with updated Jira Software Cloud issues
- Create multiple Google Sheets rows for new Jira Software Cloud issues via jql
- Create new issues in Jira Software Cloud from new worksheets in Google Sheets
- Create Google Sheets spreadsheets from new Jira Software Cloud issues via jql
- Create Google Sheets rows from updated comments in Jira Software Cloud
- Create Google Sheets spreadsheets for updated Jira Software Cloud comments
- Update Google Sheets rows at top when issues are updated in Jira Software Cloud