Google Sheets and WordPress

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.

WordPress

Actions

• Create a postWrite a new post to your WordPress site. Leave the status empty to save it as a draft.
• Get a postFetch one post by its ID, including its full content.
• Update a postChange an existing post. Fill in only the fields you want to change; everything left empty stays as it is.
• Find postsList or search posts. Every filter is optional; with none set this returns the site's most recent published posts.
• Delete a postMove a post to the trash, or delete it outright. A trashed post can be restored from the WordPress admin; a permanent delete cannot be undone.
• Create a pageCreate a new page. Leave the status empty to save it as a draft.