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.

Which Funnel should we watch for new Contacts?

Which Funnel Step should we watch for new Contacts?

Which Funnel should we watch for new Purchases?

Which Funnel Step should we watch for new Purchases?

Tag string to add to contact profile.

Email of contact profile to receive tag.

The email for the contact profile.

Tag to Add to Contact Profile.

Email Address of Contact Profile that should receive tag.

API docs for ClickFunnels are located here https://apidocs.clickfunnels.com/

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 email for the contact profile.

You must provide either an Item Code or both a Description and a Unit Price.

If no Item Code is provided, this field is required.

If no Item Code is provided, this field is required.

Only specify if you want to override the default tax type for the account above.

The bank account the payment is being made from.

The bank account the payment is being made to.

Defaults to current date if not specified.

If you want Xero to auto-generate a Quote Number for you, leave this field blank.

Defaults to Tax Exclusive if not specified

To email an invoice, it must have a status of Awaiting Approval, Awaiting Payment or Paid. The email will be sent to the primary email address of the contact on the invoice and any others marked as "Include in emails." The subject and body of the email will be based on the default email template.

Defaults to Draft if not specified.

Defaults to creation date if not specified.

A due date is required for approved invoices.

Default currency for organization will be used if not specified.

URL link to a source document.

The branding theme to use for this invoice.

Unique alpha numeric code identifying invoice - leave blank for auto-generated value.

An additional reference number

URL link to a source document.

Mark invoice as "sent" (note: does not actually send an email). This can be set only on invoices that have a status of "approved" You can set this in the Status field above.

Line amounts are exclusive of tax by default if you don't specify this element.

You must provide either an Item Code or both a Description and a Unit Price.

If no Item Code is provided, this field is required.

If no Item Code is provided, this field is required.

Only specify if you want to override the default tax type for the account above.

For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.

When the purchase order was issued. Defaults to today's date if not specified.

If left blank, Xero will auto-generate this from your default invoice numbering.

You must provide either an Item Code or both a Description and a Unit Price.

If no Item Code is provided, this field is required.

If no Item Code is provided, this field is required.

Only specify if you want to override the default tax type for the account above.

API docs for Xero are located here https://developer.xero.com/documentation/api/accounting/overview

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.

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?

Which Funnel should we watch for new Purchases?

Which Funnel Step should we watch for new Purchases?

Select the Static List to add a Contact Profile Email.

Email Address of Contact Profile to add to List.

Which Funnel Should we Opt Contact into?

Which Funnel Step is this contact going into?

The page associated with the opt-in.

The email of the opt-in.

Select the Static List to add a Contact Profile Email.

Email Address of Contact Profile to add to List.

Determines which App Extensions will appear in the dropdown below.

Exact email search.

If left empty, Zapier will trigger on all new quotes, regardless of status.

Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.

Add contact to selected group(s). Does not replace contact's existing groups.

Defaults to today's date if not specified.

Defaults to Draft if not specified.

Defaults to creation date if not specified.

A due date is required for approved invoices.

Default currency for organization will be used if not specified.

URL link to a source document.

The branding theme to use for this invoice.

Non-unique alpha numeric code identifying the bill.

URL link to a source document.

Line amounts are exclusive of tax by default if you don't specify this element.

You must provide either an Item Code or both a Description and a Unit Price.

If no Item Code is provided, this field is required.

If no Item Code is provided, this field is required.

Only specify if you want to override the default tax type for the account above.

For example: Region - West Coast - see Setting > General Settings > Tracking in Xero for your tracking categories and options.

What you'll you provide the ID or number for via the next field.

The ID or Number for the selected Document Type.

The bank account or clearing account the payment is being made to.

Exchange rate when payment is received. Only used for non base currency invoices.

An optional description for the payment.

Determines which App Extensions will appear in the dropdown below.

Also known as the ABN (Australia), GST Number (New Zealand), VAT Number (UK) or Tax ID Number (US and global) depending on which regionalized version of Xero you use.

Add contact to selected group(s). Does not replace contact's existing groups.