Two weeks in, you have five Gmail functions and five Calendar + Tasks functions. This week: Google Sheets and Docs. What do you think a spreadsheet looks like to the API?
Probably a list of rows, each row a list of cells. And a document is probably a title plus a body of text?
Exactly. A Sheets response comes back with {"spreadsheets": [...]} when you search, and {"values": [[row1], [row2]]} when you read a range. Docs are simpler still — a title plus a document id. Same skeleton, new response keys, new edge cases.
So by Friday I can append a row to a spreadsheet from Python? Which means I can build logs and trackers that update themselves?
Append a row, read any range, create a fresh doc, read its title back. Five new verbs across two APIs — and Week 4 chains them with Gmail and Calendar into full pipelines.
Goal: Turn spreadsheets and docs into programmable data stores.
Create a free account to get started. Paid plans unlock all tracks.
Two weeks in, you have five Gmail functions and five Calendar + Tasks functions. This week: Google Sheets and Docs. What do you think a spreadsheet looks like to the API?
Probably a list of rows, each row a list of cells. And a document is probably a title plus a body of text?
Exactly. A Sheets response comes back with {"spreadsheets": [...]} when you search, and {"values": [[row1], [row2]]} when you read a range. Docs are simpler still — a title plus a document id. Same skeleton, new response keys, new edge cases.
So by Friday I can append a row to a spreadsheet from Python? Which means I can build logs and trackers that update themselves?
Append a row, read any range, create a fresh doc, read its title back. Five new verbs across two APIs — and Week 4 chains them with Gmail and Calendar into full pipelines.
Goal: Turn spreadsheets and docs into programmable data stores.