Google Sheets + Spiro
Create Spiro tickets from new or updated rows in Google Sheets team drive
Stay on top of your tasks with this streamlined functionality that springs into action every time there's a new or updated row in your Google Sheets on Team Drive. Instead of manually transferring this information, this automation promptly creates a ticket in Spiro, saving you time and reducing the chance for errors. Manage your workflow more effectively and ensure no detail gets overlooked.
Stay on top of your tasks with this streamlined functionality that springs into action every time there's a new or updated row in your Google Sheets on Team Drive. Instead of manually transferring this information, this automation promptly creates a ticket in Spiro, saving you time and reducing the chance for errors. Manage your workflow more effectively and ensure no detail gets overlooked.
- 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 TicketTriggers when new ticket created.
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 ZapPollingZapier 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.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.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
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 foundSpiro Users
Sales Stage
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Custom Entity TypeRequired
Field Name
Field Value
Spiro Users
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New User
Triggers when new user created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Custom Entity TypeRequired
Trigger AttributeRequired
Trigger ValueRequired
Spiro Users
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Field Name
Field Value
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Company IDRequired
Custom EntityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Custom EntityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom EntityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Company ID
Description
Website
Opportunity Name
Amount
Close Date
Sales Stage Name
Pipeline Name
Sales Stage
Priority
Opportunity Owner Full Name
External Id
Forecast Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Opportunity IDRequired
Custom EntityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reminder DateRequired
ReminderRequired
Company IdRequired
Spiro User
Remind Me
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Support DeskRequired
Spiro User
SubjectRequired
EmailRequired
Contact ID
Company ID
Priority
Status
Description
Full Name
Company Name
Phone
Mobile Phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Message
Link
Spiro User. Leave it blank to send the message to your account.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Company Name
Website
Address
City
State
Zipcode
Region
Country
Phone
Description
Owner
External Id
Timezone
Customer Status
Tier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom EntityRequired
Record IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Name
Header Notes
Footer Notes
Expiration Date
Quote Status
Link To Document
Most Recent Quote Date
Spiro User
Company ID
Primary Contact ID
Opportunity ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
Order Budget
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Subject
Description
Priority
Status
Spiro User
Contact ID
Company ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Field to Search ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Sales Stage
ActionThis is an event a Zap performs.SearchFind existing data in your appContact ID
Contact Email
Interaction type
Number of interactions
ActionThis is an event a Zap performs.SearchFind existing data in your appCustom ListRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search Latest First?
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
Full NameRequired
Email
Phone
Mobile Phone
Description
Company Name
Title
Opportunity ID
Campaigns
External Id
Timezone
Spiro User
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Search ValueRequired
Support DeskRequired
Spiro User
SubjectRequired
EmailRequired
Contact ID
Company ID
Priority
Status
Description
Full Name
Company Name
Phone
Mobile Phone
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 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 foundNew Company
Triggers when new company created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Ticket
Triggers when new ticket created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Spiro Users
Opportunity Attributes
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Custom Entity TypeRequired
Trigger AttributeRequired
Trigger ValueRequired
Spiro Users
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Custom Entity TypeRequired
Trigger AttributeRequired
Trigger ValueRequired
Spiro Users
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Field Name
Field Value
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Entity NameRequired
Field Name
Field Value
Spiro Users
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Opportunity IDRequired
Relations to Clone
Name
Sales Stage
Amount
Close Date
Company ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Address
City
Zipcode
Region
Country
Phone
Description
Website
State
External Id
Timezone
Customer Status
Tier
Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Email
Phone
Mobile Phone
Description
Company Name
Title
Opportunity ID
Campaigns
External Id
Timezone
Spiro User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Spiro User
SubjectRequired
Contact ID
Ticket ID
EmailRequired
TypeRequired
Custom Activity Type
Disposition
Interaction Date
Description
Users to Mention
Full Name
Company Name
Phone
Mobile Phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Email
Company Name
Company Address
Company City
Company State
Company Country
Company Zipcode
Company Region
Website
Description
Opportunity Name
Amount
Phone
Mobile Phone
Title
Sales Stage Name
Close Date
Pipeline Name
Sales Stage
Priority
Opportunity Owner Full Name
External Id
Forecast Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reminder DateRequired
ReminderRequired
EmailRequired
Contact Id
Spiro User
Remind Me
Description
Full Name
Company Name
Phone
Mobile Phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Reminder DateRequired
ReminderRequired
Opportunity IdRequired
Spiro User
Remind Me
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Ticket IDRequired
Custom EntityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Resource TypeRequired
Resource IdRequired
FieldsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Full Name
Email
Phone
Mobile Phone
Title
Description
Owner
Campaigns
External Id
Company Id
Timezone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Opportunity Name
Sales Stage
Amount
Close Date
Description
Priority
Spiro User
External Id
Company ID
Forecast Value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Reminder
Reminder Date
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom Entity (Section)Required
Record IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User IDRequired
First Name
Last Name
Title
Phone
Country
Currency
Email Client
Role
Manager
Group
Is Admin?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustom ListRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search Latest First?
ActionThis is an event a Zap performs.SearchFind existing data in your appOpportunity IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search ValueRequired
Company NameRequired
Address
City
Zipcode
Region
Country
Phone
Description
Website
State
External Id
Timezone
Customer Status
Tier
Owner
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Search ValueRequired
Company NameRequired
Company ID
Description
Website
Opportunity Name
Amount
Close Date
Sales Stage Name
Pipeline Name
Sales Stage
Priority
Opportunity Owner Full Name
External Id
Forecast Value
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
