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?

Enter a two-letter country code.

Enter a two-letter country code.

Enter a two-letter language code.

The prefix for the customer used to generate unique invoice numbers. Must be 3-12 uppercase letters or numbers.

An integer amount in cents that represents the customer's current balance. A negative amount represents a credit that decreases the amount due on an invoice. (e.g. -2000 decreases invoice amount by $20.00) A positive amount increases the amount due on an invoice. (e.g. 1000 increases invoice amount by $10.00)

A positive integer in minor units (e.g. cents) or 0 for a free price. For example, if your currency is USD, enter 100 to charge $1.00.

Must be a supported three-letter ISO currency code.

A subscription can be created with up to 20 items. Selecting the same item more than once will result in an error.

When charging automatically, Stripe will attempt to pay this subscription at the end of the cycle using the default source attached to the customer. When sending an invoice, Stripe will email your customer an invoice with payment instructions.

Enter a two-letter country code.

Enter a two-letter country code.

Enter a two-letter language code.

The prefix for the customer used to generate unique invoice numbers. Must be 3-12 uppercase letters or numbers.

An integer amount in cents that represents the customer's current balance. A negative amount represents a credit that decreases the amount due on an invoice. (e.g. -2000 decreases invoice amount by $20.00) A positive amount increases the amount due on an invoice. (e.g. 1000 increases invoice amount by $10.00)

Enter the Stripe ID of the charge to find. (e.g. ch_51kxCxb1NFWajM)

Enter the Stripe ID of the invoice to find. (e.g. in_51kxCxb1NFWajM)

If this field is left empty, Zapier will search for subscriptions that have not been canceled.

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.

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.

You can add a Price Description to the Price of a Product in Stripe to make it easier to find in Zapier.

By default this value is 0. You can specify a value up to 98. If you do not want to let customers adjust quantity, leave this field empty, or pass an empty line item value.

By default this value is 99. You can specify a value up to 99. If you do not want to let customers adjust quantity, leave this field empty, or pass an empty line item value.

To use this option, you must first enable "Automate taxes" at https://dashboard.stripe.com/setup

A tax code ID.

API docs for Stripe are located here https://stripe.com/docs/api

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.

Defaults to "Customer Stripe ID"

Enter the Stripe ID (e.g. cus_51kxW2Z0qQHpGc) or the email address of the customer to find.

Enter the Stripe ID of the payment intent to find. (e.g. pi_51kxCxb1NFWajM)