Notification Jira Connector to Google Sheets Disabled

[Scott Tiller]

I have 4 to 5 Master Google sheets that I used to export data from Jira via filters every hour. I then have probably 20 to 30 different worksheets that use this data from my master spreadsheets. On occasion, I find that the connection from JIRA to google sheets gets disabled and it’s only when I stumble across the data being stale that I have to reconnect.

I have tried to find a function within google sheets that can record a date timestamp of the last import but to no avail. I’m curious if there’s any notification service that exist today that could notify the user if the connection fails