Google Sheets + MyCase
Create spreadsheet rows in Google Sheets for new or updated leads in MyCase
Stay organized and on top of your new or updated leads in MyCase with this efficient workflow. Whenever a change is made to leads in MyCase, this workflow generates a new row in your chosen Google Sheets spreadsheet. This saves you time inputting data manually and ensures your leads are easy to manage and always up to date.
Stay organized and on top of your new or updated leads in MyCase with this efficient workflow. Whenever a change is made to leads in MyCase, this workflow generates a new row in your chosen Google Sheets spreadsheet. This saves you time inputting data manually and ensures your leads are easy to manage and always up to date.
- When this happens...
Lead Added or UpdatedTriggers when a lead has been added/updated.
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
NameRequired
Case Number
Opened Date
Case Stage
Practice Area
Description
Sol Date
Status
Billing Contact
People
Companies
Staff
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MyCase Company To UpdateRequired
Email
Name
Website
Line 1
Line 2
City
State
ZIP Code
Country
Main Phone Number
Fax Phone Number
Notes
Cases
People
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
NameRequired
PathRequired
DocumentRequired
Description
Assigned Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity NameRequired
Description
Entry DateRequired
BillableRequired
CostRequired
UnitsRequired
CaseRequired
StaffRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Address Line 1
Address Line 2
City
State
Zip Code
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MyCase Person To UpdateRequired
Email
First Name
Middle Name
Last Name
Line 1
Line 2
City
State
ZIP Code
Country
Cell Phone Number
Work Phone Number
Home Phone Number
Notes
Date of birth
Cases
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Priority
Due Date
Completed
Case
StaffRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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.Search TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
NameRequired
Case Number
Opened Date
Case Stage
Practice Area
Description
Sol Date
Status
Billing Contact
People
Companies
Staff
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch TypeRequired
Search ValueRequired
Email
NameRequired
Website
Line 1
Line 2
City
State
ZIP Code
Country
Main Phone Number
Fax Phone Number
Notes
Cases
People
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch TypeRequired
Search ValueRequired
Email
First NameRequired
Middle Name
Last NameRequired
Line 1
Line 2
City
State
ZIP Code
Country
Cell Phone Number
Work Phone Number
Home Phone Number
Notes
Date of birth
Cases
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch TypeRequired
Search ValueRequired
NameRequired
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
Called AtRequired
Caller Phone NumberRequired
MessageRequired
ResolvedRequired
Call Type
Call ForRequired
CallerRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MyCase Case To UpdateRequired
Name
Case Number
Opened Date
Case Stage
Practice Area
Description
Sol Date
Status
Billing Contact
People
Companies
Staff
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
NameRequired
Website
Line 1
Line 2
City
State
ZIP Code
Country
Main Phone Number
Fax Phone Number
Notes
Cases
People
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Parent TypeRequired
Field TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
StartRequired
EndRequired
All Day
Private
Location
Case
Required StaffRequired
Optional Staff
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
First NameRequired
Middle Initial
Last NameRequired
Line 1
Line 2
City
State
Zip Code
Country
Cell Phone Number
Work Phone Number
Home Phone Number
Lead Details
Birthdate
Drivers License Number
Drivers License State
Referral Source Reference
Referred By
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
SubjectRequired
NoteRequired
DateRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email
First NameRequired
Middle Name
Last NameRequired
Line 1
Line 2
City
State
ZIP Code
Country
Cell Phone Number
Work Phone Number
Home Phone Number
Notes
Date of birth
Cases
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity NameRequired
Description
Entry DateRequired
Billable
Flat Fee
RateRequired
HoursRequired
CaseRequired
StaffRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TypeRequired
Search ValueRequired
NameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch TypeRequired
Search ValueRequired
NameRequired
Address Line 1
Address Line 2
City
State
Zip Code
Country
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch TypeRequired
Search ValueRequired
NameRequired
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
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related categories
Related Zap Templates
- Create new MyCase calls from new Google Sheets rows
- Create new MyCase leads from new rows in Google Sheets
- Create new MyCase events from new or updated rows in Google Sheets
- Update Google Sheets rows for each new or updated event in MyCase
- Add or update MyCase cases and create corresponding rows in Google Sheets