Connect Google Sheets and Square to unlock the power of automation

Creates a new worksheet by copying an existing worksheet.

Creates a new worksheet in a Google Sheet.

Update a row in a specific spreadsheet.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a worksheet by title.

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Finds or creates a specific lookup row.

Triggers when a new catalog item is created.

Triggers when a new invoice is added.

Triggers when a new payment is created.

Creates a new appointment.

Creates a customer.

Creates an externally paid and completed order.

Removes a customer from a group.

Updates a customer.

Finds a customer based on their unique Square ID.

Finds an order based on customer, fulfillment status, or order state.

Find an order. Optionally, create one if none are found.

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Update one or more rows in a specific spreadsheet (with line item support).

Find up to 500 rows based on a column and value as line items.

Return up to 1,500 rows as a single JSON value or as line items.

Finds or creates a specific find worksheet.

Triggers when a new order is processed.

Adds a customer to a group.

Adjusts an inventory or changes its physical count.

Creates a new draft invoice for an order.

Refunds a completed payment.

Sends an existing draft invoice.

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

Finds a customer based on email, phone number, or reference ID.

Finds a service.

Find a customer. Optionally, create one if none are found.