'Can Google Sheets Track When The Last ImportRange Function was completed
Not sure if this is technically possible but will solicit any feedback.
Problem Statement: I currently have an integration with JIRA that will import data from JIRA into my google source sheet hourly. Once the JIRA data is in the source google sheet, I use that data for various reports which has been great. Unfortunately, and on occasion, I find that the connection between JIRA and Google Sheets disconnects but I have to stumble across the stale data to then manually reconnect so that it again imports the JIRA data hourly.
I have multiple individual sheets tied to the source sheet.
Solution I am attempting, although unsuccessfully, to use some function to determine when the last date/time data was imported into either the primary source sheet or any of the secondary sheets (I use the importrange function for my secondary sheets) since I have independent worksheets. I will write a job to send an alert email that the connection needs to be corrected so I can manually re-establish the connection but the key is knowing that the import has not happened hourly by the way of some date/time stamp.
I cannot figure out any onEdit (or other functionality) that can be used to insert a date/time stamp based on data being imported. It seems that I literally have to physically edit any cell for the onEdit to recognize the change which defeats the purpose.
Hopefully this describes the problem statement in detail but happy to try to provide more content.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
