Google Ads script errors

[Vicente Salvador Torres Canet]

Hi just wondering if you could help me to fix this errors

TypeError: Cannot read properties of null (reading 'getMaxRows') at pushToSpreadsheet (Code:54:23) at main (Code:25:3) at Object.<anonymous> (adsapp_compiled:19931:54)

[Google Ads Scripts Forum]

Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/i2wBu6iAbXE) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads Scripts Team

[Google Ads Scripts Forum]

Hi,

Thank you for reaching out to the Google Ads Scripts Forum Channel. Please excuse us for only getting back now as your message failed to be routed to our support queue.

Please note that this error would occur if the sheet name you are calling using the method getSheetByName() does not match what's set within your spreadsheet. Kindly refer to the line of code which calls the sheet and make sure it matches the name that's set in your spreadsheet. The name of the sheet can be found at the bottom left. When creating a spreadsheet, the name defaults to `Sheet1`.

 

Let us know if you have any questions. If the issue would persist, please provide your Google Ads account ID or CID and the name of the script as well as a complete screenshot showing the name of your spreadsheet so we can further investigate your concern.

 

Reference links:

• getSheetByName() - https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet#getsheetbynamename

Best regards,
Google Ads Scripts Team