Changing your sheet's structure after publishing your Zap can cause unexpected behavior. [Learn how to fix it and best practices for using Google Sheets](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps#h_01JDSV0C8QGPB0EJJ062KVW8D4).

Select the Google Drive location of your spreadsheet. Choose between My Drive or a Shared Drive; the former is the default.

Worksheets must have column headers. Learn more about [spreadsheet formatting](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps).

If you are using a spreadsheet in a Shared Drive, use the "New or Spreadsheet Row (Team Drive)" trigger instead. [Learn more](https://help.zapier.com/hc/en-us/articles/21613796877325-Google-Sheets-Zap-is-triggering-on-rows-in-a-sheet-on-another-Team-Drive#h_01HFYJ2F77WX1QNSGFY88AQGSK)

Worksheets must have headers. Learn more about [spreadsheet formatting](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps).

Select a column to trigger your Zap only when changes happen there. New rows always trigger (even if empty). Use a [filter](https://help.zapier.com/hc/en-us/articles/8496276332557-Add-conditions-to-Zaps-with-filters) to skip empty new rows. Any_column will trigger on any column.

If you are using a spreadsheet in a Shared Drive, use the “New or Update Spreadsheet Row (Team Drive)” trigger instead. [Learn more](https://help.zapier.com/hc/en-us/articles/21613796877325-Google-Sheets-Zap-is-triggering-on-rows-in-a-sheet-on-another-Team-Drive#h_01HFYJ2F77WX1QNSGFY88AQGSK)

Select a column to trigger your Zap only when changes happen there. New rows always trigger (even if empty). Use a [filter](https://help.zapier.com/hc/en-us/articles/8496276332557-Add-conditions-to-Zaps-with-filters) to skip empty new rows.

Select the column you want to search within. The specified lookup value will be compared to values in this column to find a matching row.

Enter the value to search for in the lookup column. If looking for empty values, type `[:empty:]` in this field.

Optional: Specify an additional column to filter your search. When used, the Zap will only trigger for rows matching both columns.

Enter the value to search for in the supporting lookup column. This value, combined with the lookup value, will be used to find a matching spreadsheet row.

Search from the last row of the spreadsheet up. Select “True” to enable.

Enter the number of rows you want to retrieve. Maximum of 500 rows.

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

The specific worksheet within the spreadsheet to work with.

The A1 notation range to get data from (e.g., "A1:D10", "B2:E5", or "B:B" for entire column).

Specify the columns you want to include. Use letter ranges (A:A, A:Z)

Enter the number of rows you want to retrieve. Maximum of 1,500 rows.

Select the format you want to output the data in.

Specify the number of the first row to retrieve. Row 1 is considered the header.

Enter the row number you want to retrieve. Row 1 is typically the header row, so data usually starts from row 2.

The ID of the Google Spreadsheet. You can find this in the URL of your spreadsheet (e.g., in https://docs.google.com/spreadsheets/d/ABC123/edit, the ID is ABC123).

The value to search for in the lookup column. If looking for empty values, type `[:empty:]` in this field.

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 the bottom of the spreadsheet up. Select "True" to enable.

Enter the number of rows you want to retrieve when returning all results as line items. Maximum of 500 rows.

Enter the column number where you want to insert the column. Use 0 for column A, 1 for column B, etc. Leave blank to add a column at the end.

If true, the timezone set up in the spreadsheet will be used to format the date values.

Number of rows to freeze at the top (keeps headers visible while scrolling).

Number of columns to freeze on the left (keeps them visible while scrolling).

Move sheet to this position (0 = first sheet, 1 = second sheet, etc.).

Hide this sheet from view. Note: Cannot hide the only visible sheet in a spreadsheet.

The spreadsheet to apply conditional formatting to.

The worksheet within the spreadsheet to format.

The range of cells to apply conditional formatting to using A1 notation (e.g., A1:C10 for a rectangle, A:A for entire column, 1:1 for entire row).

The condition that determines when the formatting should be applied.

The background color to apply when the condition is met. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

The text color to apply when the condition is met. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

Make the text bold when the condition is met.

Make the text italic when the condition is met.

Range to copy from using A1 notation (e.g., A1:C10, B2:E5).

Where to paste using A1 notation. Can be a single cell (e.g., E1) or a full range (e.g., E1:G10).

Select a spreadsheet to copy the worksheet to. Leave blank to copy to the original spreadsheet’s location.

Select the Google Drive location for your spreadsheet. Choose between My Drive or a Shared Drive; the former is the default.

Enter column headers for your new spreadsheet. These will be ignored if "Spreadsheet to Copy" is selected.

This action clears the contents of a spreadsheet row. If needed, you may be able to recover the contents using the [Version History](https://knowledge.workspace.google.com/kb/how-to-recover-versions-of-a-google-drive-document-000007648) feature in Google Sheets.

Worksheets must have headers. Learn more about [spreadsheet formatting](https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps). 

Specify which row(s) to clear. You can enter:

•	A single row, such as 5, to clear row 5.

•	Multiple rows separated by commas, such as 1, 3, 5, to clear rows 1, 3, and 5.

•	A range of rows, such as 1-5, to clear rows 1 through 5.

•	A combination of individual rows and ranges, such as 1, 3-5, to clear rows 1, 3, 4, and 5.

Type "DELETE" to confirm you want to permanently delete this sheet. This action cannot be undone.

This action will delete a spreadsheet row. If needed, you may be able to recover the row using the [Version History](https://knowledge.workspace.google.com/kb/how-to-recover-versions-of-a-google-drive-document-000007648) feature in Google Sheets. 

<b>Warning:</b> Deleting a row may cause Zaps using the “New or Updated Spreadsheet Row” trigger on the same worksheet to re-trigger on every row below the deleted row. If you want to avoid this, consider using the “Clear Spreadsheet Row” action instead, which clears the data from the row while keeping the row itself intact.

Specify which row(s) to delete. You can enter:

•	A single row, such as 5, to delete row 5.

•	Multiple rows separated by commas, such as 1, 3, 5, to delete rows 1, 3, and 5.

•	A range of rows, such as 1-5, to delete rows 1 through 5.

•	A combination of individual rows and ranges, such as 1, 3-5, to delete rows 1, 3, 4, and 5.

The worksheet containing the cells to format.

The range of cells to format using A1 notation (e.g., A1:C10 for a rectangle, A:A for entire column, 1:1 for entire row).

Select the Row ID to update the same row each time the Zap runs or set the Row ID as a [custom value](https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T) to update different rows.

The background color for the row. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

The text color for the row. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

Type of validation rule to apply to the range.

Optional message shown when data does not match the validation criteria.

Whether to reject input that does not match the validation criteria.

Column letter to sort by (e.g., A, B, C, AA, AB, ZZ).

Select the Row ID to update the same row each time the Zap runs. Or set the Row ID as a [custom value](https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps#01H7FR09FBEAKK4ZZP678QDE9T) to update different rows. 

Optional: The background color for the row. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

Optional: The text color for the row. Choose from your current custom Theme Color in your Spreadsheet, or select a predefined color.

Optional: Strikethrough the text in the row.

Select “Yes” to [stop this Zap step](https://help.zapier.com/hc/en-us/articles/20505304170637-Review-Zap-run-statuses#h_01HD20969HPZ01ENM30NQR79X5) if the app returns an error and enable automatic authentication refresh. Select “No” to run the Zap step regardless of errors. Learn more about [API Request action error handling](https://help.zapier.com/hc/en-us/articles/12899473501453#h_01JKRBY68EDXBB1V817DSTRZ0N).

Requests can only be made to domains associated by this application. Read more about [API Request Setup](https://help.zapier.com/hc/en-us/articles/12899607716493).

Any parameters added to a URL will be URL-encoded and appended to the request URL to pass additional data to the API request.

These headers and values will be applied to the request in addition to any headers created as part of authentication. Authentication headers are added automatically.

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.

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Being able to collect, track, and analyze your data is essential for any business. Using Google Sheets with Zapier, you can automatically create and edit spreadsheets with data from other apps you use. Zapier can monitor changes in your Google Sheets and quickly share your important data with stakeholders. When you put Zapier to work with Google Sheets, you can connect Google Sheets to other apps, automating all of your spreadsheet tasks to save you time.

Google Sheets

Zapier Tables is a no-code database built for automation.

Zapier Tables

Zoho Creator is an online database builder. Its easy drag-n-drop interface lets you create custom applications for every data collection need, define workflow and also configure business rules that are unique to your business.

Zoho Creator

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Smartsheet

Quip is a modern productivity suite that enables you and your team to collaborate on any device. It works across iPhone, iPad, Android phones and tablets, and the desktop web. Quip has a simple and elegant interface that combines documents and messages into a single chat-like “thread” of updates, making collaboration immediate and easy. You can share documents, tables, checklists, and more so multiple people can edit and discuss together in a single, shared workspace.

Quip

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Airtable

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Microsoft Excel

PDF-API.io is a Dynamic PDF API. You create templates using our intuitive visual designer or using HTML. Then use our API to inject dynamic data et render PDFs

PDF-API.io

Here are some creative ways to use Google Sheets with Zapier:

Simplify your document workflows with this Google Sheets and PDF-API.io process. Whenever a spreadsheet row is added or updated in Google Sheets, a PDF will be swiftly created in PDF-API.io. This efficient workflow eradicates manual data transfer, saving you time and boosting productivity. Embrace this seamless integration to ensure your PDF documents are always up-to-date with your latest spreadsheet data.

Google Sheets + PDF-API.io

Render pdfs in PDF-API.io from new or updated rows in Google Sheets

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About PDF-API.io

Related categories