Google Sheets and Fillout

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.

Fillout

Triggers

• New submissionRuns when a Fillout form receives a completed response.
• Submission updatedRuns when a response to a Fillout form is edited.

Actions

• List formsList the forms on your Fillout account.
• Get a formFetch one form's structure: its questions, calculations, URL parameters, scheduling and payment fields, so you know which IDs to send when creating a submission.
• List submissionsList the submissions a form has received, newest first.
• Get a submissionFetch one submission and all of its answers.
• Create a submissionRecord a submission against a form without going through the form itself, useful for importing responses collected elsewhere.
• Delete a submissionPermanently delete one submission from a form. This cannot be undone, and the response stops counting toward the form's results.