Add each issue to Google sheet as row
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.