My question is similar to this one, for which no answer has yet been posted. How can I get Google Sheets to auto-update a reference to another sheet?
I am filling one Google Spreadsheet with Zapier which creates new rows of data. I then use ImportRange to take that some data from that sheet into another, where it is processed and generates text that I use to send out emails or SMS.
This 2nd sheet is read by Zapier in order to send the email or SMS.
The problem is that the 2nd sheet does not automatically update when I am not logged in an making changes. i.e. importrange() is not updating 'when I am not looking'.
I have both sheets set to refresh every minute and Zapier 'reads them' once every 5 mins (writing to the first sheet, only reading from the second").
I have tried any scripts, although I have tried using the Now() function and concatenate() functions in order to amend the data pulled in by importrange() - which did not fix the problem.
The second sheet is a bit complex and takes time to load.