Ad performance script

[Adriána Miklošová]

Hello, 

I would like to ask you for help with this script. https://developers.google.com/google-ads/scripts/docs/solutions/ad-performance
I made a copy of spredsheat and put URL to the script. The script couldn't finish the task because

21/06/2024 15:52:32
Using template spreadsheet - https://docs.google.com/spreadsheets/d/1LJN2LTUlTgGCio8sWXWW1Da7RxXRCLeYf7uYbeSt3Cs/edit?gid=0#gid=0.
21/06/2024 15:52:35
Generated new reporting spreadsheet https://docs.google.com/spreadsheets/d/1fMCQrTWU0XQI0dObs9nUXEEe7Hf_szTYMuULZCyLXF8/edit based on the template spreadsheet. The reporting data will be populated here.
21/06/2024 15:52:35
TypeError: Cannot read properties of null (reading 'getRange') at main (Code:106:17) at Object.<anonymous> (adsapp_compiled:20505:54)
Even if I had replaced the URL of spreadsheat it would have had problem. 

I really appreciate any help you can provide.

Best

Adriana

[Adriána Miklošová]

Hello, 

I would like to run this script https://developers.google.com/google-ads/scripts/docs/solutions/ad-performance for ad performance. I had created copy the templated spredsheat and inserted URL to the script. 

I run the script but there is a problem with my spredsheat again and again. Even if I had changed the spreadsheat, it would have had problem. 

21/06/2024 15:52:32
Using template spreadsheet - https://docs.google.com/spreadsheets/d/1LJN2LTUlTgGCio8sWXWW1Da7RxXRCLeYf7uYbeSt3Cs/edit?gid=0#gid=0.
21/06/2024 15:52:35
Generated new reporting spreadsheet https://docs.google.com/spreadsheets/d/1fMCQrTWU0XQI0dObs9nUXEEe7Hf_szTYMuULZCyLXF8/edit based on the template spreadsheet. The reporting data will be populated here.
21/06/2024 15:52:35
TypeError: Cannot read properties of null (reading 'getRange') at main (Code:106:17) at Object.<anonymous> (adsapp_compiled:20505:54)

Could you help me? 

Thanks in advance

Besta

Adriana