Five more functions. read_range, append_row, search_sheets, read_doc, create_doc. Which response shape surprised you most?
Sheets using 'valueRanges' with a nested 'values' key — two levels of .get() for what should be a simple list of rows. But once I understood the nesting, it made sense that BATCH_GET returns an array of range objects.
That nesting is intentional — BATCH_GET can return multiple ranges in one call. The envelope structure accommodates that. What about the search response key?
search_sheets returns 'files' — not 'spreadsheets'. That tripped me until I remembered Sheets are Drive files under the hood. Printing the raw result once shows you the actual shape.
Print first, assume never. Six questions — two from Weeks 1 and 2.
Ready. Week 4 is the capstone — I want everything sharp.
Every function from Weeks 1 through 3 chains into the capstone workflow. None of them are done.
Create a free account to get started. Paid plans unlock all tracks.
Five more functions. read_range, append_row, search_sheets, read_doc, create_doc. Which response shape surprised you most?
Sheets using 'valueRanges' with a nested 'values' key — two levels of .get() for what should be a simple list of rows. But once I understood the nesting, it made sense that BATCH_GET returns an array of range objects.
That nesting is intentional — BATCH_GET can return multiple ranges in one call. The envelope structure accommodates that. What about the search response key?
search_sheets returns 'files' — not 'spreadsheets'. That tripped me until I remembered Sheets are Drive files under the hood. Printing the raw result once shows you the actual shape.
Print first, assume never. Six questions — two from Weeks 1 and 2.
Ready. Week 4 is the capstone — I want everything sharp.
Every function from Weeks 1 through 3 chains into the capstone workflow. None of them are done.