Copilot + Google Sheets
Create Google Sheets rows from new Copilot form responses
Streamline your data gathering process with this workflow. When a form response is completed in the Copilot app, a new row is added to your selected Google Sheets spreadsheet. This automation not only saves you time by eliminating manual data entry but also ensures that every bit of data from Copilot is accurately captured in your spreadsheet. Benefit from a more organized approach to data management and start focusing more on analysis rather than collection.
Streamline your data gathering process with this workflow. When a form response is completed in the Copilot app, a new row is added to your selected Google Sheets spreadsheet. This automation not only saves you time by eliminating manual data entry but also ensures that every bit of data from Copilot is accurately captured in your spreadsheet. Benefit from a more organized approach to data management and start focusing more on analysis rather than collection.
- When this happens...
Form Response CompletedTriggers when a form response has been completed by a recipient
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
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.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
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 planList 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
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.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.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
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 Price 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 foundNo 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.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.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
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
ColumnsRequired
Row countRequired
First row
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
Client 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 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.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
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.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
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.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.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 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 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 foundDrive
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
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.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
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
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
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
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 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
- Create clients in Copilot from new or updated Google Sheets rows
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
- Capture new Copilot form responses into Google Sheets spreadsheets
- Create clients in Copilot from new or updated Google Sheets rows