Google Sheets + Textmagic
Log incoming TextMagic calls to a Google Sheet
If you're getting new orders, support requests, or feedback via a TextMagic number, this integration can help you tame the chaos. Every time a new inbound call is received, Zapier will log that call to a row in a Google Sheet. You'll get your to-do list out of your phone and into a tidy spreadsheet so you can easily prioritize what's next.
If you're getting new orders, support requests, or feedback via a TextMagic number, this integration can help you tame the chaos. Every time a new inbound call is received, Zapier will log that call to a row in a Google Sheet. You'll get your to-do list out of your phone and into a tidy spreadsheet so you can easily prioritize what's next.
- When this happens...
New Incoming CallTriggers when someone calls your TextMagic number.
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
New Chat
Triggers when a new chat is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Incoming Call
Triggers when someone calls your TextMagic number.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Incoming Message
Triggers when a new incoming message is received.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Ticket
Triggers when a new support ticket is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Task Updated
Triggers when task is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.PhoneRequired
First Name
Last Name
Email
Company Name
Lists
Phone Number Format
Country
Edit Existing Contact When Found
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Shared
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ChatRequired
AssigneeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task boardRequired
TaskRequired
AssigneeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sender IdRequired
SubjectRequired
MessageRequired
Contacts
Lists
Emails
From name
Reply to email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InboxRequired
SubjectRequired
PriorityRequired
Requester
Requester Email
Assignee
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ListRequired
ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PhoneRequired
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TextRequired
Phones
Contacts
Lists
From
Maximum SMS Parts Count
Reference ID
Phone Numbers Format
Phone Numbers Country
Schedule Message
Timezone
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.List Name
Include Shared Lists?
ActionThis is an event a Zap performs.SearchFind existing data in your appList Name
Include Shared Lists?
Name
Shared
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont 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 found
New Deal
Triggers when a new deal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Missed Call
Triggers when you miss an incoming call to your TextMagic number.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Task
Triggers when a new task is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Unsubscriber
Triggers when someone unsubscribes from your communication.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Ticket Updated
Triggers when ticket is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.ListRequired
ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
TagsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
AssigneeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PipelineRequired
StageRequired
TitleRequired
AmountRequired
Description
Assignee
Probability
Estimated Close Date
Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BoardRequired
StageRequired
TitleRequired
PriorityRequired
Description
Due date
Assignee
Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal pipelineRequired
DealRequired
AssigneeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Dedicated NumberRequired
Forward Calls ToRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom FieldRequired
ContactRequired
Custom Field Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Search Query
Exact Match
Include Shared Contacts?
Phone Number Format
Country
Empty result when query is empty
ActionThis is an event a Zap performs.SearchFind existing data in your appContact Search Query
Exact Match
Include Shared Contacts?
Phone Number Format
Country
Empty result when query is empty
PhoneRequired
First Name
Last Name
Email
Company Name
Lists
Edit Existing Contact When Found
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont 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 found
About Google Sheets
Related categories
About Textmagic
Related categories
Related Zap Templates
- Send sms messages via TextMagic SMS for new rows in Google Sheets
- Send TextMagic SMS messages for new or updated Google Sheets rows
- Create TextMagic SMS contacts from new Google Sheets rows
- Create Google Sheets rows for new TextMagic SMS incoming messages
- Send TextMagic SMS messages for new Google Sheets rows in team drive