Google Drive: list documents waiting for signature
Automatically list documents waiting for signature on docs.google.com. List the Google Drive / Docs files with an open signature or approval request: those waiting for the signed-in account to sign (default), or those the account sent out. Each item has the file id, title and the link to sign it; pass the link to sign_document. Returns an empty list when nothing is waiting. Reads the first screen of Drive's results (about 50 files). When the browser is signed in to several Google accounts, pass the account to act as.
Input
which optionalto_sign: requests waiting for this account to sign or approve. sent: requests this account sent out.
Default: "to_sign"account optionalGoogle account to act as when the browser is signed in to several.
Output
items requiredwhich requiredaccount optionalFAQ
Create a Google Sheets spreadsheet
Create a new Google Spreadsheet in My Drive, optionally with a title. Returns spreadsheetId, url, and firstGid (always 0). The file lands in Drive root (My Drive); moving it elsewhere is a Drive action, not a Sheets one.
Sheets: write cells
Write a 2D block of values into one tab of a Google Spreadsheet, top-left at startCell, like the Sheets API: null leaves a cell as it is, "" clears it, anything else replaces it as if typed (dropdown rules and formatting stay; clearing a dropdown cell removes its dropdown). Returns range, rows, cols, saved once every edit is saved. A value the sheet refuses (data validation, outside the grid) stops the run with the sheet's own message. Values are parsed per the spreadsheet locale ("1.5" in a FR sheet becomes 1 May; prefix ' to force text); leading = enters a formula; needs edit rights.
Sheets: add tab
Add a tab to a Google Spreadsheet, optionally naming it in the same pass. Returns the new tab's gid and final name. Waits for the editor's save before resolving; needs edit rights.
