Google Sheets API — read a sheet — Python for Office Workers

← Courses›Python for Office WorkersModule 2 · Web APIs›Google Sheets API — read a sheetpredict7 / 50

Task

Given a sheet:

  | date       | revenue |
  | 2026-05-14 | 1200    |
  | 2026-05-15 | 1450    |

What does this print?

  records = sheet.get_all_records()
  print(records[0]["revenue"], records[1]["revenue"])

Type the two values separated by one space.

Keep going

📋predict

Google Sheets API — append a row

📋predict

requests — GET data from any URL

📋write

Parse JSON with the json module

🔮 Predict the output

Read the code carefully

What will the program print? Write here:

Keep going

💬 Discussion