Capsule CRM + Google Sheets

Create multiple Google Sheets rows for new or updated opportunities in Capsule CRM

Stay up to date with new or updated opportunities in Capsule CRM with this handy workflow. Each time there is a change in your opportunities within Capsule CRM, it systematically generates multiple rows within Google Sheets. This not only offers a convenient way to manage your opportunities, but it also allows you to analyze them more efficiently, leading to strategic business decisions.

When this happens...
New or Updated Opportunity
Triggers when a given action is performed on an Opportunity.
TriggerInstant
automatically do this!
Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
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

- ActionRequired
Trigger
Instant
Try It
- ActionRequired
Trigger
Instant
Try It
- ContactRequired
- NameRequired
- Board
- Description
- Expected Close Date
- Track
- Opportunity
- Owner
- Tags
- Status
Action
Write
- Entity TypeRequired
Action
Write
- TypeRequired
- About
- Email Address
- Street Address
- City
- State
- Zip Code
- Country
- Phone Number
- Tags
Action
Write

- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Update Contact
Update an existing Contact
Action
Write

- PipelineRequired
- NameRequired
Action
Search
- Search usingRequired
Action
Search
- Search usingRequired
- ContactRequired
- NameRequired
- Board
- Description
- Expected Close Date
- Track
- Opportunity
- Owner
- Tags
- Status
Action
Search or write
- Search usingRequired
- TypeRequired
- About
- Email Address
- Street Address
- City
- State
- Zip Code
- Country
- Phone Number
- Tags
Action
Search or write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
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

- ActionRequired
Trigger
Instant
Try It
- ActionRequired
Trigger
Instant
Try It
- Entity TypeRequired
- Activity Type
- NoteRequired
Action
Write
- ContactRequired
- PipelineRequired
- NameRequired
- Description
- Expected Close Date
- Actual Close Date
- Currency
- Duration Basis
- Owner
- Track
- Tags
Action
Write
- DescriptionRequired
- Due DateRequired
- Detail
- Category
- Owner
- Entity Type
Action
Write
Update Opportunity
This action updates an existing Opportunity in Capsule CRM. You can choose which fields to update from the editor. The Opportunity ID is selected from a dropdown list populated by the listOpportunities endpoint. The milestoneName field is a string input f
Action
Write
- Search usingRequired
Action
Search
- Search usingRequired
Action
Search
- BoardRequired
- NameRequired
Action
Search
- Search usingRequired
- ContactRequired
- PipelineRequired
- NameRequired
- Description
- Expected Close Date
- Actual Close Date
- Currency
- Duration Basis
- Owner
- Track
- Tags
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
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
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About Capsule CRM

Capsule is an online CRM for managing contacts, tasks and sales opportunities. Add tasks, track communication logs, and close deals in your pipeline faster with Capsule.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Capsule CRM + Google Sheets

Create multiple Google Sheets rows for new or updated opportunities in Capsule CRM

New or Updated Project

New or Updated Contact

Create Project

Add Tag to Entity

Create Contact

API Request (Beta)

Update Contact

Find Milestone

Find Contact

Find or Create Project

Find or Create Contact

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New or Updated Opportunity

New or Updated Task

Add Note to Entity

Create Opportunity

Create Task

Update Opportunity

Find Project

Find Opportunity

Find Stage

Find or Create Opportunity

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

About Capsule CRM

Related categories

Similar apps

Streak

Insightly

Zapier Interfaces

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

Related Zap Templates

Related Zap Templates