Data Integration With Google Sheets

[Alex Barnicoat]

Hey guys,

Being very new with scripts and trying to work my head around everything I was wondering if Google sheets could have cross integration with Adwords. I know you can have reports etc pulling into sheets from adwords however can you have data pull into adwords from Google sheets?

[Anthony Madrigal]

Hi Alex,

Yes, you can use AdWords Scripts to pull data from Google Sheets. You can use SpreadsheetApp to do so. 

Here is an example on how to pull values from a spreadsheet:

function getAllValuesOnSpreadsheet() {
  var SPREADSHEET_URL = 'INSERT_SPREADSHEET_URL_HERE';
  // Name of the specific sheet in the spreadsheet.
  var SHEET_NAME = 'INSERT_SHEET_NAME_HERE';

  var ss = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = ss.getSheetByName(SHEET_NAME);

  // This represents ALL the data.
  var range = sheet.getDataRange();
  var values = range.getValues();

  // This logs the spreadsheet in CSV format.
  for (var i = 0; i < values.length; i++) {
    Logger.log(values[i].join(','));
  }
}

Let me know if you have any other questions.

Cheers,

Anthony

AdWords Scripts Team

[Mitchell Alomar]

Hey Anthony

What is the google sheet template to ingrate data with AdWords?

ᐧ

--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to the Google Groups "AdWords Scripts Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scripts+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/79d5e916-91fe-434e-a034-8197ad7e8cb9%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Mitchell Alomar. | Digital Marketing Manager

beMarketing

www.bemarketing.com

Office: (484)-351-8820 ext 202

mal...@bemarketingsolutions.com

#37 fastest growing company in Philly in 2016 & 2017 by #Philly100

[Anthony Madrigal]

Hi Mitchell,

If you are referring to bulk uploads, you will just need to create a Google Spreadsheet with the columns and values for the ones listed here.

If you have additional questions, please create a new thread so that it is easier to keep track of.

Regards,

Anthony

AdWords Scripts Team

On Monday, June 25, 2018 at 3:17:36 PM UTC-4, Mitchell Alomar wrote:

Hey Anthony

What is the google sheet template to ingrate data with AdWords?

ᐧ

To unsubscribe from this group and stop receiving emails from it, send an email to adwords-scrip...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/79d5e916-91fe-434e-a034-8197ad7e8cb9%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.