Bulk Upload From Google Spreadsheet with AdWords Scripts Function not working

[Linkmedia 360]

Hi, 

I am trying to upload from Google Sheets using the bulk upload from Google Spreadsheet function but it's not working. The script will run fine but there are no entries in the logger and no bulk entries in the bulk section. It appears to not read the file correctly, but it's formatted correct way as if I were going to upload it through AdWords Editor. The particular campaign that I am trying to upload is a brand new campaign with keywords, ad groups, campaign settings, negative keywords, and campaign settings.

What do I need to change to make this work? 

Shared Spreadsheet: https://docs.google.com/spreadsheets/d/1cSsoJlhHsiJjEgwih7bL8C-GXnouWXyUBLiVj7CSOsM/edit#gid=0

function main(){

  function bulkUploadFromGoogleSpreadsheet() {

var spreadsheet_URL = 'https://docs.google.com/spreadsheets/d/1cSsoJlhHsiJjEgwih7bL8C-GXnouWXyUBLiVj7CSOsM/edit#gid=0';

var spreadSheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);

var sheet = spreadSheet.getActiveSheet();   

  }  

}

Thanks!

[Thea Vega (AdWords Scripts Team)]

Hi,

I noticed that the variable you are passing to spreadSheet (SPREADSHEET_URL) is different from the variable you stored in (spreadsheet_URL). Below is an updated version of your script.

function main() {
    bulkUploadFromGoogleSpreadsheet();
}

function bulkUploadFromGoogleSpreadsheet() {
  var SPREADSHEET_URL = 'INSERT_SPREADSHEET_URL_HERE';

  var spreadSheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = spreadSheet.getActiveSheet();

  var upload = AdWordsApp.bulkUploads().newFileUpload(sheet);
  upload.forCampaignManagement();


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

Also, here is a sample script for creating bulk uploads from spreadsheet. I also deleted your post since it contains personal information (spreadsheet link).

Thanks,

Thea

AdWords Scripts Team