Connect Google Sheets and Zoho Books

Use Google Sheets and Zoho Books in the same FlowMattic workflow. Below are the triggers and actions both integrations offer; pick one of each to see how the two connect.

Try FlowMattic free See triggers and actions

19 triggers 112 actions 1 ready-made template Unlimited runs

Try a pairing

When this happens in Google Sheets6 triggers

Do this in Zoho Books93 actions

1. TriggerNew Spreadsheet Row

2. ActionAdd Attachment To Invoice

When Google Sheets fires New Spreadsheet Row, FlowMattic runs Add Attachment To Invoice in Zoho Books with the data from that event.

You build this in the FlowMattic workflow builder on your own site.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Zoho Books

Integration page

Triggers (13)

New BillTriggers when a new bill is created.
New Credit NoteTriggers when a new credit note is created.
New CustomerTriggers when a new customer is created.
New Customer PaymentTriggers when a new customer payment is recorded.
New EstimateTriggers when a new estimate is created.
New ExpenseTriggers when a new expense is created.
New InvoiceTriggers when a new invoice is created.
New ItemTriggers when a new item is created.
New ProjectTriggers when a new project is created.
New Recurring ExpenseTriggers when a new recurring expense is created.
New Recurring InvoiceTriggers when a new recurring invoice is created.
New TimesheetTriggers when a new time entry / timesheet is created.
New VendorTriggers when a new vendor is created.

Actions (93)

Add Attachment To InvoiceAdds an attachment to an invoice (PDF, image, etc).
Add Item to BillAppend a single line item to an existing bill.
Add Item to Credit NoteAppend a single line item to an existing credit note.
Add Item to Delivery ChallanAppend a single line item to an existing delivery challan.
Add Item to EstimateAppend a single line item to an existing estimate.
Add Item to InvoiceAppend a single line item to an existing invoice.
Add Item to Purchase OrderAppend a single line item to an existing purchase order.
Add Item to Recurring BillAppend a single line item to an existing recurring bill template.
Add Item to Recurring InvoiceAppend a single line item to an existing recurring invoice template.
Add Item to Sales OrderAppend a single line item to an existing sales order.
Add Item to Vendor CreditAppend a single line item to an existing vendor credit.
Create BillCreates a new bill.
Create ContactCreates a new customer or vendor.
Create Contact PersonCreates a new contact person under an existing contact.
Create Credit NoteCreates a credit note.
Create Delivery ChallanCreates a delivery challan (India-specific shipping document).
Create EmployeeCreates an employee for an expense.
Create EstimateCreates a new estimate.
Create ExpenseCreates a new expense.
Create ItemCreates an item.
Create JournalCreates a manual journal entry with balanced debit / credit lines.
Create PaymentCreates a customer payment or changes the status of the invoice.
Create Purchase OrderCreates a purchase order.
Create Recurring BillCreates a recurring bill template that auto-generates bills on a schedule.
Create Recurring ExpenseCreates a recurring expense template that auto-generates expense entries on a schedule.
Create Recurring InvoiceCreates a recurring invoice template that auto-generates invoices on a schedule.
Create Sales InvoiceCreates a sales invoice with line items.
Create Sales Invoice (Legacy)Creates a sales invoice with line items using the legacy "use the customer's contact persons as recipients" shape.
Create Sales OrderCreates a new sales order with line items.
Create Vendor CreditCreates a vendor credit (credit note issued by a vendor) with line items.
Create Vendor PaymentCreates a vendor payment, optionally applied to bills.
Delete ContactDelete a specific contact.
Delete EmployeeDelete a specific employee.
Delete EstimateDelete a specific estimate.
Delete ExpenseDelete a specific expense.
Delete InvoiceDelete a specific invoice.
Delete ItemDelete a specific item.
Mark Item ActiveActivate a previously-inactive item.
Mark Item InactiveDeactivate an item (it stays in reports but is hidden from new transactions).
Email InvoiceEmail an invoice to the customer.
Find BillGet specific bill(s) based on search text.
Find CustomerGet specific customer(s) based on search text.
Find InvoiceFinds an invoice by search text or invoice number.
Find or Create ContactLook up a contact by name or email; create it if no match is found.
Find VendorGet specific vendor(s) based on search text.
Get Contact By IDGet a specific contact detail.
Get Contact Address DetailsRetrieves all addresses for a contact.
Get Contact by EmailGet contact details by email address.
Get Contact by Phone NumberGet contact details by phone number.
Get Contact PersonGet a specific contact person detail.
Get Contact Person by Contact IDList all contact persons under a specific contact.
Get BillGet a specific bill detail.
Get Credit NoteGet a specific credit note detail.
Get Credit Note RefundGet a specific credit note refund.
Get Delivery ChallanGet a specific delivery challan detail.
Get EmployeeGet a specific employee detail.
Get EstimateGet a specific estimate detail.
Get ExpenseGet a specific expense detail.
Get InvoiceGet a specific invoice detail.
Get ItemGet a specific item detail.
Get Item by NameGet a specific item detail by name.
Get Purchase OrderGet a specific purchase order detail.
Get Record by IDPower-user escape hatch: fetch any record by ID and module slug.
Get Recurring BillGet a specific recurring bill detail.
Get Recurring InvoiceGet a specific recurring invoice detail.
Get Sales OrderGet a specific sales order detail by ID.
Get Sales Order by NumberRetrieves sales order details by salesorder_number.
Get Vendor CreditGet a specific vendor credit detail.
List Active AccountsRetrieves the list of active Chart-of-Accounts entries.
List Bill PaymentsList the payments applied to a specific bill.
List Contact PersonsList all contact persons across the organization.
List ContactsList contacts, optionally filtered by type or status.
List CurrenciesList all currencies configured for the organization.
List EstimatesList estimates.
List ExpensesList expenses.
List InvoicesList invoices, optionally filtered by status or customer.
List ItemsList items.
List All LocationsList all locations configured in your Zoho Books organization.
List OrganizationsList all Zoho Books organizations accessible by the connected account.
List Customer PaymentsList customer payments.
Mark Invoice as SentFlip an invoice from Draft to Sent.
Update BillUpdates the existing bill by bill ID.
Update ContactUpdates an existing customer or vendor.
Update Contact PersonUpdates an existing contact person.
Update EstimateUpdates an existing estimate.
Update ExpenseUpdates an existing expense.
Update ItemUpdates an existing item.
Update PaymentUpdates an existing customer payment.
Update Purchase OrderUpdates an existing purchase order.
Update Sales InvoiceUpdates an existing sales invoice.
Update Sales OrderUpdates existing sales order with line items.
Update Vendor PaymentUpdates an existing vendor payment.
Void InvoiceVoid an invoice by ID.