Google Sheets + MyCase
Create new MyCase calls from new Google Sheets rows
Stay organized and proactive with this efficient workflow. Whenever a new spreadsheet row is added in Google Sheets, a corresponding call is created in the MyCase application. Not only does this save you time by eliminating manual data input, it ensures you never miss a detail or task from your spreadsheets. Make every cell count with this streamlined automation.
Stay organized and proactive with this efficient workflow. Whenever a new spreadsheet row is added in Google Sheets, a corresponding call is created in the MyCase application. Not only does this save you time by eliminating manual data input, it ensures you never miss a detail or task from your spreadsheets. Make every cell count with this streamlined automation.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create CallCreates a new Call.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
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 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
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
No 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 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.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 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 spreadsheet rows in Google Sheets for new or updated leads in MyCase
- 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