How to connect LiveChat + Google Sheets + Spiro
Zapier lets you send info between LiveChat and Google Sheets and Spiro automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with LiveChat + Google Sheets + Spiro
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with LiveChat, Google Sheets, and Spiro. And don’t forget that you can add more apps and actions to create complex workflows.
Chat Changed
Triggers when the tag list for a particular chat was changed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Chat
Triggers when the chat is started.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Visitor in Queue
Triggers when a visitor enters queue.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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 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
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
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.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
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
Finished Chat
Triggers when the chat is ended.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Ticket
Triggers when the ticket is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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 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
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
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
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
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.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
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How LiveChat + Google Sheets + Spiro Integrations Work
- Step 1: Authenticate LiveChat, Google Sheets, and Spiro.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.