Connect Google Sheets and Houzz Pro

Both apps 193Google Sheets 62Houzz Pro 131

• Trigger
  Aggregate Metric Changed

  Fires when an aggregate metric (sum/avg/count/…) over a column changes.

• Trigger
  Cell Range Values Changed

  Fires when the values in a specific cell range change.

• Trigger
  Conditional Format Rule Changed

  Fires when a conditional-format rule changes.

• Trigger
  Data Validation Rule Changed

  Fires when a data-validation rule changes.

• Trigger
  Developer Metadata Changed

  Fires when developer metadata changes.

• Trigger
  Filtered Range Values Changed

  Fires when the values in a filtered range change.

• Trigger
  New Rows

  Fires when new rows are appended to a Google Sheet.

• Trigger
  New Sheet Added

  Fires when a new sheet (tab) is added to a spreadsheet.

• Trigger
  New Spreadsheet Created

  Fires when a new spreadsheet is created in the account.

• Trigger
  Spreadsheet Metadata Changed

  Fires when spreadsheet metadata changes.

• Trigger
  Spreadsheet Properties Changed

  Fires when spreadsheet properties change.

• Trigger
  Spreadsheet Row Changed

  Fires when a row matching a query changes.

• Trigger
  Spreadsheet Search Match

  Fires when a spreadsheet matching search criteria is found.

• Trigger
  Table Query Result Changed

  Fires when the result of a SQL-style table query changes.

• Trigger
  Table Schema Changed

  Fires when a table's column schema changes.

• Trigger
  Worksheet Names Changed

  Fires when worksheet (tab) names change.

• Action
  Add Row

  Append a row to a Google Sheet

• Action
  Aggregate Column Data

  Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).

• Action
  Auto-Resize Rows or Columns

  Auto-fit row heights or column widths over an index range via autoResizeDimensions.

• Action
  Change Sheet Properties

  Update a worksheet's grid properties (row/column count) using an explicit field mask.

• Action
  Clear Basic Filter

  Remove the basic filter from a sheet via clearBasicFilter.

• Action
  Clear Spreadsheet Row(s)

  Clear the values in a range (formatting preserved).

• Action
  Copy Range

  Copy a source cell range to a destination range within the spreadsheet.

• Action
  Copy Worksheet

  Copy a worksheet into a destination spreadsheet.

• Action
  Create Chart

  Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.

• Action
  Create Conditional Formatting Rule

  Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.

• Action
  Create Multiple Spreadsheet Rows

  Append many rows in one call.

• Action
  Create Spreadsheet

  Create a new Google Sheets spreadsheet with the given title.

• Action
  Create Spreadsheet Column

  Insert a blank column at a given index.

• Action
  Create Spreadsheet Row

  Append a single row of values to a sheet range.

• Action
  Create Spreadsheet Row at Top

  Insert a blank row just below the header (row 2), then write the given values into it in one operation.

• Action
  Create Worksheet

  Add a new worksheet (tab) to an existing spreadsheet.

• Action
  Delete Chart

  Delete an embedded chart via deleteEmbeddedObject.

• Action
  Delete Sheet

  Delete a worksheet from a spreadsheet by sheetId (gid).

• Action
  Delete Spreadsheet Row(s)

  Delete a contiguous block of rows by index.

• Action
  Find and Replace

  Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).

• Action
  Find Spreadsheet

  Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).

• Action
  Find Worksheet

  Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.

• Action
  Format Cell Range

  Apply background color and bold formatting to a cell range via repeatCell.

• Action
  Format Spreadsheet Row

  Apply a background color across an entire row via repeatCell over a row range.

• Action
  Get Conditional Format Rules

  List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).

• Action
  Get Data Range

  Read all values in one or more ranges via batchGet.

• Action
  Get Data Validation Rules

  Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).

• Action
  Get Many Spreadsheet Rows (Advanced)

  Read multiple ranges at once via batchGet.

• Action
  Get Row by ID

  Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.

• Action
  Get Sheet Names

  Return the titles of all sheets (tabs) in the spreadsheet.

• Action
  Get Spreadsheet by ID

  Fetch spreadsheet metadata (title, sheets, gids, grid properties).

• Action
  List Charts

  List all embedded charts (chartId + title) across every sheet in the spreadsheet.

• Action
  Lookup Spreadsheet Row

  Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Lookup Spreadsheet Rows (Advanced)

  Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).

• Action
  Move Chart

  Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.

• Action
  Rename Sheet

  Rename a worksheet's title.

• Action
  Search Spreadsheets

  Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.

• Action
  Set Basic Filter

  Apply a basic filter to a range on a sheet via setBasicFilter.

• Action
  Set Data Validation

  Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.

