Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

321
Views
getValues() Google Sheets App Script not working - Returns a single array

My Code: getValues() for some reason works and afterwards fails to work on other days. It seems "response" is only getting an array(8) of 1 column? I am grabbing a array of values but it only returns 1st column enter code here

    if (response == 1) { var response = 'B5:E12'}
  if (response == 2) { var response = 'B13:E20'}
  if (response == 3) { var response = 'B21:E28'}
  if (response == 4) { var response = 'B29:E34'}
  if (response == 5) { var response = 'B37:E45'}
  if (response == 6) { var response = 'B46:E53'}
  if (response == 7) { var response = 'B54:E61'}
  if (response == 8) { var response = 'B62:E69'}
  if (response == 9) { var response = 'B70:E77'}
  if (response == 10) { var response = 'B78:E85'}
  if (response == 11) { var response = 'B86:E93'}
  if (response == 12) { var response = 'B94:E101'}
    
  response = response.toString();

  // Gather Data to prep Table and Email (to: and cc:)

  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheetr = sheet.getSheetByName('Reporting');
  var sheeta = sheet.getSheetByName('Assignments');
  var data = sheetr.getRange(response).getValues();
about 4 years ago · Santiago Gelvez
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!