/
Add each issue to Google sheet as row
Add each issue to Google sheet as row
- Peter Atthem
Owned by Peter Atthem
Create a new Action add a name to it and select application/json as template.
Select POST as method
Enter URL https://sheets.googleapis.com/v4/spreadsheets/<<YOUR_SPREADSHEET_ID>>/values/A1:append?valueInputOption=RAW
Select the Google authentication created before in Google Authentication Setup use the https://www.googleapis.com/auth/spreadsheets scope
In the body section add
{
"values": [
[
"{{#issue.dueDate}}{{#format}} yyyy-MM-dd {{/format}}{{/issue.dueDate}}",
"{{issue.customfield_122658}}",
"{{issue.customfield_124659}}",
"{{issue.customfield_124660}}",
"{{issue.customfield_123438}}",
"{{issue.customfield_145731}}"
]
]
}Each element in the value array correspond to a column in the sheet.
, multiple selections available,
Related content
Google how-to guides
Google how-to guides
Read with this
Create an issue from response from external system
Create an issue from response from external system
More like this
Issue variables
Issue variables
More like this
Google Calander how-to
Google Calander how-to
More like this
Issue Object Variables
Issue Object Variables
More like this
Create an Object on transition
Create an Object on transition
More like this