Google Sheets + MyCase
Create new MyCase cases from new or updated rows in Google Sheets team drive
Stay organized and alert with this Google Sheets and MyCase workflow. Anytime a row is added or updated in your Team Drive Spreadsheet on Google Sheets, a new case is instantly created in your MyCase application. This facilitates a seamless, efficient way of managing and transferring vital case information between the two platforms, ensuring your team always stays on track.
Stay organized and alert with this Google Sheets and MyCase workflow. Anytime a row is added or updated in your Team Drive Spreadsheet on Google Sheets, a new case is instantly created in your MyCase application. This facilitates a seamless, efficient way of managing and transferring vital case information between the two platforms, ensuring your team always stays on track.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create CaseCreates a new Case.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
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.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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
Include Grid Data
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 foundNameRequired
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.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.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 found
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCalled 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
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 found
About Google Sheets
Related categories
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new or updated leads in MyCase
- 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
- Create tasks in MyCase for new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new or updated persons in MyCase
- Create calls in MyCase from new or updated rows in Google Sheets
- Create new MyCase cases from new Google Sheets rows
- Add or update MyCase companies to create rows in a Google Sheets spreadsheet
- Create persons in MyCase for every new or updated row in Google Sheets
- Add or update MyCase persons to Google Sheets by creating a new row at top
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new or updated leads in MyCase
- Create new MyCase events from new or updated rows in Google Sheets
- Create tasks in MyCase for new or updated rows in Google Sheets
- Create new MyCase cases from new Google Sheets rows
- Add or update MyCase persons to Google Sheets by creating a new row at top