Skip to content
  • Baresquare logoBaresquare logo
  • Baresquare logoBaresquare logo
  • Google Sheets logoGoogle Sheets logo
  • Baresquare logoBaresquare logo
  • Baresquare logoBaresquare logo
  • Google Sheets logoGoogle Sheets logo

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.

  1. When this happens...
    New Ticket
    New Ticket
    New TicketTriggers when a new ticket is created in Baresquare.
  2. automatically do this...
    Lookup Spreadsheet Row
    Lookup Spreadsheet Row
    Lookup Spreadsheet RowFind a specific spreadsheet row based on a column and value. If found, it returns the entire row.
  3. then do this...
    Find Organization User
    Find Organization User
    Find Organization User Find user by email address. Returns only a single user.
  4. then do this!
    Update Ticket Assignee
    Update Ticket Assignee
    Update Ticket AssigneeUpdates a ticket's assignee by the ticket ID
Start free with email
Start free with email
Google Logo Start free with Google
  • 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
    Trigger
    Polling
    Try It
    • Ticket ID
      Required
    • Label
    Action
    Write
    • Ticket ID
      Required
    • Ticket priority
      Required
    Action
    Write
    • From
    • To
    • Ticket flow
    • Label
    Action
    Search
    • Ticket label
    Trigger
    Polling
    Try It
    • Incident's timestamp
    • Title
      Required
    • Description
    • Labels
    • Flow
    • Granularity
    Action
    Write
    • Ticket ID
      Required
    • New assignee
    Action
    Write
    • User email address
      Required
    Action
    Search
baresquare logo
About Baresquare
Baresquare connects with your current analytics platform to make sense of the trends in your data, surfacing micro insights that could lead to major opportunities. In a sea of data, get your bearings with Baresquare’s action-driven analytics.
Related categories
google-sheets logo
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
Zoho Creator integrationsZoho Creator integrations
Zoho Creator
App Builder, Zoho
Smartsheet integrationsSmartsheet integrations
Smartsheet
Spreadsheets
Quip integrationsQuip integrations
Quip
Documents

Related Zap Templates