Copilot + Google Sheets
Create clients in Copilot from new or updated Google Sheets rows
Keep your client information current and organized by connecting your Google Sheets with Copilot. With this workflow, each time you add or make changes to a row in your Google spreadsheet, a new client will be created in Copilot. This automation not only saves time but also ensures that all client data in the Copilot app is always up-to-date and consistent with the entries in your Google Sheets.
Keep your client information current and organized by connecting your Google Sheets with Copilot. With this workflow, each time you add or make changes to a row in your Google spreadsheet, a new client will be created in Copilot. This automation not only saves time but also ensures that all client data in the Copilot app is always up-to-date and consistent with the entries in your Google Sheets.
- When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create ClientCreates a new 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 ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
List App Installs
Lists the app installs in a workspace.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planClient 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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.Internal User Created
Triggers when a new internal user is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Deleted
Triggers when an invoice is deleted
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Paid
Triggers when an invoice is paid
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Updated
Triggers when an invoice is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Invoice Templates
Lists the invoice templates.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planLink 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
The ID of the client user
Member ID
Limit
Try ItTriggerThis is the start of your ZapPollingZapier 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.Note Deleted
Triggers when a note is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Note Updated
Triggers when a note is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Failed
Triggers when a payment is failed for an invoice
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Payment Succeeded
Triggers when a payment is successful for an invoice
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Prices
Lists the prices.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planList Products
Lists the products.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSubscription Canceled
Triggers when an subscription is canceled
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Subscriptions
Lists the subscriptions.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTask Archived
Triggers when a task gets archived in your workspace.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Created
Triggers when a task gets created in your workspace.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Limit
Next Token
Created By
Parent Task ID
Status
Client ID
Company ID
Internal User ID
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTask Updated
Triggers when a task gets updated in your workspace.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
Given name
Family Name
Company ID
Send Invite?
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 (Deprecated)
IDs of all members in the channel
Client ID
Company ID
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.Recipient type
Note
Amount (in cents)
Description
QuantityRequired
Note
Product
Note
Price
Days Until DueRequired
Tax Percentage
Memo
Accept Payment Via Credit Card
Accept Payment Via Bank Transfer
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 (Deprecated).
Member IDs - IDs of client members to be added to this channel
Client ID
Company ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Entity TypeRequired
ID of the entity, e.g., ID of a company or client.Required
TitleRequired
Content
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Subscription
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Description
Parent Task ID
Client ID
Company ID
Internal User ID
Status
Due Date
Template ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The ID of the App InstallRequired
ClientId
CompanyId
ActionThis is an event a Zap performs.SearchFind existing data in your appID
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 file to getRequired
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 appThe ID of the note to retrieve.
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the Product to getRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the task to getRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe 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
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 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 file to getRequired
Channel IDRequired
PathRequired
File ContentRequired
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 note to retrieve.
Entity TypeRequired
ID of the entity, e.g., ID of a company or client.Required
TitleRequired
Content
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 task to getRequired
Name
Description
Parent Task ID
Client ID
Company ID
Internal User ID
Status
Due Date
Template ID
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
Search from last row
Row count
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.Query param to filter placeholder companies
Try ItTriggerThis is the start of your ZapPollingZapier 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.Internal User Deleted
Triggers when an internal user is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Created
Triggers when an invoice is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Invoices
Lists the invoices.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planInvoice Sent
Triggers when an invoice is sent
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Invoice Voided
Triggers when an invoice is voided
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.Note Created
Triggers when a new note is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Entity Type
The ID of the entity assigned to the note. E.g. ID of a client or company.
Limit
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planList Payments
Lists the payments.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPrice Created
Triggers when a price is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Created
Triggers when a product is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Product Updated
Triggers when a product is updated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Created
Triggers when an subscription is created
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.List Subscription Templates
Lists the subscription templates.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planTask Completed
Triggers when a task gets completed in your workspace.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Deleted
Triggers when a task gets deleted in your workspace.
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 ZapPollingZapier checks for new data every 15 min on the Free planEmailRequired
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 (Deprecated)
Client ID
Company 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 ID (Deprecated)
Form IDRequired
Client ID
Company ID
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.TitleRequired
ContentRequired
Note IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient type
Prompt
Amount (in cents)
Description
QuantityRequired
Prompt Product
Product
Price Prompt
Price
Days Until DueRequired
Interval
Tax Percentage
Memo
Accept Payment Via Credit Card
Accept Payment Via Bank Transfer
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Description
Client ID
Company ID
Internal User ID
Status
Due Date
Is Archived
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe 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
Client ID
Company ID
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
The ID of the client user
Member ID
Limit
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the Price to getRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the Subscription to getRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appThe ID of the task template to getRequired
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 (Deprecated)
Member ID
Client ID
Company 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 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 (Deprecated).
Client ID
Member ID
Limit
Member IDs - IDs of client members to be added to this channel
Company ID
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 Subscription to getRequired
Recipient type
Prompt
Amount (in cents)
Description
QuantityRequired
Prompt Product
Product
Price Prompt
Price
Days Until DueRequired
Interval
Tax Percentage
Memo
Accept Payment Via Credit Card
Accept Payment Via Bank Transfer
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
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Add new Copilot clients to Google Sheets rows
- Create rows in Google Sheets for new Copilot clients
- Update Copilot clients with new or updated Google Sheets rows
- 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
Related Zap Templates
- Add new Copilot clients to Google Sheets rows
- List new clients in Copilot and create corresponding spreadsheet rows in Google Sheets
- Create new rows in Google Sheets when new clients are created in Copilot
- Create new Copilot clients from new Google Sheets rows
- Create spreadsheet rows in Google Sheets for completed form responses in Copilot