Create a duplicate of an existing spreadsheet.

These Headers are ignored if a "Spreadsheet to Copy" is selected.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Use a search step before this to get the row to delete.

Determines which App Extensions will appear in the dropdown below.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet?

Number of rows to return. Max is 500.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Let us know which columns to return. e.g. A:Z

Number of rows to return. Max is 500.

Number of the first row to return (1 is the header)

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

Select the Business for which you would like to look for a new client.

Select the Business for which you would like look for a new expense

Select the Business for which you would like to look for a New Client.

Select the Business for which you would like to look for a New Filtered Invoice.

Select the Business for which you would like to look for a New Payment.

Select the Business for which you would like to look for a New Staff Member.

Select the Business for which you would like look for a new expense

Select the Business for which you would like to Add a Payment to an Invoice.

Defaults to "Check" if left blank.

Select the Business for which you would like to Create an Estimate.

Date estimate was created, YYYY-MM-DD format.

User specified and visible estimate ID. Maximum length of 10 characters.

Name of organization being estimated.

First name of client on estimate.

Last name of client on estimate.

Three-letter currency code for estimate.

Two-letter language code, e.g. "en".

First line of address on estimate.

Post office box number for address on estimate.

Associated estimate number. 0 if none.

User ID of the user who sent the estimate, typically 1 for admin.

Name for the estimate line item(s). To add multiple line items,

Description for the estimate line item(s).

Type for estimate line item, 0 for normal estimate line.

Quantity of the estimate line unit, multiplied against the unit cost.

Unit cost amount, to two decimal places.

Three-letter currency code.

Name for the first tax on the estimate line.

First tax amount, in percentage, up to 3 decimal places.

Name for the second tax on the estimate line.

Second tax amount, in percentage, up to 3 decimal places.

Select the Business for which you would like to Create an Invoice.

Like USD, CAD, etc.

Please choose a date for this invoice. If left blank, the current date will be used.

Adds days to date of issue to set due date. If left blank, the due date will be the same as the date of issue.

Is this invoice paid.

Percent amount being discounted from the subtotal, decimal-string amount ranging from 0 to 100.

Public note about discount.

Reference number for address on invoice.

Two-letter language code, e.g. "en".

Select the Business for which you would like to Create an Invoice.

String amount of the income, to two decimal places.

Three-letter currency code for amount.

Amount of the tax, to two decimal places.

Name of the tax.

The date the income was received, YYYY-MM-DD format.

Optional type of payment made. "Check", "Credit", "Cash", etc.

E.g. Shopify, Etsy, Farmers' Market

Select the Business for which you would like to create a recurring invoice.

Like USD, CAD, etc.

Please choose a date for this invoice. If left blank, the current date will be used.

Adds days to date of issue to set due date. If left blank, the due date will be the same as the date of issue.

Percent amount being discounted from the subtotal, decimal-string amount ranging from 0 to 100.

Public note about discount.

Reference number for address on invoice.

Two-letter language code, e.g. "en".

How often to send the invoice.

Select the Business for which you would like to Send an Estimate.

Notice this field takes plain-text only.

Select the Business for which you would like to Create a Client.

Select Yes if you would like to create the client if they do not exist in the system.

The date the credit note is created for.

Select the Business for which you would like to Find a Customer.

Choose a field to search upon.

Select the Business for which you would like to Create a Client.

Choose a field to search upon.

The date the credit note is created for.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If a worksheet with the specified title exists, its content would be lost. Please, use with caution.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.

True if the text is bold.

True if the text is italicized.

True if the text is strikethrough.

API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest

Requests can only be made to domains associated by this application.

These params will be URL-encoded and appended to the URL when making the request.

Authentication headers are included automatically

Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

Value of the Worksheet Title to match exactly. Search is case-sensitive.

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

You must have column headers. See here for more information.

Specify the column we should search for cells which match the Lookup Value.

Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)

An example value might be me@example.com or 555-5555

Search from bottom of the sheet? In other words, pick the most recent match?

Select the Business for which you would like look for a new expense

Select the Business for which you would like to look for a new invoice.

Select the Business for which you would like to look for a New Expense.

Select the Business for which you would like to look for a New Invoice.

Select the Business for which you would like to Add a Payment to an Invoice.

Select the Business for which you would like to look for a new payment.

Select the Business for which you would like look for a new expense

Select the Business for which you would like to Add a Payment to an Invoice.

Select the Business for which you would like to Create a Client.

The date the credit note is created for.

Select the Business for which you would like to Create an Expense.

Tax1 amount for expense. If used Tax1 Name and Tax Currency are required. If used with Tax1 Percent Tax1 Amount will not be used in favor of Tax1 Percent

Tax1 percent for expense. If used Tax1 Name and Tax Currency are required. If used with Tax1 Amount Tax1 Percent will be used to calculate amount

Required if there is a Tax1 Amount

Tax amount for expense. If used Tax2 Name and Tax Currency are required. If used with Tax2 Percent Tax2 Amount will not be used in favor of Tax2 Percent

Required if there is a Tax2 Amount

Tax2 percent for expense. If used Tax2 Name and Tax Currency are required. If used with Tax2 Amount Tax2 Percent will be used to calculate amount

Required if Tax2 is used, is Tax2 a compound tax?

Note of percent to mark expense up.

Select the Business for which you would like to Create an Invoice PDF.

Select the Invoice for which you would like to create a PDF.

Select the Business for which you would like to Create a Project.

Fixed price used for flat rate projects

Hourly rate for hourly projects.

Select the Business for which you would like to Create an Expense.

Duration of the time entry in seconds. Decimal values will result in an error

Select the Business for which you would like to Send an Invoice.

Notice this field takes plain-text only.

Select the Business for which you would like to Update an Invoice.

This will only be used if Create if Invoice Does Not Exist is yes.

Select Yes if you would like to create the invoice if it does not exist in the system.

Select Yes if you would like to append line items on update. Default is to replace line items on update

Like USD, CAD, etc.

Adds days to assigned date to set due date. Due date will be the date of issue if left blank.

Enter the full invoice number.

Select the Business for which you would like to Find an invoice.

Choose a field to search upon.

If you are searching by "Invoice Number" please include all prepending zeros. For example, instead of entering "10", you'd need to enter "0000010".

Select the Business for which you would like to Create an Invoice.

Choose a field to search upon.

If you are searching by "Invoice Number" please include all prepending zeros. For example, instead of entering "10", you'd need to enter "0000010".

Like USD, CAD, etc.

Please choose a date for this invoice. If left blank, the current date will be used.

Adds days to date of issue to set due date. If left blank, the due date will be the same as the date of issue.

Is this invoice paid.

Percent amount being discounted from the subtotal, decimal-string amount ranging from 0 to 100.

Public note about discount.

Reference number for address on invoice.

Two-letter language code, e.g. "en".