• Action
  Sort Range

  Sort a cell range by one column in ascending or descending order.

• Action
  Update Chart

  Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.

• Action
  Update Conditional Format Rules

  Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.

• Action
  Update Data Validation Rule

  Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).

• Action
  Update Spreadsheet Row

  Overwrite the values at a specific range.

• Action
  Update Spreadsheet Row(s)

  Update one or more disjoint ranges in a single batch.

• Action
  Upsert Row

  Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).

• Trigger
  New Change Order

  Triggers when a new change order is created in Houzz Pro.

• Trigger
  New Contact

  Triggers when a new contact is created in Houzz Pro.

• Trigger
  New Daily Log

  Triggers when a new daily log is created in Houzz Pro.

• Trigger
  New Estimate

  Triggers when a new estimate is created in Houzz Pro.

• Trigger
  New Expense

  Triggers when a new expense is created in Houzz Pro.

• Trigger
  New Invoice

  Triggers when a new invoice is created in Houzz Pro.

• Trigger
  New Lead

  Triggers when a new lead is created in Houzz Pro.

• Trigger
  New Project

  Triggers when a new project is created in Houzz Pro.

• Trigger
  New Purchase Order

  Triggers when a new purchase order is created in Houzz Pro.

• Trigger
  New Subcontractor

  Triggers when a new subcontractor is created in Houzz Pro.

• Trigger
  New Time Track

  Triggers when a new time track is created in Houzz Pro.

• Trigger
  New Vendor

  Triggers when a new vendor is created in Houzz Pro.

• Action
  Archive File

  Archives a file. Unarchive restores it.

• Action
  Archive Note

  Archives the note, removing it from the default list. Archiving is how a note is removed.

• Action
  Archive Vendor

  Archives the vendor, which hides it from lists that filter on archived=false. The vendor and its links are kept, and unarchive restores it.

• Action
  Convert Lead to Project

  Creates a project from this lead and marks the lead Won. The lead must be in status Won or Current and must not already be converted.

• Action
  Create Custom Field

  Create a custom field definition for a given entity type.

• Action
  Create Lead Note

  Adds a note to the project or lead in the path. The source defaults to "api" when you do not send one.

• Action
  Create Project Note

  Adds a note to the project or lead in the path. The source defaults to "api" when you do not send one.

• Action
  Create Subcontractor

  Creates a subcontractor and sends an invitation to the provided email address. Returns the new subcontractor.

• Action
  Create Team Member

  Invites a person to the account by email. Only the email is required; an optional role and invitation note can be included.

• Action
  Create Vendor

  Creates a vendor for the company. Only companyName is required.

• Action
  Delete Contact

  Deletes a contact.

• Action
  Delete Contact Group

  Archives a contact group rather than removing it permanently. Returns deleted: true on success.

• Action
  Delete Contact Group Contact

  Removes a contact from the group without deleting the contact itself. Returns deleted: true on success.

• Action
  Delete Daily Log

  Deletes the daily log.

• Action
  Delete File

  Deletes a file. To keep it but set it aside, archive it instead.

• Action
  Delete Lead

  Deletes the lead. To take a lead out of the active pipeline without deleting it, retire it instead.

• Action
  Delete Milestone

  Deletes a milestone.

• Action
  Delete Project

  Deletes the project. To hide a project without deleting it, update it with archived set to true instead.

• Action
  Delete Subcontractor

  Deactivates a subcontractor instead of removing them permanently. Returns deleted: true on success.

• Action
  Delete Task

  Deletes a task.

• Action
  Delete Team Member

  Deactivates the team member; the person is not permanently removed from the account.

• Action
  Generate Income Payments Report

  Starts generating the report and returns its ID with status pending. Poll the report status until it is completed, then fetch the results. Array filters accept at most 1000 values.

• Action
  Generate Payouts Report

  Starts generating the report and returns its ID with status pending. Poll the report status until it is completed, then fetch the results. Array filters accept at most 1000 values.

• Action
  Get Catalog Item

  Assemblies need the assemblies feature on the company plan: without it they are left out of the list and get returns 404. Returns 403 for companies not on the new catalog experience.

• Action
  Get Category

  Requires the categories feature on the company plan; without it every request returns 403.

• Action
  Get Change Order

  Returns the full change order, including the recipients, attachmentFileIds and totalApplied that list rows omit.

• Action
  Get Contact

  Returns a single contact with its address, tags, contact group, and custom field entries.

• Action
  Get Contact Group

  Returns a single contact group with the contacts linked to it and each contact's level.

• Action
  Get Cost Code

  Requires the cost codes feature on the company plan; without it every request returns 403.

• Action
  Get Daily Log

  Returns a single daily log with its content, dates and the project it belongs to.

