Baresquare + Baresquare + Google Sheets
Baresquare + Baresquare + Google Sheets
Baresquare + Baresquare integrations
Assign new Baresquare tickets from rules in Google Sheets rows
Use a set of rules in a Google Sheets (e.g. tickets referring to paid search get assigned to user xyz@company.com) to assign new Baresquare tickets. For every new ticket, the Zap will look up the ticket details in the Google Sheets rule set to identify the correct assignee's email address. Then, this template will look up the user ID in Baresquare and finally assign the Baresquare ticket to that user.
- When this happens...New TicketTriggers when a new ticket is created in Baresquare.
- automatically do this...Lookup Spreadsheet RowFind a specific spreadsheet row based on a column and value. If found, it returns the entire row.
- then do this...Find Organization User Find user by email address. Returns only a single user.
- then do this!Update Ticket AssigneeUpdates a ticket's assignee by the ticket ID
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Baresquare and Google Sheets
Discover other triggers and actions you can use with Baresquare and Google Sheets
- From
- To
- Ticket flow
- Label
Try ItTriggerPolling- Ticket IDRequired
- Label
ActionWrite- Ticket IDRequired
- Ticket priorityRequired
ActionWrite- From
- To
- Ticket flow
- Label
ActionSearch
- Ticket label
Try ItTriggerPolling- Incident's timestamp
- TitleRequired
- Description
- Labels
- Flow
- Granularity
ActionWrite- Ticket IDRequired
- New assignee
ActionWrite- User email addressRequired
ActionSearch
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Create Baresquare tickets from new rows in Google Sheets
- Send channel messages in Microsoft Teams for new Baresquare tickets
- Get SMS notifications for new urgent Baresquare tickets
- Send Google Analytics reports for new Baresquare tickets via Gmail
- Create Baresquare tickets from new Google Forms responses






