Hi Bart,
Thanks for posting your concern.
Please note that the
validateAndGetSpreadsheet function in this solution script should not be modified and this is the reason why you encountered the said error. With this, please return back the default implementation of this function. The spreadsheet URL should only be set in line
56.
Let me know if you have further questions.
Regards,
Ejay
Google Ads Scripts Team

ref:_00D1U1174p._5001UJajwA:ref