Copilot + Google Sheets
Update Copilot clients with new or updated Google Sheets rows
Keep your client information up-to-date with this efficient workflow. Whenever there's a new or updated row in your Google Sheets spreadsheet, this integration will update the corresponding client in the Copilot app, ensuring their information remains accurate and organized. Save time and maintain consistency by automating your client management process.
Keep your client information up-to-date with this efficient workflow. Whenever there's a new or updated row in your Google Sheets spreadsheet, this integration will update the corresponding client in the Copilot app, ensuring their information remains accurate and organized. Save time and maintain consistency by automating your client management process.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Update ClientUpdate a client
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Client Created
Triggers when a new client is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Clients
Lists the clients.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCompany Created
Triggers when a company gets created in the Copilot for the first time
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contract Signed
Triggers when a contract is signed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Custom Fields
Lists all available custom fields.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFile Created
Triggers when a file gets created within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.File Channel IdRequired
Folder path
Limit
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planFolder Created
Triggers when a folder gets created within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Folder Updated
Triggers when a folder gets updated within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Link Deleted
Triggers when a link gets deleted within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Message Channel Created
Triggers when a new message channel is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Membership Type
The ID of the membership entity. E.g. ID of a company or individual
Member ID
Limit
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planMessage Sent
Triggers when a message gets sent in any channels belonging to the portal
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Workspace
List the workspace associated with the portal
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planIDRequired
Given name
Family Name
Company ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Company IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Membership Type
The ID of the membership entity. E.g. ID of a company or individual
IDs of all members in the channel
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Channel IDRequired
PathRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Channel IDRequired
PathRequired
Link urlRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The ID of the Company to get
Name
ActionThis is an event a Zap performs.SearchFind existing data in your appThe 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
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the internal user to get
ActionThis is an event a Zap performs.SearchFind existing data in your appID
EmailRequired
Company ID
Given nameRequired
Family NameRequired
Send Invite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundThe 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundClient Activated
Triggers when a client authenticates in the Copilot for the first time
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Custom Fields Updated
Triggers only when a client user has updates to custom fields.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client Updated
High-frequency trigger for each client user update.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Companies
Lists the companies.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planContract Requested
Triggers when a contract is assigned to a client.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.File Deleted
Triggers when a file has been deleted within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.File Updated
Triggers when a file has been updated within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Folder Deleted
Triggers when a folder gets deleted within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Link Created
Triggers when a link gets created within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Link Updated
Triggers when a link gets updated within a file channel
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Message Channel Deleted
Triggers when a message channel is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.EmailRequired
Given nameRequired
Family NameRequired
Company ID
Send Invite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Icon Image URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contract Template ID
Recipient ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Channel IDRequired
PathRequired
File ContentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient IDRequired
Form IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Email
Company ID
ActionThis is an event a Zap performs.SearchFind existing data in your appCustom Field IDRequired
Label
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the Form to getRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe 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
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the Company to get
NameRequired
Icon Image URL
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundThe 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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Copilot
Create a client portal to combine messaging, payments, and other modules to offer clients a branded, streamlined experience.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Add new Copilot clients to Google Sheets rows
- Create rows in Google Sheets for new Copilot clients
- List new clients in Copilot and create corresponding spreadsheet rows in Google Sheets
- Create new rows in Google Sheets when new companies are created in Copilot
- Create Google Sheets rows from new Copilot files
- Create new rows in Google Sheets when new clients are created in Copilot
- List new companies in Copilot and create corresponding rows in Google Sheets
- Create Google Sheets rows from new Copilot form responses
- Create new Copilot clients from new Google Sheets rows
- Capture new Copilot form responses into Google Sheets spreadsheets
- Create spreadsheet rows in Google Sheets for new clients created in Copilot
- Create spreadsheet rows in Google Sheets for completed form responses in Copilot