Google Sheets and Google Drive

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 Drive

Triggers

• New fileRuns when a new file is added to Google Drive.
• File updatedRuns when a file in Google Drive is changed: edited, replaced or renamed.

Actions

• Search filesFind files by words in their names or indexed contents, across My Drive and shared drives. No file link is needed. Returns file names and links; use Read file to answer questions from their contents. Gets one page; to see more, run it again with the next page it gives.
• Read fileRead the text of a Google Doc, presentation, spreadsheet's first tab, PDF, Word document or text file, so later steps can use it. Use a link from Search files or a sharing link. Does not change the file. To keep the file itself, use Download file. Up to 10 MB. A long text is read in parts: to read on, run it again from where it stopped.
• Upload fileUpload a file to Drive and return a link to it.
• Duplicate fileDuplicate a file in its own folder and return a link to the duplicate.
• Delete fileDelete a file from Drive.
• Move fileMove a file to a different folder.