Clientjoy + Google Sheets
Log new Clientjoy leads in Google Sheets
This integration will automatically add Clientjoy leads to rows on Google Sheets.
This integration will automatically add Clientjoy leads to rows on Google Sheets.
- When this happens...
New Lead Is AddedTriggers when a new Lead is added in Clientjoy
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
WorkspaceRequired
StageRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Choose WorkspaceRequired
Lead Email (optional)
Lead Id (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose WorkspaceRequired
Choose Activity TypeRequired
Activity Name
Guests
Starts AtRequired
Ends AtRequired
Color
Link to Lead/Customer
Internal Note
Description
Location
Mark As Done
Send Invites
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose WorkspaceRequired
Recipient NameRequired
Recipient's Email addressRequired
Invoice date
Due date
Choose Item (Product or Service that you are offering)
Item Description
Unit
Quantity
Rate
Tax
Adjustments
Discount Type (Number / Percent)Required
Discount value
When to apply discount?Required
Is this a recurring Invoice?Required
Choose Payment method
Client note
Terms and conditions
Invoice Color
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose WorkspaceRequired
Please choose whether Proposal is for a Lead or CustomerRequired
Recipient NameRequired
Recipient EmailRequired
Name of the Proposal or TitleRequired
Proposal expiry date
Choose your custom proposal template
Choose from Clientjoy's inbuilt templates
Choose Item (Product or Service that you are offering)
Item Description
Unit (e.g. hours, months, etc.)
Quantity
Item Rate
Choose Tax
Want to apply discount?
Choose True if you want to send the proposal automatically to the receiver.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Lead IdRequired
Name
Email
Phone
Company
Title
StageRequired
SourceRequired
OwnerRequired
CurrencyRequired
Deal size
Conversion Probablity
Website
PrivacyRequired
Last Contact
Address
City
State
Country
Zip
Tags
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose WorkspaceRequired
Field To Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appClientjoy WorkspaceRequired
Field To Search ByRequired
Client's full nameRequired
Client's Company
Client's email addressRequired
Client's phone number
Client's Title or Designation
Company's VAT number
Choose CurrencyRequired
Choose Client's OwnerRequired
Client Website
Choose Tags
Add a Note
Billing Address
Billing City
Billing State
Billing Country
Billing Zip
Shipping Address
Shipping City
Shipping State
Shipping Country
Shipping Zip
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 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
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
In which workspace you need to add the Customer?Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.In which workspace you need to add the Lead?Required
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.WorkspaceRequired
Email id of Proposal's receiver (optional)
Clientjoy ID of Proposal
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Clientjoy WorkspaceRequired
Client's full nameRequired
Client's Company
Client's email addressRequired
Client's phone number
Client's Title or Designation
Company's VAT number
Choose CurrencyRequired
Choose Client's OwnerRequired
Client Website
Choose Tags
Add a Note
Billing Address
Billing City
Billing State
Billing Country
Billing Zip
Shipping Address
Shipping City
Shipping State
Shipping Country
Shipping Zip
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Workspace in ClientjoyRequired
Lead's nameRequired
Lead's Email address
Lead's Phone number
Lead's Title or Designation
Lead's Company name
Lead's Website or Link
Deal Size
Choose Currency for Deal SizeRequired
Conversion Probablity (1-100)
Last Contact Date
Sales Stage in PipelineRequired
Source
Choose Lead OwnerRequired
PrivacyRequired
Tags
Note
Address
City
State
Country
Zip
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Customer IdRequired
Name
Email
Title
Phone
Company
VAT Number
CurrencyRequired
OwnerRequired
Website
Billing Address
Billing City
Billing State
Billing Country
Billing Zip
Shipping Address
Shipping City
Shipping State
Shipping Country
Shipping Zip
Tags
Note
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
Field To Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appChoose the workspaceRequired
Team member's email or Full nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkspace in ClientjoyRequired
Field To Search ByRequired
Lead's nameRequired
Lead's Email address
Lead's Phone number
Lead's Title or Designation
Lead's Company name
Lead's Website or Link
Deal Size
Choose Currency for Deal SizeRequired
Conversion Probablity (1-100)
Last Contact Date
Sales Stage in PipelineRequired
Source
Choose Lead OwnerRequired
PrivacyRequired
Tags
Note
Address
City
State
Country
Zip
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 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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
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
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
Headers
Overwrite existing worksheets
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 Clientjoy
Clientjoy is Client Life-Cycle Management Software for Modern Agencies that helps you manage Leads, Proposals, Clients, Invoicing and Revenues under a single roof.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
