Find cell by value in Google Sheets using Python

Search for values in a Google Sheets worksheet in Python using the gspread library. Find cells with your value and get their row and column locations.

Required packages

You need below packages to use the code generated by recipe. All packages are automatically installed in MLJAR Studio.

gspread>=6.1.2

Interactive recipe

You can use below interactive recipe to generate code. This recipe is available in MLJAR Studio.

In the below recipe, we assume that you have following variables available in your notebook:

worksheet (type Worksheet)

Python code

# Python code will be here

Code explanation

Find the cells and save them as a variable.
Print their location.

Google Sheets cookbook

Code recipes from Google Sheets cookbook.

Connection
Open spreadsheet
Create spreadsheet
Delete spreadsheet
Share spreadsheet
Open worksheet
Create worksheet
Delete worksheet
Read data
Find cell by value
Append rows
Update cell
Update range

« Previous: Read data
Next »: Append rows