Script for RSAs

[Henry Breakwell]

Was looking at this script for looking at RSA ad performance. Seems to be returning a few errors. 

Getting this error within the log. 

"Argument cannot be null: sheet (file Code.gs, line 29)".

var config = {

LOG : true, // Make a copy of this script and copy the URL: https://docs.google.com/spreadsheets/d/1WvNSbaZi2dz3Uu74AIniKy5YLHctZ_6c6i0Gp2DQ8ns/copy SPREADSHEET_URL : "https://", SHEET_NAME : "RSA" } //////////////////////////////////////////////////////////////////// function main() { if(config.SPREADSHEET_URL == "https://"){ throw Error("Make a copy of the sheet and paste the URL in the config \nhttps://docs.google.com/spreadsheets/d/1WvNSbaZi2dz3Uu74AIniKy5YLHctZ_6c6i0Gp2DQ8ns/copy"); } var ss = SpreadsheetApp.openByUrl(config.SPREADSHEET_URL); var sheet = ss.getSheetByName(config.SHEET_NAME); var report = AdsApp.report( "SELECT CampaignName, AdGroupName, Id, AdStrengthInfo " + "FROM AD_PERFORMANCE_REPORT " + "WHERE AdType = RESPONSIVE_SEARCH_AD " + "AND CampaignStatus = ENABLED " + "AND AdGroupStatus = ENABLED " + "AND Status = ENABLED" ) // Export data and clean up sheet sheet.clearContents(); report.exportToSheet(sheet); sheet.autoResizeColumns(1, sheet.getLastColumn()); if(sheet.getMaxColumns() - sheet.getLastColumn() != 0){ sheet.deleteColumns(sheet.getLastColumn() + 1, sheet.getMaxColumns() - sheet.getLastColumn()); } if(config.LOG === true){ var rows = report.rows(); while(rows.hasNext()){ var row = rows.next(); Logger.log("Campaign: " + row["CampaignName"] + " - Adgroup: " + row["AdGroupName"] + " - " + row["AdStrengthInfo"]); } // rowIterator } Logger.log("Export completed"); } // function main()

[Henry Breakwell]

Any ideas? Not sure if its just outdated?

[Henry Breakwell]

Obviously script would have correct url for sheet to pull data into. just having issues with other parts of script

[Google Ads Scripts Forum Advisor]

Hi Henry,

Thanks for reaching out. Harry here, from the Google Ads Scripts Team.

Kindly provide your Google Ads account ID, script's name and a shareable link to your spreadsheet if available so I can take a look closer at the issue you are encountering. You may send the spreadsheet privately via the reply to author option.

Looking forward to your reply.

Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q2RA9V0:ref

[Henry Breakwell]

Hi Harry,

Sure, Account ID: 799-851-0368,  script name "RSA Ad Performance Script", can't reply to author only, its greyed out for me.

Let me know how to correct that,

Thanks

[Henry Breakwell]

Do you have an email I can share it with ?

[Google Ads Scripts Forum Advisor]

Hi Henry,

Thanks for coming back. You can send private information through our email instead ( googleadsscr...@google.com). However, can you kindly check that the tab name in your sheet is the same as the one you have in your script (RSA Numan Performance)?

[Google Ads Scripts Forum Advisor]

Hi Henry,

We've received your message privately. Unfortunately, we still wasn't able to access the spreadsheet. With this, could you kindly send us a local copy instead to googleadsscr...@google.com?

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

ref:_00D1U1174p._5004Q2RA9V0:ref

[Henry Breakwell]

Sure, 

Doing it now

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/s5E_DybqzI4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/tlsmJ000000000000000000000000000000000000000000000R363OC00VtbVEEA5RnC0ELTaIDlypA%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hi Henry,

Thanks for coming back. I regret to say that we are still unable to access the spreadsheet through the link you have provided. Would you mind double checking if sharing is enabled or 'Anyone with the link' is selected? On the other hand, would you mind that you also attach a local file copy of the sheet instead as requested by my colleague? You can get the local file copy of the sheet by downloading it (File > Download > Microsoft Excel .xlsx). We should be able to fully troubleshoot your script thereafter and guide you accordingly.

Looking forward to your reply.

Thanks,

Harry Cliford Rivera Google Ads Scripts Team

ref:_00D1U1174p._5004Q2RA9V0:ref

[Henry Breakwell]

Hi ,

Sorry I think I didn't share it correctly last time. Should be correct now and fine to access.

--

-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/s5E_DybqzI4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/vBEcb000000000000000000000000000000000000000000000R3BBUM00mKsC2IWKQj23pCwnu5PRNQ%40sfdc.net.

[Google Ads Scripts Forum Advisor]

Hi Henry,

Thank you for getting back to us.

I was able to check your script, and found what causes the error. It appears that the error is coming from var sheet = ss.getSheetByName(config.SHEET_NAME); which returns a null result. As per further checking, you've configured your script's config.SHEET_NAME to "RSA Ad Performance" while your Spreadsheet template sheet's name is just "RSA" which causes an issue. The error should be fixed if you configured the same name on both. With this, kindly rename your spreadsheet sheet name to "RSA Ad Performance" or update your scripts' config.SHEET_NAME to "RSA". 

Regards,

Teejay Wennie Pimentel Google Ads Scripts Team

ref:_00D1U1174p._5004Q2RA9V0:ref