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.

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?

Specifies the vendor for this bill.

Amount of the line item.

Quantity of the line item.

Unit Price of the line item.

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

Specifies the customer associated with the bill.

Specifies the vendor for this bill.

If a line item is billable, please use the Customer field to specify which customer.

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

If not set, Full Name will be used here.

Only available if multicurrency is enabled.

Choose a Parent Customer if you're creating a Job/sub-customer.

If no, this customer will be billed.

Is the payee a Vendor, Customer, or Employee?

Defaults to today's date if not specified.

Will be used as check number if payment type is check.

Only applicable if payment type is check.

You must enter an amount here or in the "Amount" field under "Item Details."

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

You must enter an amount here or in the "Amount" field under "Account Details."

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

Defaults to today's date if not specified.

Total amount of "Debits" line items must equal the total amount of "Credits" line items.

Only available if your preferences allow tracking of department.

Total amount of "Credits" line items must equal the total amount of "Debits" line items.

Only available if your preferences allow tracking of department.

Only available if multicurrency is enabled. Defaults to your home currency if left blank.

Only available if multicurrency is enabled.

Select a specific customer, or, use the below field to look up a customer on demand.

If you just have access to the customer's name or email, use this.

Should not include tax.

Should not include tax.

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

Will be added as a Discount Line item. The company preference Sales Form Entry | Discounts must be enabled.

A.K.A. Income Account

Only available if multicurrency is enabled.

The number of home currency units it takes to equal one unit of currency specified above. Only available if multicurrency is enabled.

Only available if class tracking is enabled and assigned using the "one to entire transaction" option.

Requires choosing a Tax Code above.

Method in which tax is applied.

Only available if your preferences allow tracking of department.

Address to which the payment should be sent.

Address to which the vendor shipped or will ship goods associated with purchase.

You must enter an amount here or in the "Amount" field under "Item Details."

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

You must enter an amount here or in the "Amount" field under "Account Details."

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

For internal use. Will not appear on purchase order to vendor

Send to an explicit email address instead of the invoice billing one, and updates the one on the invoice to this.

Is this for an Employee or Vendor?

Should not include tax.

Should not include tax.

Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.

Requires choosing a Tax Code above.

Method in which tax is applied.

Discount values must be positive (e.g. .10 for a 10% discount)

Only available if class tracking is enabled and assigned using the "one to entire transaction" option.

Only available if your preferences allow tracking of department.

Only available for France locales.

API docs for Quickbooks are located here https://developer.intuit.com/app/developer/qbo/docs/develop

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.

Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.

Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.

If not set, Full Name will be used here.

Only available if multicurrency is enabled.

Choose a Parent Customer if you're creating a Job/sub-customer.

If no, this customer will be billed.