How I can get a CVS from an URL and import as ad?

[desenvo...@ciapixel.com.br]

I need to create a script to import data from a CVS and then create ads with this records, but I have no idea how make this?

I saw some scripts in the documentation, but I need orientation from make this. Somebody can help me?

[Anthony Madrigal]

Hello,

You can use the bulk upload feature to use a CSV file to create ads via AdWords Scripts. You can find different methods on how to use this function here.

Here are the supported fields you will need to upload ads via bulk upload. 

Cheers,

Anthony

AdWords Scripts Team

[desenvo...@ciapixel.com.br]

I created this script to try get the data:

function main() {

  

   function bulkUploadFromRemoteServer() {

  // See https://developers.google.com/adwords/scripts/docs/features/bulk-upload

  // for the list of supported bulk upload templates.

    var dataUrl = 'My URL';

    var blob = UrlFetchApp.fetch(dataUrl)

        .getBlob()

        .getAs(MimeType.CSV);

    var upload = AdWordsApp.bulkUploads().newFileUpload(blob);

    upload.forCampaignManagement();

    // Use upload.apply() to make changes without previewing.

    upload.preview();

  }

  bulkUploadFromRemoteServer();

  

  

}

But I get this error, when I execute my script:

Converting from application/octet-stream to text/csv is not supported. (line 8)

I attached my example file to you see, Where I do make mistake?

[Anthony Madrigal]

Hi, 

Can you please reply privately to author your CID and script name so I can investigate further?

Thanks,

Anthony

AdWords Scripts Team