Gmail and Calendar are event-driven apps. Sheets and Docs are data stores. Your time log lives in a Sheet; your proposals live in Docs. What would change about your monthly billing workflow if Python could read and write both?
My time log is a Sheet with date, client, hours, and notes columns. If Python could append rows directly, I would never forget to log a session again.
That is exactly what this week teaches. GOOGLESHEETS_BATCH_GET reads rows. GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND appends a new row. GOOGLESHEETS_SEARCH_SPREADSHEETS finds your time log by name. GOOGLEDOCS_GET_DOCUMENT_BY_ID reads a proposal doc. GOOGLEDOCS_CREATE_DOCUMENT creates a new one. By Friday, a row in Sheets is just a list of strings — and you know how to write one.
And the Docs API just gives back the text content?
A dict with title and body structure. The text is inside nested fields — but .get() and a helper function get you to the plain content quickly.
read_range: fetch a range of rows from a Google Sheet as a list of listsappend_row: append a new time-log row to a Sheetsearch_sheets: find spreadsheets by name queryread_doc: fetch a Google Doc's title and body by document IDcreate_doc: create a new document with a given titleGoal: by Friday you can read your time log, append a session, and create a client report doc — without opening a browser.
Create a free account to get started. Paid plans unlock all tracks.
Gmail and Calendar are event-driven apps. Sheets and Docs are data stores. Your time log lives in a Sheet; your proposals live in Docs. What would change about your monthly billing workflow if Python could read and write both?
My time log is a Sheet with date, client, hours, and notes columns. If Python could append rows directly, I would never forget to log a session again.
That is exactly what this week teaches. GOOGLESHEETS_BATCH_GET reads rows. GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND appends a new row. GOOGLESHEETS_SEARCH_SPREADSHEETS finds your time log by name. GOOGLEDOCS_GET_DOCUMENT_BY_ID reads a proposal doc. GOOGLEDOCS_CREATE_DOCUMENT creates a new one. By Friday, a row in Sheets is just a list of strings — and you know how to write one.
And the Docs API just gives back the text content?
A dict with title and body structure. The text is inside nested fields — but .get() and a helper function get you to the plain content quickly.
read_range: fetch a range of rows from a Google Sheet as a list of listsappend_row: append a new time-log row to a Sheetsearch_sheets: find spreadsheets by name queryread_doc: fetch a Google Doc's title and body by document IDcreate_doc: create a new document with a given titleGoal: by Friday you can read your time log, append a session, and create a client report doc — without opening a browser.