Error on Bulk Shopping script

[Ben Perry]

I'm trying to use this script to create ad groups in bulk: https://developers.google.com/google-ads/scripts/docs/solutions/bulk-shopping-ad-group-creator

I copied and pasted the script in, changing only the 2 items necessary and I get an error "illegal character at line 41". Here is line 41:

var SHEET_NAME = ‘brs’;

This is one of the 2 things I changed, but I don't see anything wrong with it, what is the issue?

[Google Ads Scripts Forum Advisor Prod]

Hi Ben,

Thank you for posting your concern.

Upon testing the line that you provided, I was able to replicate the error. The reason why you are seeing the error is because of the double-byte characters (left single quotation mark ‘ and right single quotation mark ’) which are enclosing the sheet name. You may use single quotations (apostrophe) ' instead of the double-byte characters.

var SHEET_NAME = 'brs';

Please let me know how it goes after trying the suggestion above.

Regards,
Hiroyuki
Google Ads Scripts Team

ref:_00D1U1174p._5001UHE0cI:ref