> For the complete documentation index, see [llms.txt](https://software-help-docs.gitbook.io/knowledge-base/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://software-help-docs.gitbook.io/knowledge-base/software-guide/workflows/premium-triggers-and-actions/google-sheets-premium-action/delete-spreadsheet-row-using-lookup.md).

# Delete Spreadsheet Row using Lookup

Deleting a spreadsheet row using lookup involves searching for a specific row in your spreadsheet based on a particular value using Lookup, and then deleting all the values in that row.

To delete a specific row in a spreadsheet, you Should use Lookup Action to search for a column value in the data, which will return the corresponding row. Once you have located the desired row, you can then use the “Delete Spreadsheet Row using Lookup” Action to clear the data in the row.

If you want to use the “Delete using lookup” action, it is necessary to first use the “Lookup” action to search for a specific row in your spreadsheet based on a particular value. Once you have found the desired row using lookup, you can then use the “Delete using lookup” action to clear the row data. Therefore, using the lookup action prior to delete using lookup is a necessary step in this process.

Before proceeding with any further steps involving lookup, it is recommended that you review the documentation related to lookup. Google Sheets : Lookup Spreadsheet Row 

{% content-ref url="/pages/UBzIuhKM74F0D1mYUFJu" %}
[Lookup Spreadsheet Row](/knowledge-base/software-guide/workflows/premium-triggers-and-actions/google-sheets-premium-action/lookup-spreadsheet-row.md)
{% endcontent-ref %}

***

### Select Lookup Action

Only the Lookup Actions added above this action will be listed for selection.

![](https://t8631005.p.clickup-attachments.com/t8631005/b3609a99-aad9-461c-8d97-81afff9df7e6/lookup-delete.gif)

If a row is returned during a lookup, then all the values associated with that row will be cleared.

***

Points to Remember:

1. When you use the “Delete Spreadsheet Row” action, it clears the contents of the row, but it does not permanently remove the row itself.
2. If the Lookup Action does not return any rows, the workflow will skip this step and proceed to the next one.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://software-help-docs.gitbook.io/knowledge-base/software-guide/workflows/premium-triggers-and-actions/google-sheets-premium-action/delete-spreadsheet-row-using-lookup.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.