Searches for the existence of data in a sheet. Returns true if found, false otherwise.
string
): The ID of the Google Sheet to search within.string
): The A1 notation of the range to search (e.g., “Sheet1!A1:ZZ”, “A:ZZ”).string
): The specific text value to search for within the specified range.boolean
): Returns true
if the searchTerm
is found anywhere within the specified range
of the sheet, and false
otherwise.