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.

The column position (zero-based) to insert. If not set, append to the right by default.

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.

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.

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.

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.

Choose a product to filter, or leave blank for no filter.

Choose a product to filter, or leave blank for no filter.

User Tag Filter.

E-mail address of client to activate.

Email address of the new user.

Pick a group to add this client to.

E-mail address of client to assign to a trainer.

Pick a trainer to client to.

If the test trigger returns the owner's email, the send action may fail because a program cannot be copied to the owner account. To ignore this error, skip the test and the Zap should work properly.

Leave blank to start immediately.

E-mail address of client to deactivate.

If the test trigger returns the owner's email, the action may fail because the owner account cannot be removed from a group. To ignore this error, skip the test and the Zap should work properly.

If the test trigger returns the owner's email, the send action may fail because the owner account cannot be subscribed to a program. To ignore this error, skip the test and the Zap should work properly.

If the start type is Fixed, the start date is required.

If the test trigger returns the owner's email, the action may fail because the owner account cannot be unsubscribed from a program. To ignore this error, skip the test and the Zap should work properly.

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.

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.

Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.

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.

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?

Choose a product to filter, or leave blank for no filter.

User Tag Filter.

The email address for the client you want us to copy training plans from.

Email address for the client to whom the new plans will be applied. The copied plans will be queued after any existing training plans and will start on the same day of the week as the previous plan did.

E-mail address of client to assign to a trainer.

Pick a tag to add to client.

If the test trigger returns the owner's email, the send action may fail because the meal plan cannot be attached to owner's account. To ignore this error, skip the test and the Zap should work properly.

File to attach.

Email address of the new user.

First name of the user.

Last name of the user.

Status of the client, pending, active or deactivated.

Client's Activity Level.

Pick a trainer to assign to.

Pick an existing group to add this new client to.

Pick an existing custom client tag to apply to this new client.

Select existing main program to add this client to.

Select start date of existing main program to add this client to.

Email of client to remove tag from.

Pick a tag to remove from client.

If the test trigger returns the owner's email, the send action may fail because the account receiving the message cannot have the same email as the account sending the message. To ignore this error, skip the test and the Zap should work properly.

If the test trigger returns the owner's email, the send action may fail because the owner account cannot be subscribed to a program. To ignore this error, skip the test and the Zap should work properly.

If the start type is Fixed, the start date is required.

Email of the client.

File to attach.