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)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
TriggerScheduledZapier 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 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
Bottom-Up
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
Bottom-Up
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 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.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
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
Full Name
Email
Phone
Mobile Phone
Title
Description
Owner
Campaigns
External Id
Company Id
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
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.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
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 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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Bottom-Up
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?
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.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
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
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
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
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.IdRequired
Company Name
Website
Address
City
State
Zipcode
Region
Country
Phone
Description
Owner
External Id
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
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.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
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
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
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout Spiro
Spiro is an AI-Powered CRM that learns your sales process to increase effectiveness and deliver more accurate business insights.
Related categories
Similar apps
