Google Sheets + Jira Software Cloud
Manage new or updated Google Sheets rows by adding work logs to Jira Software Cloud issues
Stay efficient and organized with this workflow between Google Sheets and Jira Software Cloud. When you enter a new or update an existing row in Google Sheets, this automation logs the data as a work log in a Jira Software Cloud issue. Manage and track your team's effort astutely, ensuring all changes are instantly mirrored in your project management tool.
Stay efficient and organized with this workflow between Google Sheets and Jira Software Cloud. When you enter a new or update an existing row in Google Sheets, this automation logs the data as a work log in a Jira Software Cloud issue. Manage and track your team's effort astutely, ensuring all changes are instantly mirrored in your project management tool.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Add Work Log to IssueLogs time worked on an issue for time tracking workflows.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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
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.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 foundIssueRequired
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.Format Info
ProjectRequired
Issue TypeRequired
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 found
No 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.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 foundIssueRequired
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.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
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.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 app
About Google Sheets
Related categories
About Jira Software Cloud
Related categories
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
- Create Google Sheets spreadsheets rows from new Jira Software Cloud issues
- 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
- 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
- Update Jira Software Cloud issues from new or updated Google Sheets rows
- 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
- Update Google Sheets rows at top when issues are updated in Jira Software Cloud
- Create Google Sheets spreadsheets rows from new Jira Software Cloud issues
- 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