Active Campaign

Actions

Create or Update Account Create Or Update Contact

Queries

Airtable

Actions

Create or Update Record

Triggers

New Record Record Updated

Queries

Asana

Actions

Create Task Delete Task Update Task

Triggers

Task Updated

Queries

Bonzo

Actions

Attach Note to Prospect Create or update Prospect Send Email to Prospect Send SMS to Prospect

Triggers

New Conversation New Prospect New Task

Queries

Close

Actions

Create Lead Update Lead Update or Create Lead

Queries

Distru

Actions

Create Order

Triggers

New Order New Product New Account New Inventory Order Updated Product Updated Inventory Updated Account Updated

Queries

Dynamics 365 Business Central

Actions

Create or Update Contact Create or Update Sales Order Line Create or Update Sales Order Delete Contact Delete Sales Order Line Delete Sales Order

Triggers

Contact Updated Customer Updated Item Updated Item Variant Updated New Contact New Customer New Item Variant New Item Sales Order Updated

Queries

Dynamics 365 CRM

Actions

Create or Update Contact Create or Update Account Create or Update Opportunity

Triggers

New Contact New Account New Opportunity

Queries

Facebook

Actions

Add User to Customer List Custom Audience

Triggers

New Lead

Queries

Flourish

Actions

Create or Update Destination Contacts Create or Update Destinations Create or Update Order

Triggers

Contact Updated Destination Updated Inventory Updated Inventory Summary Updated New Contact New Destination New Inventory New Inventory Summary New Order New Item Order Updated Item Updated

Queries

Freshservice

Actions

Create Requester Create Ticket

Queries

Google Docs

Actions

Create Document Edit Document

Queries

Google Sheets

Actions

Add or Update Row Export to Sheet

Queries

Hubspot

Actions

Create Engagement Create or Update Contact Create or Update Deal Create Contact Update Contact Create Deal Update Deal

Triggers

New Call Recording New Deal New Contact New Company

Queries

Instagram

Actions

Create Post Send Message

Triggers

Message Received

Queries

Intercom

Actions

Create Or Update User Create Lead

Queries

Jira Software Cloud

Actions

Add Comment to Issue Create Issue

Queries

Klaviyo

Actions

Add or Update Subscriber Create Event

Queries

LeafLink

Actions

Create or Update Contact Create or Update Customer Create or Update Order Create or Update Product

Triggers

Contact Updated Customer Updated New Contact New Customer New Order New Product Order Updated Product Updated

Queries

Linear

Actions

Create Issue

Triggers

Issue created Issue removed Issue updated

Queries

Mailchimp

Actions

Create Event Create or Update a Subscriber in an Audience

Queries

Microsoft Teams

Actions

Create Channel Send Channel Message Send Chat Message

Queries

Notion

Actions

Create Page Create Database Item

Queries

Pipedrive

Actions

Add Deal Add Note Add Organization Add Person Update Deal Update Organization Update Person

Queries

QuickBooks Online

Actions

Create Customer Create Invoice

Queries

Salesforce

Actions

Create Account Create Contact Create Event Create Lead Create Opportunity Create Object Record Create Task Attach Note Create or Update Record Create or Update Contact and Account Create or Update Contact and add to Campaign Update Account Update Contact Update Event Update Lead Update Note Update Opportunity Update Task Upload File

Triggers

New Account Account Updated New Campaign New Case New Contact New Event Event Updated New Lead New Note Note Updated New Opportunity New Task Task Updated

Queries

SendGrid

Actions

Create or update Contact Send Email

Queries

Shopify

Actions

Create Customer Create Order

Triggers

Abandoned Cart New Customer New Order

Slack

Actions

Add Channel Archive Channel Send Bot Message to Channel Send Bot Message to User Send Channel Message Send Direct Message Set Channel Topic Set profile status

Queries

Smartsheet

Actions

Add Row to Sheet Update Row

Triggers

New Row Updated Row

Queries

Twilio

Actions

Send SMS

Triggers

New Recording New SMS

Queries

Webflow

Actions

Add Custom Code to Page

Triggers

New Form Submission

Queries

Xero

Actions

Create contact Create invoice

Queries

Zendesk

Actions

Create Ticket Create or update an user

Queries

Zoho CRM

Actions

Add Note Create Activity (Task, Call, Meeting)Create or Update Account Create or Update Contact Create or Update Lead

Triggers

New Lead New Contact New Account

Queries

Google Sheets / Add or Update Row

appKey: google-sheets

actionKey: add-row

Action Inputs

The following parameters are available when configuring this action:

sheetIdrequiredstring

A specific sheet id containing the rows of columns. E.g., 'Sheet1'.

spreadsheetIdrequiredstring

The google sheet id containing the relevant sheet.

columnsobject

The columns to add to the row. Loaded from existing headers on a sheet

Show Example

{
  "columns": {
    "Property_A_Key": "Property_A_Value",
    "Property_B_Key": "Property_B_Value",
    "...": "..."
  }
}

fieldIdstring

The fieldId which will be used in conjunction with the searchValue to find the row to update. Includes any existing id values available in the dynamic schema for the selected trigger. (See Dynamic Schemas for more information.)

updateExistingRowboolean

If true, will update an existing row if found. If the row cannot be found a new row will be created