• Action
  Get Entity by Custom Field Value

  Resolve the entity whose custom field named `fieldName` holds `value`. Requires the read scope for the requested entityType — a token without it receives no data.

• Action
  Get Estimate

  Returns the full estimate, including recipients, attachments and totals for payments and linked change orders, invoices and purchase orders.

• Action
  Get Expense

  Returns one expense with its project, team member, service, cost code, category, vendor, payment method, the invoice line it was billed on, and its receipt files.

• Action
  Get Expense Documents Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Expense Documents Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Expense Payments Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Expense Payments Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get File

  Returns a single file or folder within the context given by contextId and contextType, including a download URL for files.

• Action
  Get Income Documents Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Income Documents Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Income Payments Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Income Payments Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Invoice

  Returns the full invoice, including the file, recipients and attachmentFileIds that list rows omit.

• Action
  Get Lead

  Returns a single lead with its phase, source, contact, addresses and custom field entries. The project ID is populated once the lead has been converted.

• Action
  Get Milestone

  Returns a single milestone with its dates, status, type, parent and the number of tasks linked to it.

• Action
  Get Note

  Returns a single note, including its container, owner and archived state.

• Action
  Get Open Invoices Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Open Invoices Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Payouts Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Payouts Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Profitability Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Profitability Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Project

  Returns a single project with its status, contact, owner, addresses and custom field entries.

• Action
  Get Project Punchlist

  Returns the project's punchlist. Use its id to update it or to list its tasks.

• Action
  Get Purchase Order

  Returns the full purchase order, including the recipients and attachmentFileIds that list rows omit.

• Action
  Get Sales Tax

  Returns one sales tax with its components. Archived sales taxes can be fetched by ID.

• Action
  Get Selections Board

  Returns one selections board with its project and, for an allowance board, the allowance that sets its budget.

• Action
  Get Subcontractor

  Returns a single subcontractor with company details, trades, address, and status.

• Action
  Get Task

  Returns a single task with its completion state, due date, visibility, and the project or lead and milestone it belongs to.

• Action
  Get Tax Liability Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Tax Liability Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Team Member

  Returns a single team member with their role, status and contact details.

• Action
  Get Time Entries Report Results

  Returns the report data. Responds 409 REPORT_NOT_READY while the report is pending and 409 REPORT_FAILED if generation failed. Results are kept for 1 hour after the report is generated.

• Action
  Get Time Entries Report Status

  Returns the generation status. Status is kept for 15 minutes after the report is generated.

• Action
  Get Time Track

  Returns one time track with its project, team member, activity or service, cost code, the invoice or request payment line it was billed on, and its clock segments.

• Action
  Get Vendor

  Returns the full vendor record, including contact details, payment terms, tags and custom field entries. Works for archived vendors too.

• Action
  List Assignee Candidates

  Who can be assigned to an entity. Use before Add assignees.

• Action
  List Assignee Filter Options

  The distinct assignees across the given entities, for building an assignee filter.

• Action
  List Catalog Items

  Ordered by creation time, oldest first. Assemblies need the assemblies feature on the company plan: without it they are left out of the list and get returns 404. Returns 403 for companies not on the new catalog experience.

• Action
  List Categories

  Ordered by ID. Archived categories are left out unless includeArchived=true. Requires the categories feature on the company plan; without it every request returns 403.

• Action
  List Change Orders

  Sorted by updatedAt descending, then id descending. To sync changes, page with updatedAfter set to your last checkpoint. List rows omit recipients, attachmentFileIds and totalApplied; fetch a single change order for those.

• Action
  List Contact Groups

  Filter by contactGroupType or archived.

• Action
  List Contacts

  Search by name, email, or phone via searchText.

• Action
  List Cost Codes

  Ordered by code. Archived cost codes are left out unless includeArchived=true. Requires the cost codes feature on the company plan; without it every request returns 403.

• Action
  List Custom Field Definitions

  Filter by customableType

• Action
  List Custom Field Entries

  List the custom field entry values stored on a single entity.

• Action
  List Daily Logs

  Returns all daily logs, optionally filtered by projectId. Filtering by date range is not supported.

• Action
  List Estimates

  Sorted by updatedAt descending, then id descending. To sync changes, page with updatedAfter set to your last checkpoint. List rows omit file, recipients, attachmentFileIds, totalApplied, totalRequested, paymentDue and the linked-document totals; fetch a single estimate for those.

• Action
  List Expenses

  Returns expenses, newest created first. Filter by projectId, houzzUserId, billable, taxable, syncToQb, referenceNumber, or an inclusive date range. startDate and endDate are YYYY-MM-DD and must be sent together.

