Google Sheets and Google Forms

Google Sheets

Triggers

• New row in a Google SheetRuns when a new row is added to a Google Sheets spreadsheet, with the row's cells by their column headings and the spreadsheet and tab it was added to, for a step that writes back to the row, such as Update cells in row.

Actions

• Add rowAdd a row to the end of a tab.
• Create spreadsheetCreate a new spreadsheet.
• Delete spreadsheetDelete a spreadsheet permanently.
• Overwrite rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update cells in row.
• Update cells in 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 (row.row_number). A column that doesn't exist yet is added to the header row.
• Clear rowEmpty a row's cells without deleting the row.

Google Forms

Triggers

• New responseRuns for each new response to a form, with its answers by question. Responses already there when the workflow is turned on don't start it. How often it checks follows your workspace plan.

Actions

• Create formCreate a new, blank Google Form with a title.
• Add a questionAdd a question to the end of a form: a short or long answer, multiple choice, checkboxes or a dropdown.
• Get formLook up a form's title, description, and questions.
• List form responsesList the responses submitted to a form.
• Get form responseLook up a single form response by its ID.
• Delete formMove a form a workflow made to the trash in Google Drive, where it can be restored for 30 days. Only forms made by workflows can be deleted.