Importrange in Google Sheets and Automatic update trigger and email

[KAP]

I have a sheet that autoupdates from google analytics and another google sheet using filter(importrange ....) function.  When I set up an auto refresh trigger and email, the data from GA updates, but the data from the import range function is blank.  When I open the google sheet all of the data is there, just the email on the trigger does not get the import range data - it is as if the email goes out just before the information gets pulled into the sheet (my hypothesis).  If I manually email the file as a pdf it works fine, but on an automatic trigger is does not.  Has anyone else some across this issue?

Thanks.

[KAP]

Further investigation, I get #N/A errors on the importrange function on the automatic trigger to refresh and email out the report.  Not sure why I am getting these errors - sometimes I believe super metrics uses an anonymous user - could it be that anonymous does not have access to the file trying to be imported (when it is run by the trigger?)

[Clinton Deacon]

Can you try deleting the trigger and then setting it up as a new one. This should fix the issue.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/b448a87d-1db6-4487-a55c-57cf9d131d8c%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.