• Action
  List Files

  Lists the files and folders owned by the entity given by contextId and contextType. Returns root-level items unless parentId names a folder, and each file includes a download URL.

• Action
  List Invoices

  Sorted by updatedAt descending, then id descending. To sync changes, page with updatedAfter set to your last checkpoint. List rows omit file, recipients and attachmentFileIds; fetch a single invoice for those.

• Action
  List Lead Milestones

  Additional filtering is not supported.

• Action
  List Lead Notes

  Returns active notes by default. Pass archived=true to return archived notes instead.

• Action
  List Lead Phases

  Returns the pipeline phases available to the account, the values accepted by a lead's phaseId field.

• Action
  List Leads

  Returns leads, optionally filtered by contact or pipeline phase.

• Action
  List Lead Tasks

  Additional filtering (e.g. by completion state or due date) is not supported.

• Action
  List Project Milestones

  Additional filtering is not supported.

• Action
  List Project Notes

  Returns active notes by default. Pass archived=true to return archived notes instead.

• Action
  List Projects

  Archived projects are included unless you explicitly pass archived=false.

• Action
  List Project Statuses

  Returns the values accepted by a project's statusId field, including account-specific custom statuses.

• Action
  List Project Tasks

  Additional filtering (e.g. by completion state or due date) is not supported.

• Action
  List Project Types

  Returns the account's custom project types, the values accepted by a project's projectType field.

• Action
  List Punchlist Tasks

  Additional filtering (e.g. by completion state or due date) is not supported.

• Action
  List Purchase Orders

  Sorted by updatedAt descending, then id descending. To sync changes, page with updatedAfter set to your last checkpoint. List rows omit recipients and attachmentFileIds; fetch a single purchase order for those.

• Action
  List Sales Taxes

  Ordered by creation time, oldest first. Archived sales taxes are left out unless includeArchived=true.

• Action
  List Sections on a Selections Board

  Returns sections for the given selections board, ordered by position.

• Action
  List Selections Boards

  Returns selections boards for the company, ordered by position. Pass projectId to limit the list to one project.

• Action
  List Subcontractors

  Search by name, email, phone, company, or trade via the query param.

• Action
  List Subcontractor Trades

  Returns the trades a subcontractor can be assigned. Use the returned IDs in subInfo.trades when creating or updating a subcontractor.

• Action
  List Team Members

  Search by name, email, or phone via the query param.

• Action
  List the Items of an Assembly

  Ordered by position. Returns 404 when the catalog item is not an assembly, or when the company plan does not include assemblies. Returns 403 for companies not on the new catalog experience.

• Action
  List the Line Items of a Change Order

  Sorted by id ascending. Returns 404 when the change order does not exist.

• Action
  List the Line Items of an Estimate

  Sorted by id ascending. Returns 404 when the estimate does not exist.

• Action
  List the Line Items of an Invoice

  Sorted by id ascending. Returns 404 when the invoice does not exist.

• Action
  List the Line Items of a Purchase Order

  Sorted by id ascending. Returns 404 when the purchase order does not exist.

• Action
  List Time Tracks

  Returns time tracks, newest created first. Filter by projectId, houzzUserId, approvalStatus, or an inclusive work-date range. startDate and endDate are YYYY-MM-DD and must be sent together.

• Action
  List Vendors

  Filter by companyName, archived, or tags. Archived vendors are included unless you explicitly pass archived=false.

• Action
  List what an Assignee is Assigned to

  The projects, leads, tasks and milestones one assignee is assigned to, grouped by type.

• Action
  Reactivate Lead

  Restores a retired lead to an active status. Clients archived by the original retire are not unarchived.

• Action
  Retire Lead

  Archives this lead. Clients that are no longer referenced by another live lead or project are archived along with it, and reactivating the lead does not unarchive them. Won leads cannot be retired.

• Action
  Unarchive File

  Restores an archived file.

• Action
  Unarchive Vendor

  Restores an archived vendor so it appears in active vendor lists again.

• Action
  Update Contact Group

  Updates a contact group's name, type, or archived state and returns the updated group. Use archived to archive or restore a group.

• Action
  Update Contact Group Contact

  Changes a contact's level within the group and returns the updated contact group.

• Action
  Update Note

  Updates only the fields you send; the note stays attached to its project or lead.

• Action
  Update Project

  Updates only the fields you send. Addresses are upserted: include an address id to update it, omit the id to add a new address. Set archived to hide or restore the project.

• Action
  Update Punchlist

  Updates a punchlist's visibility and returns the updated punchlist.

• Action
  Update Team Member

  Updates only the fields you send, including the team member's role and contact details.

• Action
  Update Vendor

  Updates only the fields you send; omitted fields keep their current values.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.