Re: Appscript to run mobile-pagespeed failing

[Alexander Wang]

+Garan who developed the solution.

+Anash who helps review all of our solutions.

Are either of you guys able to see what's wrong?

On Tue, Feb 9, 2016 at 3:34 AM, Abhinav Bhatnagar <abhi...@google.com> wrote:

Hi, 

I am trying to run this script, using AppScript;  

So, the idea is to run the mobile-pagespeed script in bulk for 100s of accounts, input for the script is list of CID's and output is the sheet url (with mspeed analysis) against each cid.

It works fine for some CID's, but randomly breaks with this error for some other CID's:

Catched something:
  property: message
    value: [The coordinates or dimensions of the range are invalid.]
  property: name
    value: [Exception]
  property: fileName
    value: [Code]
  property: lineNumber
    value: [194]
  property: stack
    value: [        at Code:194 (createPageSpeedSpreadsheet)
        at Code:125 (subMain)
        at Code:86 (main)
]
  toString():  value: [Exception: The coordinates or dimensions of the range are invalid.]

Input sheet with output urls and the error message is here.

Sometimes it runs successfully for the same CID, for which it had errored out in past.

Not sure, whats the issue with this. Please help!

Best,

Abhinav