Hi Keita, Your query has reached Google Ads API support. This support channel can only support direct raw API communications. From your 2nd screenshot it appears that the query gets the raw data correctly. You may reach out to your spreadsheet populating code support and Google Ads Scripts Forum for assistance.
With that being said, my hunch is that the spreadsheet code doesn't allow for a returned list of assets in its population of the spreadsheet and that only a string populates the cell. ad_group_ad.ad.responsive_search_ad.descriptions is a list of assets, not a string and so is ad_group_ad.ad.responsive_search_ad.headlines. You can see what is returned in your 2nd screenshot. Regards, Aryeh Google Ads API Team ref:_00D1U1174p._5004Q2a2kH6:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/Hdgs_000000000000000000000000000000000000000000000RAA65I00msvWVXRERcOgj7GWOowBNA%40sfdc.net.