title: GoogleSheets API:"Invalid JSON payload received. Unknown name "Number" at 'data.values[0]': Cannot find field
body: <p>I am trying to copy contents of a spreadsheet into another spreadsheet but the error keeps popping up. 
  Could you help to figure out why is it not copying over the data from one sheet to the other?
  This is the dummy data I am experimenting on in the original sheet:</p>
  
  <pre><code>1   CHANGED London 
  2   5   Budapest
  3   4   Prague
  4   11  Madrid
  4   11  Madrid
  </code></pre>
  
  <p>This is how the destination sheet looks like:</p>
  
  <pre><code>2   5   Budapest
  2   5   Budapest
  2   5   Budapest
  </code></pre>
  
  <p>This is part of the error I get:</p>
  
  <pre><code>Invalid JSON payload received. Unknown name "Weather" at 'data.values[0]': Cannot find field.
  Invalid JSON payload received. Unknown name "City" at 'data.values[0]': Cannot find field.
  Invalid JSON payload received. Unknown name "Number" at 'data.values[1]': Cannot find field.
  Invalid JSON payload received. Unknown name "Weather" at 'data.values[1]': Cannot find field.
  Invalid JSON payload received. Unknown name "City" at 'data.values[1]': Cannot find field.
  Invalid JSON payload received. Unknown name "Number" at 'data.values[2]': Cannot find field.
  </code></pre>
  
  <p>And this is the script:</p>
  
  <pre><code>from oauth2client.service_account import ServiceAccountCredentials
  from pprint import pprint
  from googleapiclient import discovery
  scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]
  creds = ServiceAccountCredentials.from_json_keyfile_name("creds.json", scope )
  client = gspread.authorize(creds)
  
  LT = client.open("LetsTry").sheet1
  LT_data = LT.get_all_records()
  NQ_all = client.open("NQ_all").sheet1
  NQ_all_data = NQ_all.get_all_records()
  
  service = discovery.build('sheets', 'v4', credentials=creds)
  spreadsheetId = 'xyz'
  range = 'Sheet1!A1:C11'
  body = {
      'values': LT_data
  }
  result = service.spreadsheets().values().append(
      spreadsheetId=spreadsheetId, 
      range = range,
      valueInputOption= 'RAW',
      body=body).execute()
  print('{0} cells updated.'.format(result.get('updatedCells')))
  </code></pre>