Exception: Argumento inválido: sheet

[Gilson Longo]

Eu tenho esse erro frequente, em algumas rotinas desenvolvidas em: https://script.google.com/.

Resumo das falhas do script do Google Apps: rot_temp_8.

gatilhos.

Estou recebendo um erro na linha a seguir, msg: 

Exceção: Argumento inválido: planilha

roteiro:

função record_cotacao_diario_BRAP4 () {

var sheet = SpreadsheetApp.getActiveSpreadsheet ();

var spreadsheet1 = planilha.getSheetByName ('BRAP4');

var plan = spreadsheet2.getActiveSheet ();

// cópia: diariamente :.

var origem = planilha1.getRange ("B2: G2");

...

}

Eu apreciaria qualquer direção que você possa fornecer. 

grato...

Hello people,

I have this frequent error, in some routines developed at: https://script.google.com/.

Summary of Google Apps script failures: rot_temp_8.

triggers.

I'm getting an error on the following line, msg:

Exception: Invalid argument: spreadsheet

script:

record_cotacao_diario_BRAP4 () function {

var sheet = SpreadsheetApp.getActiveSpreadsheet ();

var spreadsheet1 = spreadsheet.getSheetByName ('BRAP4');

var plan = spreadsheet2.getActiveSheet ();

// copy: daily:.

source var = spreadsheet1.getRange ("B2: G2");

...

}

I would appreciate any direction you can provide.

thankful.

[Google Ads Scripts Forum Advisor]

Hello,

This inquiry is more in line with Apps Scripts support. You can find the spreadsheet service documentation here. There is also an Apps Scripts support forum, which you can find here.

Regards,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5004Q1zss6A:ref