Skip to content
Book a demoStart free
Connectors

RepairShopr connector

Set up the RepairShopr connector in Kaivo: authentication, configuration, the 14 BigQuery tables it syncs, and answers to common questions.

RepairShopr connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your RepairShopr data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your CRM data instead of moving it.

Sync your RepairShopr data into BigQuery with Kaivo to analyse tickets, invoices, and customers in one place.

CategoryCRM, Customer Service
AuthenticationAPI key
SetupSelf-service

Getting started with the RepairShopr connector

Section titled “Getting started with the RepairShopr connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your RepairShopr account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Key.

Field Description
API Key

When you set up the connector, you provide:

Field Description
Subdomain
Your RepairShopr subdomain (e.g. if your account URL is acme.repairshopr.com, enter acme).

|

Tables and columns synced from RepairShopr

Section titled “Tables and columns synced from RepairShopr”

Kaivo syncs 14 tables from RepairShopr into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

appointment types (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
created_at STRING
email_instructions STRING
id FLOAT64
location_hard_code STRING
location_type STRING
name STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
appointments (59 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
all_day BOOL
appointment_location_type STRING
created_at STRING
customer__account_id FLOAT64
customer__address1 STRING
customer__address2 STRING
customer__city STRING
customer__created_at STRING
customer__customer_id FLOAT64
customer__email STRING
customer__extension STRING
customer__id FLOAT64
customer__mobile STRING
customer__name STRING
customer__notes STRING
customer__opt_out BOOL
customer__phone STRING
customer__processed_mobile STRING
customer__processed_phone STRING
customer__properties__direct_report STRING
customer__properties__notification_billing STRING
customer__properties__notification_marketing STRING
customer__properties__notification_reports STRING
customer__properties__title STRING
customer__since_updated_at STRING
customer__state STRING
customer__ticket_matching_emails STRING
customer__updated_at STRING
customer__zip STRING
duration FLOAT64
end_at STRING
id FLOAT64
location STRING
start_at STRING
start_at_label STRING
summary STRING
ticket__billing_status STRING
ticket__child BOOL
ticket__contact_fullname STRING
ticket__created_at STRING
ticket__creator_name_or_email STRING
ticket__customer_business_then_name STRING
ticket__customer_id FLOAT64
ticket__customer_reply BOOL
ticket__due_date STRING
ticket__id FLOAT64
ticket__number FLOAT64
ticket__parent BOOL
ticket__priority STRING
ticket__problem_type STRING
ticket__recurring BOOL
ticket__status STRING
ticket__subject STRING
ticket__updated_at STRING
ticket_id FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body STRING
created_at STRING
hidden BOOL
id FLOAT64
subject STRING
tech STRING
ticket_id FLOAT64
updated_at STRING
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contacts (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
address1 STRING
address2 STRING
city STRING
created_at STRING
customer_id FLOAT64
email STRING
extension STRING
id FLOAT64
mobile STRING
name STRING
notes STRING
opt_out BOOL
phone STRING
processed_mobile STRING
processed_phone STRING
properties__direct_report STRING
properties__notification_billing STRING
properties__notification_marketing STRING
properties__notification_reports STRING
properties__title STRING
since_updated_at STRING
state STRING
ticket_matching_emails STRING
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contracts (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id FLOAT64
apply_to_all BOOL
contract_amount STRING
created_at STRING
customer_id FLOAT64
end_date STRING
id FLOAT64
likelihood FLOAT64
name STRING
primary_contact STRING
start_date STRING
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer assets (62 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
asset_serial STRING
asset_type STRING
created_at STRING
customer__address STRING
customer__address_2 STRING
customer__business_and_full_name STRING
customer__business_name STRING
customer__business_then_name STRING
customer__city STRING
customer__created_at STRING
customer__disabled BOOL
customer__email STRING
customer__firstname STRING
customer__fullname STRING
customer__get_sms BOOL
customer__id FLOAT64
customer__invoice_cc_emails STRING
customer__lastname STRING
customer__mobile STRING
customer__no_email BOOL
customer__notification_email STRING
customer__online_profile_url STRING
customer__opt_out BOOL
customer__phone STRING
customer__properties__notification_billing STRING
customer__properties__notification_marketing STRING
customer__properties__notification_reports STRING
customer__referred_by STRING
customer__state STRING
customer__tax_rate_id FLOAT64
customer__updated_at STRING
customer__zip STRING
customer_id FLOAT64
device_info__snmp_config__version FLOAT64
device_info__snmp_config__community STRING
device_info__snmp_config__enabled BOOL
device_info__snmp_config__port FLOAT64
has_live_chat BOOL
id FLOAT64
name STRING
properties__make STRING
properties__model STRING
properties__service_tag STRING
rmm_store__account_id FLOAT64
rmm_store__asset_id FLOAT64
rmm_store__created_at STRING
rmm_store__id FLOAT64
rmm_store__triggers__agent_offline_triggered STRING
rmm_store__triggers__app_crash_triggered STRING
rmm_store__triggers__bsod_triggered STRING
rmm_store__triggers__defrag_triggered STRING
rmm_store__triggers__device_manager_triggered STRING
rmm_store__triggers__firewall_triggered STRING
rmm_store__triggers__low_hd_space_triggered STRING
rmm_store__triggers__no_av_triggered STRING
rmm_store__triggers__smart_failure_triggered STRING
rmm_store__triggers__time_triggered STRING
rmm_store__updated_at STRING
since_updated_at STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
address_2 STRING
business_and_full_name STRING
business_name STRING
business_then_name STRING
city STRING
created_at STRING
disabled BOOL
email STRING
firstname STRING
fullname STRING
get_sms BOOL
id FLOAT64
invoice_cc_emails STRING
lastname STRING
mobile STRING
no_email BOOL
notification_email STRING
online_profile_url STRING
opt_out BOOL
phone STRING
properties__notification_billing STRING
properties__notification_marketing STRING
properties__notification_reports STRING
referred_by STRING
state STRING
tax_rate_id FLOAT64
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
address1 STRING
address2 STRING
city STRING
created_at STRING
customer_id FLOAT64
email STRING
extension STRING
id FLOAT64
mobile STRING
name STRING
notes STRING
opt_out BOOL
phone STRING
processed_mobile STRING
processed_phone STRING
properties__direct_report STRING
properties__notification_billing STRING
properties__notification_marketing STRING
properties__notification_reports STRING
properties__title STRING
since_updated_at STRING
state STRING
ticket_matching_emails STRING
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
estimates (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
customer_business_then_name STRING
customer_id FLOAT64
date STRING
employee STRING
id FLOAT64
number STRING
status STRING
subtotal STRING
tax STRING
total STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
contact_id FLOAT64
created_at STRING
customer_business_then_name STRING
customer_id FLOAT64
date STRING
due_date STRING
hardwarecost STRING
id FLOAT64
is_paid BOOL
number STRING
po_number STRING
subtotal STRING
tax STRING
tech_marked_paid BOOL
total STRING
updated_at STRING
user_id FLOAT64
verified_paid BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
items (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id FLOAT64
converted BOOL
created_at STRING
id FLOAT64
invoice_id FLOAT64
logistic_state STRING
notes STRING
orderedon STRING
parturl STRING
price STRING
quantity FLOAT64
requestedon STRING
retail_cents FLOAT64
round_trip BOOL
shipping STRING
taxable BOOL
ticket_id FLOAT64
ticketnum FLOAT64
trackingnum STRING
updated_at STRING
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
leads (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address STRING
business_then_name STRING
city STRING
created_at STRING
email STRING
first_name STRING
has_attachments BOOL
id FLOAT64
last_name STRING
message_read BOOL
mobile STRING
phone STRING
state STRING
status STRING
ticket_description STRING
ticket_problem_type STRING
ticket_subject STRING
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
line items (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
cost STRING
created_at STRING
id FLOAT64
invoice_id FLOAT64
item STRING
name STRING
position FLOAT64
price STRING
product_category STRING
quantity STRING
since_updated_at STRING
taxable BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payments (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
applied_at STRING
created_at STRING
customer__address STRING
customer__address_2 STRING
customer__business_and_full_name STRING
customer__business_name STRING
customer__business_then_name STRING
customer__city STRING
customer__created_at STRING
customer__disabled BOOL
customer__email STRING
customer__firstname STRING
customer__fullname STRING
customer__get_sms BOOL
customer__id FLOAT64
customer__invoice_cc_emails STRING
customer__lastname STRING
customer__mobile STRING
customer__no_email BOOL
customer__notification_email STRING
customer__online_profile_url STRING
customer__opt_out BOOL
customer__phone STRING
customer__properties__notification_billing STRING
customer__properties__notification_marketing STRING
customer__properties__notification_reports STRING
customer__referred_by STRING
customer__state STRING
customer__tax_rate_id FLOAT64
customer__updated_at STRING
customer__zip STRING
id FLOAT64
payment_amount FLOAT64
payment_method STRING
ref_num STRING
success BOOL
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
address1 STRING
address2 STRING
city STRING
created_at STRING
customer_id FLOAT64
email STRING
extension STRING
id FLOAT64
mobile STRING
name STRING
notes STRING
opt_out BOOL
phone STRING
processed_mobile STRING
processed_phone STRING
properties__direct_report STRING
properties__notification_billing STRING
properties__notification_marketing STRING
properties__notification_reports STRING
properties__title STRING
since_updated_at STRING
state STRING
ticket_matching_emails STRING
updated_at STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
category_path STRING
condition STRING
desired_stock_level FLOAT64
disabled BOOL
id FLOAT64
maintain_stock BOOL
name STRING
notes STRING
physical_location STRING
price_cost FLOAT64
price_retail FLOAT64
price_wholesale FLOAT64
product_category STRING
quantity FLOAT64
reorder_at FLOAT64
serialized BOOL
since_updated_at STRING
sort_order FLOAT64
taxable BOOL
upc_code STRING
warranty_template_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tickets (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_status STRING
child BOOL
contact_fullname STRING
created_at STRING
creator_name_or_email STRING
customer_business_then_name STRING
customer_id FLOAT64
customer_reply BOOL
due_date STRING
id FLOAT64
number FLOAT64
parent BOOL
priority STRING
problem_type STRING
recurring BOOL
status STRING
subject STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body STRING
created_at STRING
hidden BOOL
id FLOAT64
subject STRING
tech STRING
ticket_id FLOAT64
updated_at STRING
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where RepairShopr supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for RepairShopr?

Section titled “How long does the initial sync take for RepairShopr?”

It depends on how much history is in your RepairShopr account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when RepairShopr’s schema changes?

Section titled “What happens when RepairShopr’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in RepairShopr, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in RepairShopr instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the RepairShopr connector in Kaivo and all of its synced data is deleted with it.

Use tickets to track repair volume and turnaround over time.

Join invoices and payments with customers to track revenue.

Use products and items to monitor parts and stock.

Use RepairShopr data in your AI and BI tools

Section titled “Use RepairShopr data in your AI and BI tools”

Once RepairShopr data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with RepairShopr data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for RepairShopr connector pricing and plan details.

  • Custobar: Sync Custobar to BigQuery.
  • HubSpot: Sync HubSpot to BigQuery.
  • Attio: Sync Attio to BigQuery.
  • Cuuma: Sync Cuuma to BigQuery.
  • Dixa: Sync Dixa to BigQuery.
  • Freshservice: Sync Freshservice to BigQuery.