var spreadsheetId = '1imhX_Z7cCA8lRVlyImxwDinNhWThldC4US-SanB-VnI'; var range = 'Sheet1!A1:B5'; // replace with the range you want to search in var searchValue = 'search value'; // replace with the value you want to find // Make a request to the Sheets API gapi.client.sheets.spreadsheets.values.get({ spreadsheetId: spreadsheetId, range: range, }).then(function(response) { var rows = response.result.values; var result = null; if (rows && rows.length) { for (var i = 0; i -1) { result = row; break; } } } console.log(result); }, function(response) { console.error(response.result.error.message); });