Is there a simple way to implement the Javascript string() function in the basic Google AdWords interface?

I want to pass some variables returned from a campaign management script to a spreadsheet (for comparing future values against historical values), but setValue() only works for strings.

The string() function does not appear to be available in the Adwords scripting interface.

I want to run something like this:-


Can anyone help?

2 Answers 2


Coercion in js is amazing and in this case you could simply use like this

sheet.getRange("B2").setValue(A + "")

Simply plus the empty string to your value.

And for something in the similar but reverse way you can use


Just using as a prefix an unary + operator, this will coerce the string to a number.

Find more about js coercion with a super sensei called Kyle Simpson


It turns out that all I had was a capitalisation error.

It appears to be fine to send function values to the spreadsheet.

In this case the values are numeric, but it appears that the Google Spreadsheet API handles the flattening of int values to strings, so my code now just reads:-


And I am a wally.

  • The road less travelled around here.... Commented Nov 19, 2012 at 20:19
  • happens to best of us :-)) Commented Nov 21, 2012 at 5:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.