Google Sheets + Jira Software Cloud
Create Google Sheets spreadsheet rows from new Jira Software Cloud issues (via JQL)
This integration creates Google Sheets spreadsheet rows from new Jira Software Cloud issues (via JQL).
This integration creates Google Sheets spreadsheet rows from new Jira Software Cloud issues (via JQL).
- When this happens...
New Issue (Via JQL)Triggers when a new issue is added that matches some JQL.
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
Info
Jira Cloud SiteRequired
Jira Email AddressRequired
Jira API TokenRequired
Projects to Trigger On
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.IssueRequired
CommentRequired
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.IssueRequired
Project
BoardRequired
SprintRequired
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.Summary
Key
ActionThis is an event a Zap performs.SearchFind existing data in your appJQLRequired
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 appSummary
Key
Format Info
ProjectRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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.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.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
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
ColumnsRequired
Row countRequired
First row
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
Info
Jira Cloud SiteRequired
Jira Email AddressRequired
Jira API TokenRequired
Projects to Trigger On
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.IssueRequired
AttachmentRequired
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.Format Info
ProjectRequired
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.ProjectRequired
NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appJQLRequired
Max Results
ActionThis is an event a Zap performs.SearchFind existing data in your appKey
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 appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo 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
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.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
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
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
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
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
- Create rows in Google Sheets for updated issues in Jira Software Cloud
- 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 Jira Software Cloud issues with new Google Sheets rows (Team Drive)
- Post Glide submissions to Webhooks by Zapier
- 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
Related Zap Templates
- Create Jira Software Cloud issues from new Google Sheets rows
- Update Jira Software Cloud issues from new or updated Google Sheets rows
- Post Glide submissions to Webhooks by Zapier
- 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
- Create Google Sheets spreadsheets rows from new Jira Software Cloud issues
- Create Jira Software Cloud issues for new or updated Google Sheet rows
- 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
- Create rows in Google Sheets for updated issues in Jira Software Cloud
- Create Jira Software Cloud issues with new Google Sheets rows (Team Drive)
- 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