Google Sheets and Google Docs

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

Google Docs

Triggers

• Google Docs Document ModifiedTriggers when a Google Docs document is modified

Actions

• Create documentCreate a new Google Docs document with a given title.
• Get document textRetrieve the plain text content of a Google Docs document.
• Append textAppend text to the end of a Google Docs document.
• Replace textReplace all occurrences of a word or phrase in a Google Docs document.
• Insert headingInsert a heading at the end of a Google Docs document.
• Add bulleted listAdd a bulleted list at the end of a Google Docs document.