Copilot + Microsoft Excel

Add rows in Microsoft Excel for new client activations in Copilot

Effortlessly streamline your client management process with this Copilot and Microsoft Excel integration. When a client is activated in Copilot, a new row is instantly added to your Microsoft Excel spreadsheet, ensuring up-to-date and accurate records without any manual work. Stay organized and efficient while managing your growing client list with this seamless workflow.

When this happens...
Client Activated
Triggers when a client authenticates in the Copilot for the first time
TriggerInstant
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

List App Installs
Lists the app installs in a workspace.
Trigger
Scheduled
Try It
Client Created
Triggers when a new client is created.
Trigger
Instant
Try It
List Clients
Lists the clients.
Trigger
Scheduled
Try It
Company Created
Triggers when a company gets created in the Copilot for the first time
Trigger
Instant
Try It
Contract Signed
Triggers when a contract is signed.
Trigger
Instant
Try It

List Custom Fields
Lists all available custom fields.
Trigger
Scheduled
Try It
File Created
Triggers when a file gets created within a file channel
Trigger
Instant
Try It

- File Channel IdRequired
- Folder path
- Limit
Trigger
Scheduled
Try It
Folder Created
Triggers when a folder gets created within a file channel
Trigger
Instant
Try It
Folder Updated
Triggers when a folder gets updated within a file channel
Trigger
Instant
Try It
- Limit
Trigger
Scheduled
Try It
Link Deleted
Triggers when a link gets deleted within a file channel
Trigger
Instant
Try It
Message Channel Created
Triggers when a new message channel is created.
Trigger
Instant
Try It
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
- Limit
Trigger
Scheduled
Try It
Message Sent
Triggers when a message gets sent in any channels belonging to the portal
Trigger
Instant
Try It
List Workspace
List the workspace associated with the portal
Trigger
Scheduled
Try It
- EmailRequired
- Given nameRequired
- Family NameRequired
- Company ID
- Send Invite?
Action
Write
- NameRequired
- Icon Image URL
Action
Write
- Contract Template ID
- Recipient ID
Action
Write
- Channel IDRequired
- PathRequired
- File ContentRequired
Action
Write
- Recipient IDRequired
- Form IDRequired
Action
Write
- Membership TypeRequired
- Entity ID - ID of the membership entity, e.g., ID of a company or individual client user
- Member IDs - IDs of client members to be added to this channel
Action
Write
- The ID of the App InstallRequired
- ClientId
- CompanyId
Action
Search
- The ID of the Company to get
- Name
Action
Search
- The ID of the file channel to get
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
Action
Search
- The ID of the internal user to get
Action
Search
- The ID of the App InstallRequired
- ClientId
- The company id of the App Connection
- The type of the App ConnectionRequired
- The content of the App ConnectionRequired
- The client ids to be part of the App Connection
Action
Search or write
- The ID of the Company to get
- NameRequired
- Icon Image URL
Action
Search or write
- The ID of the message channel to get
- Membership TypeRequired
- Entity ID - ID of the membership entity, e.g., ID of a company or individual client user
- Member ID
- Limit
- Member IDs - IDs of client members to be added to this channel
Action
Search or write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

Client Activated
Triggers when a client authenticates in the Copilot for the first time
Trigger
Instant
Try It
Client Custom Fields Updated
Triggers only when a client user has updates to custom fields.
Trigger
Instant
Try It
Client Updated
High-frequency trigger for each client user update.
Trigger
Instant
Try It
List Companies
Lists the companies.
Trigger
Scheduled
Try It
Contract Requested
Triggers when a contract is assigned to a client.
Trigger
Instant
Try It
- Custom Field IDRequired
Trigger
Scheduled
Try It
File Deleted
Triggers when a file has been deleted within a file channel
Trigger
Instant
Try It
File Updated
Triggers when a file has been updated within a file channel
Trigger
Instant
Try It
Folder Deleted
Triggers when a folder gets deleted within a file channel
Trigger
Instant
Try It
- Form IDRequired
Trigger
Instant
Try It
Link Created
Triggers when a link gets created within a file channel
Trigger
Instant
Try It
Link Updated
Triggers when a link gets updated within a file channel
Trigger
Instant
Try It
Message Channel Deleted
Triggers when a message channel is deleted.
Trigger
Instant
Try It
- Channel ID
- Limit
Trigger
Scheduled
Try It
- Recipient ID
Trigger
Instant
Try It
- The ID of the App InstallRequired
- The type of the App ConnectionRequired
- The content of the App ConnectionRequired
- The company id of the App Connection
- The client ids to be part of the App Connection
Action
Write
- IDRequired
- Given name
- Family Name
- Company ID
Action
Write
- NameRequired
- Company IDRequired
Action
Write
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- IDs of all members in the channel
Action
Write
- Channel IDRequired
- PathRequired
Action
Write
- Channel IDRequired
- PathRequired
- Link urlRequired
Action
Write
- The text content of the messageRequired
- The Id of the target message channelRequired
- (Optional) The Id of the client who is the author of the message
Action
Write
- ID
- Email
- Company ID
Action
Search
- Custom Field IDRequired
- Label
Action
Search
- The ID of the Form to getRequired
Action
Search
- The ID of the message channel to get
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
- Limit
Action
Search
- ID
- EmailRequired
- Company ID
- Given nameRequired
- Family NameRequired
- Send Invite?
Action
Search or write
- The ID of the file channel to get
- Membership Type
- The ID of the membership entity. E.g. ID of a company or individual
- Member ID
- IDs of all members in the channel
Action
Search or write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

About Copilot

Create a client portal to combine messaging, payments, and other modules to offer clients a branded, streamlined experience.

Learn more

Related categories

Project Management

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

PRODUCTS

CAPABILITIES

By team

Copilot + Microsoft Excel

Add rows in Microsoft Excel for new client activations in Copilot

List App Installs

Client Created

List Clients

Company Created

Contract Signed

List Custom Fields

File Created

List Files

Folder path

Limit

Folder Created

Folder Updated

List Internal Users

Limit

Link Deleted

Message Channel Created

List Message Channels

Membership Type

The ID of the membership entity. E.g. ID of a company or individual

Member ID

Limit

Message Sent

List Workspace

Create Client

EmailRequired

Given nameRequired

Family NameRequired

Company ID

Send Invite?

Create Company

NameRequired

Icon Image URL

Create Contract

Contract Template ID

Recipient ID

Create File

Channel IDRequired

PathRequired

File ContentRequired

Request Form Responses

Recipient IDRequired

Form IDRequired

Create Message Channel

Membership TypeRequired

Entity ID - ID of the membership entity, e.g., ID of a company or individual client user

Member IDs - IDs of client members to be added to this channel

Find App Connection

The ID of the App InstallRequired

ClientId

CompanyId

Find a Company

The ID of the Company to get

Name

Find a File Channel

The ID of the file channel to get

Membership Type

The ID of the membership entity. E.g. ID of a company or individual

Member ID

Find an Internal User

The ID of the internal user to get

Find or Create AppConnection

The ID of the App InstallRequired

ClientId

The company id of the App Connection

The type of the App ConnectionRequired

The content of the App ConnectionRequired

The client ids to be part of the App Connection

Find or Create Company

The ID of the Company to get

NameRequired

Icon Image URL

Find or Create Message Channel

The ID of the message channel to get

Membership TypeRequired

Entity ID - ID of the membership entity, e.g., ID of a company or individual client user