Skip to content
Book a demoStart free
Connectors

Zoho Invoice connector

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

Zoho Invoice connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Zoho Invoice 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 payment and finance data instead of moving it.

Sync your Zoho Invoice data into BigQuery with Kaivo to analyse invoices, payments, and recurring billing.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Zoho Invoice connector

Section titled “Getting started with the Zoho Invoice connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Zoho Invoice 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 Zoho Invoice credentials. You provide:

Field Description
OAuth Client Secret
The Client Secret of your Zoho Invoice developer application.

| | OAuth Refresh Token |

The refresh token obtained after completing the OAuth authorization flow.

|

Prerequisites

Zoho Invoice only supports OAuth, so you need your own Zoho developer application:

  1. Go to the Zoho API Console, create a Self Client (the simplest option for a data sync), and note your Client ID and Client Secret.
  2. Generate a grant token for the ZohoInvoice.fullaccess.all scope, then exchange it for a Refresh Token (see Zoho OAuth docs). Use the accounts URL for your account’s region, e.g. accounts.zoho.com (US) or accounts.zoho.eu (EU).

Then enter those values below.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
Region
The region where your Zoho Invoice account is hosted.

| | OAuth Client ID |

The Client ID of your Zoho Invoice developer application.

| | Organization ID |

To be provided if a user belongs to multiple organizations.

|

Tables and columns synced from Zoho Invoice

Section titled “Tables and columns synced from Zoho Invoice”

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

