Clientjoy + Google Sheets

Add new Clientjoy clients to Google Sheets rows automatically

Effortlessly manage your new Clientjoy contacts and stay organized with this seamless integration to Google Sheets. When a new client is added in Clientjoy, this workflow will create a new row in your specified Google Sheets spreadsheet with all the important client information. Simply set it up and enjoy a clutter-free, systematic process for handling your growing client database.

When this happens...
New Client Is Added
Triggers when a new client is added in Clientjoy
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
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?

- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
- StageRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It

- WorkspaceRequired
Trigger
Instant
Try It
- Choose WorkspaceRequired
- Lead Email (optional)
- Lead Id (optional)
Action
Write

- 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
Action
Write
- 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
Action
Write
- 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.
Action
Write
- 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
Action
Write
- Choose WorkspaceRequired
- Field To Search ByRequired
Action
Search
- Clientjoy 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
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

- WorkspaceRequired
Trigger
Instant
Try It
- In which workspace you need to add the Customer?Required
Trigger
Instant
Try It
- In which workspace you need to add the Lead?Required
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
- Email id of Proposal's receiver (optional)
- Clientjoy ID of Proposal
Action
Write
- 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
Action
Write
- 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
Action
Write
- 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
Action
Write
- WorkspaceRequired
- Field To Search ByRequired
Action
Search
- Choose the workspaceRequired
- Team member's email or Full nameRequired
Action
Search
- Workspace 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
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

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.