Connect Google Sheets and Microsoft Dynamics 365 CRM to unlock the power of automation

Creates a new worksheet by copying an existing worksheet.

Creates a new worksheet in a Google Sheet.

Update a row in a specific spreadsheet.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Triggers when an account is updated.

Triggers when a contact is updated.

Triggers when a quote is updated.

Creates a new campaign.

Creates a new campaign response.

Creates a new custom entity.

Creates a new lead.

Creates a new order.

Updates an existing campaign response.

Updates a custom entity.

Updates an invoice.

Updates an opportunity.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a contact by email address or other searchable field.

Finds a campaign by name.

Finds a invoice by email address or other searchable field.

Finds an opportunity by subject or other searchable field.

Finds an account by name.

Finds a custom entity give.

Finds a lead by email address or other searchable field.

Finds an order by email address or other searchable field.

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Update one or more rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Return up to 1,500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.

Triggers when a new custom entity is created.

Triggers when a case/incident has been updated.

Triggers when an invoice is updated.

Triggers when a lead has been updated.

Triggers when an opportunity has been updated.

Triggers when an order is updated.

Creates a new account.

Creates a new contact.

Creates a new case/incident.

Creates a new invoice.

Creates a new opportunity.

Updates an account.

Updates a contact.

Updates a Case/Incident.

Updates a lead.

Updates a order.

Finds an account by name.

Finds a custom entity give.

Finds a campaign response.

Finds a lead by email address or other searchable field.

Finds an order by email address or other searchable field.

Finds a contact by email address or other searchable field.

Finds a invoice by email address or other searchable field.

Finds an opportunity by subject or other searchable field.