contacts (40 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
ach_supported BOOL
company_name STRING
contact_id STRING
contact_name STRING
contact_type STRING
contact_type_formatted STRING
created_time STRING
created_time_formatted STRING
currency_code STRING
currency_id STRING
customer_name STRING
customer_sub_type STRING
email STRING
facebook STRING
first_name STRING
has_attachment BOOL
is_linked_with_zohocrm BOOL
language_code STRING
language_code_formatted STRING
last_modified_time STRING
last_modified_time_formatted STRING
last_name STRING
mobile STRING
outstanding_receivable_amount FLOAT64
outstanding_receivable_amount_bcy FLOAT64
pan_no STRING
payment_terms FLOAT64
payment_terms_label STRING
phone STRING
portal_status STRING
portal_status_formatted STRING
source STRING
status STRING
twitter STRING
unused_credits_receivable_amount FLOAT64
unused_credits_receivable_amount_bcy FLOAT64
vendor_name STRING
website 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.
credit notes (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
applied_invoices STRING
balance FLOAT64
client_viewed_time STRING
color_code STRING
created_time STRING
creditnote_id STRING
creditnote_number STRING
currency_code STRING
currency_id STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
exchange_rate FLOAT64
has_attachment BOOL
is_emailed BOOL
is_viewed_by_client BOOL
last_modified_time STRING
price_precision FLOAT64
reference_number STRING
salesperson_id STRING
salesperson_name STRING
status STRING
template_id STRING
template_type STRING
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer_payments (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
amount FLOAT64
bcy_amount FLOAT64
bcy_refunded_amount FLOAT64
bcy_unused_amount FLOAT64
created_time STRING
custom_fields_list STRING
customer_id STRING
customer_name STRING
date STRING
documents STRING
gateway_transaction_id STRING
has_attachment BOOL
invoice_numbers STRING
last_four_digits STRING
last_modified_time STRING
payment_gateway STRING
payment_id STRING
payment_mode STRING
payment_mode_formatted STRING
payment_number STRING
payment_status STRING
payment_type STRING
product_description STRING
reference_number STRING
settlement_status STRING
tax_amount_withheld FLOAT64
unused_amount FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_payments__applied_invoices

Section titled “Subtable: customer_payments__applied_invoices”
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.
expenses (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_name STRING
bcy_total FLOAT64
bcy_total_without_tax FLOAT64
created_time STRING
currency_code STRING
currency_id STRING
custom_fields_list STRING
customer_id STRING
customer_name STRING
date STRING
distance FLOAT64
end_reading STRING
exchange_rate FLOAT64
expense_id STRING
expense_receipt_name STRING
expense_type STRING
has_attachment BOOL
is_billable BOOL
is_personal BOOL
last_modified_time STRING
mileage_rate FLOAT64
mileage_type STRING
mileage_unit STRING
reference_number STRING
report_id STRING
report_name STRING
report_number STRING
start_reading STRING
status STRING
total FLOAT64
total_without_tax FLOAT64
user_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (77 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
ach_payment_initiated BOOL
adjustment FLOAT64
balance FLOAT64
billing_address__address STRING
billing_address__attention STRING
billing_address__city STRING
billing_address__country STRING
billing_address__fax STRING
billing_address__phone STRING
billing_address__state STRING
billing_address__street2 STRING
billing_address__zipcode STRING
client_viewed_time STRING
color_code STRING
company_name STRING
country STRING
created_by STRING
created_time STRING
currency_code STRING
currency_id STRING
currency_symbol STRING
current_sub_status STRING
current_sub_status_id STRING
customer_id STRING
customer_name STRING
date STRING
documents STRING
due_date STRING
due_days STRING
email STRING
exchange_rate FLOAT64
has_attachment BOOL
invoice_id STRING
invoice_number STRING
invoice_url STRING
is_emailed BOOL
is_pre_gst BOOL
is_viewed_by_client BOOL
is_viewed_in_mail BOOL
last_modified_time STRING
last_payment_date STRING
last_reminder_sent_date STRING
mail_first_viewed_time STRING
mail_last_viewed_time STRING
no_of_copies FLOAT64
payment_expected_date STRING
phone STRING
project_name STRING
reference_number STRING
reminders_sent FLOAT64
salesperson_id STRING
salesperson_name STRING
schedule_time STRING
shipping_address__address STRING
shipping_address__attention STRING
shipping_address__city STRING
shipping_address__country STRING
shipping_address__fax STRING
shipping_address__phone STRING
shipping_address__state STRING
shipping_address__street2 STRING
shipping_address__zipcode STRING
shipping_charge FLOAT64
show_no_of_copies BOOL
status STRING
template_id STRING
template_type STRING
total FLOAT64
transaction_type STRING
unprocessed_payment_amount FLOAT64
updated_time STRING
write_off_amount FLOAT64
zcrm_potential_id STRING
zcrm_potential_name 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.
items (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_time STRING
has_attachment BOOL
image_document_id STRING
image_name STRING
image_type STRING
is_linked_with_zohocrm BOOL
item_id STRING
item_name STRING
last_modified_time STRING
name STRING
product_type STRING
rate FLOAT64
sku STRING
source STRING
status STRING
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
unit STRING
zcrm_product_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recurring_invoices (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
child_entity_type STRING
created_time STRING
customer_id STRING
customer_name STRING
end_date STRING
last_four_digits STRING
last_modified_time STRING
last_sent_date STRING
next_invoice_date STRING
recurrence_frequency STRING
recurrence_name STRING
recurring_invoice_id STRING
reference_number STRING
repeat_every FLOAT64
salesperson_id STRING
salesperson_name STRING
start_date STRING
status STRING
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
taxes (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
diff_rate_reason STRING
end_date STRING
is_default_tax BOOL
is_editable BOOL
is_inactive BOOL
last_modified_time STRING
start_date STRING
status STRING
tax_id STRING
tax_name STRING
tax_percentage FLOAT64
tax_specific_type STRING
tax_specification STRING
tax_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
invitation_type STRING
is_current_user BOOL
is_customer_segmented BOOL
is_employee BOOL
is_super_admin BOOL
is_vendor_segmented BOOL
mobile STRING
name STRING
photo_url STRING
role_id STRING
status STRING
user_id STRING
user_role STRING
user_type 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 Zoho Invoice 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 Zoho Invoice?

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

It depends on how much history is in your Zoho Invoice 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 Zoho Invoice’s schema changes?

Section titled “What happens when Zoho Invoice’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 Zoho Invoice, 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 Zoho Invoice 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 Zoho Invoice connector in Kaivo and all of its synced data is deleted with it.

Use invoices and customer_payments to track billed and collected revenue over time.

Use recurring_invoices to monitor subscription revenue.

Join invoices with contacts to track outstanding balances.

Use Zoho Invoice data in your AI and BI tools

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

Once Zoho Invoice 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 Zoho Invoice 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 Zoho Invoice connector pricing and plan details.