{"action":"created","comment":{"url":"https://api.github.com/repos/workato/docs/pulls/comments/210511960","pull_request_review_id":146736833,"id":210511960,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIxMDUxMTk2MA==","diff_hunk":"@@ -0,0 +1,107 @@\n+---\n+title: Google Sheets' action - Search rows\n+date: 2017-6-12 23:00:00 Z\n+---\n+\n+# Google Sheets' action - Search rows\n+\n+The **Search rows** action allows you to get specific rows using a search query.\n+\n+It's often used together with an [Update row](https://docs.workato.com/connectors/google-sheets/action-update-row.html) action. So that you will first search for the rows you want to update, then update those rows.\n+\n+## How to use this action\n+### Setting up the Google sheet\n+First, in order for us to retrieve the custom data in a sheet, the sheet must contain, at a minimum, a header line for the first row and a data line for the second row, as in the following screenshot.\n+\n+![Sheet sample](/assets/images/connectors/google-sheets/five-row-sample.jpg)","path":"connectors/google-sheets/action-search-rows.md","position":16,"original_position":16,"commit_id":"0e1850ee6575bd59a296e23e3e27d7d54c8a9c00","original_commit_id":"0e1850ee6575bd59a296e23e3e27d7d54c8a9c00","user":{"login":"graceliching","id":16566480,"node_id":"MDQ6VXNlcjE2NTY2NDgw","avatar_url":"https://avatars3.githubusercontent.com/u/16566480?v=4","gravatar_id":"","url":"https://api.github.com/users/graceliching","html_url":"https://github.com/graceliching","followers_url":"https://api.github.com/users/graceliching/followers","following_url":"https://api.github.com/users/graceliching/following{/other_user}","gists_url":"https://api.github.com/users/graceliching/gists{/gist_id}","starred_url":"https://api.github.com/users/graceliching/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/graceliching/subscriptions","organizations_url":"https://api.github.com/users/graceliching/orgs","repos_url":"https://api.github.com/users/graceliching/repos","events_url":"https://api.github.com/users/graceliching/events{/privacy}","received_events_url":"https://api.github.com/users/graceliching/received_events","type":"User","site_admin":false},"body":"same comment here as in the add row article","created_at":"2018-08-16T08:17:56Z","updated_at":"2018-08-16T08:48:51Z","html_url":"https://github.com/workato/docs/pull/569#discussion_r210511960","pull_request_url":"https://api.github.com/repos/workato/docs/pulls/569","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/workato/docs/pulls/comments/210511960"},"html":{"href":"https://github.com/workato/docs/pull/569#discussion_r210511960"},"pull_request":{"href":"https://api.github.com/repos/workato/docs/pulls/569"}}},"pull_request":{"url":"https://api.github.com/repos/workato/docs/pulls/569","id":208524078,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA4NTI0MDc4","html_url":"https://github.com/workato/docs/pull/569","diff_url":"https://github.com/workato/docs/pull/569.diff","patch_url":"https://github.com/workato/docs/pull/569.patch","issue_url":"https://api.github.com/repos/workato/docs/issues/569","number":569,"state":"open","locked":false,"title":"Move Google Sheets docs from old resources.workato.com to doc.workato.com","user":{"login":"zweedao","id":3747942,"node_id":"MDQ6VXNlcjM3NDc5NDI=","avatar_url":"https://avatars3.githubusercontent.com/u/3747942?v=4","gravatar_id":"","url":"https://api.github.com/users/zweedao","html_url":"https://github.com/zweedao","followers_url":"https://api.github.com/users/zweedao/followers","following_url":"https://api.github.com/users/zweedao/following{/other_user}","gists_url":"https://api.github.com/users/zweedao/gists{/gist_id}","starred_url":"https://api.github.com/users/zweedao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zweedao/subscriptions","organizations_url":"https://api.github.com/users/zweedao/orgs","repos_url":"https://api.github.com/users/zweedao/repos","events_url":"https://api.github.com/users/zweedao/events{/privacy}","received_events_url":"https://api.github.com/users/zweedao/received_events","type":"User","site_admin":false},"body":"Move Google Sheets doc from https://resources.workato.com/googlesheets-connector/#/list/8?_k=1mlzit to doc.workato.com","created_at":"2018-08-15T10:15:14Z","updated_at":"2018-08-16T08:48:50Z","closed_at":null,"merged_at":null,"merge_commit_sha":"22aa9982fa079a2d4b4dceb9ed75d703ff9eb636","assignee":{"login":"graceliching","id":16566480,"node_id":"MDQ6VXNlcjE2NTY2NDgw","avatar_url":"https://avatars3.githubusercontent.com/u/16566480?v=4","gravatar_id":"","url":"https://api.github.com/users/graceliching","html_url":"https://github.com/graceliching","followers_url":"https://api.github.com/users/graceliching/followers","following_url":"https://api.github.com/users/graceliching/following{/other_user}","gists_url":"https://api.github.com/users/graceliching/gists{/gist_id}","starred_url":"https://api.github.com/users/graceliching/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/graceliching/subscriptions","organizations_url":"https://api.github.com/users/graceliching/orgs","repos_url":"https://api.github.com/users/graceliching/repos","events_url":"https://api.github.com/users/graceliching/events{/privacy}","received_events_url":"https://api.github.com/users/graceliching/received_events","type":"User","site_admin":false},"assignees":[{"login":"graceliching","id":16566480,"node_id":"MDQ6VXNlcjE2NTY2NDgw","avatar_url":"https://avatars3.githubusercontent.com/u/16566480?v=4","gravatar_id":"","url":"https://api.github.com/users/graceliching","html_url":"https://github.com/graceliching","followers_url":"https://api.github.com/users/graceliching/followers","following_url":"https://api.github.com/users/graceliching/following{/other_user}","gists_url":"https://api.github.com/users/graceliching/gists{/gist_id}","starred_url":"https://api.github.com/users/graceliching/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/graceliching/subscriptions","organizations_url":"https://api.github.com/users/graceliching/orgs","repos_url":"https://api.github.com/users/graceliching/repos","events_url":"https://api.github.com/users/graceliching/events{/privacy}","received_events_url":"https://api.github.com/users/graceliching/received_events","type":"User","site_admin":false}],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/workato/docs/pulls/569/commits","review_comments_url":"https://api.github.com/repos/workato/docs/pulls/569/comments","review_comment_url":"https://api.github.com/repos/workato/docs/pulls/comments{/number}","comments_url":"https://api.github.com/repos/workato/docs/issues/569/comments","statuses_url":"https://api.github.com/repos/workato/docs/statuses/0e1850ee6575bd59a296e23e3e27d7d54c8a9c00","head":{"label":"workato:google-sheets-docs-2018","ref":"google-sheets-docs-2018","sha":"0e1850ee6575bd59a296e23e3e27d7d54c8a9c00","user":{"login":"workato","id":5629924,"node_id":"MDEyOk9yZ2FuaXphdGlvbjU2Mjk5MjQ=","avatar_url":"https://avatars3.githubusercontent.com/u/5629924?v=4","gravatar_id":"","url":"https://api.github.com/users/workato","html_url":"https://github.com/workato","followers_url":"https://api.github.com/users/workato/followers","following_url":"https://api.github.com/users/workato/following{/other_user}","gists_url":"https://api.github.com/users/workato/gists{/gist_id}","starred_url":"https://api.github.com/users/workato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/workato/subscriptions","organizations_url":"https://api.github.com/users/workato/orgs","repos_url":"https://api.github.com/users/workato/repos","events_url":"https://api.github.com/users/workato/events{/privacy}","received_events_url":"https://api.github.com/users/workato/received_events","type":"Organization","site_admin":false},"repo":{"id":82145434,"node_id":"MDEwOlJlcG9zaXRvcnk4MjE0NTQzNA==","name":"docs","full_name":"workato/docs","owner":{"login":"workato","id":5629924,"node_id":"MDEyOk9yZ2FuaXphdGlvbjU2Mjk5MjQ=","avatar_url":"https://avatars3.githubusercontent.com/u/5629924?v=4","gravatar_id":"","url":"https://api.github.com/users/workato","html_url":"https://github.com/workato","followers_url":"https://api.github.com/users/workato/followers","following_url":"https://api.github.com/users/workato/following{/other_user}","gists_url":"https://api.github.com/users/workato/gists{/gist_id}","starred_url":"https://api.github.com/users/workato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/workato/subscriptions","organizations_url":"https://api.github.com/users/workato/orgs","repos_url":"https://api.github.com/users/workato/repos","events_url":"https://api.github.com/users/workato/events{/privacy}","received_events_url":"https://api.github.com/users/workato/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/workato/docs","description":null,"fork":false,"url":"https://api.github.com/repos/workato/docs","forks_url":"https://api.github.com/repos/workato/docs/forks","keys_url":"https://api.github.com/repos/workato/docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/workato/docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/workato/docs/teams","hooks_url":"https://api.github.com/repos/workato/docs/hooks","issue_events_url":"https://api.github.com/repos/workato/docs/issues/events{/number}","events_url":"https://api.github.com/repos/workato/docs/events","assignees_url":"https://api.github.com/repos/workato/docs/assignees{/user}","branches_url":"https://api.github.com/repos/workato/docs/branches{/branch}","tags_url":"https://api.github.com/repos/workato/docs/tags","blobs_url":"https://api.github.com/repos/workato/docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/workato/docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/workato/docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/workato/docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/workato/docs/statuses/{sha}","languages_url":"https://api.github.com/repos/workato/docs/languages","stargazers_url":"https://api.github.com/repos/workato/docs/stargazers","contributors_url":"https://api.github.com/repos/workato/docs/contributors","subscribers_url":"https://api.github.com/repos/workato/docs/subscribers","subscription_url":"https://api.github.com/repos/workato/docs/subscription","commits_url":"https://api.github.com/repos/workato/docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/workato/docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/workato/docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/workato/docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/workato/docs/contents/{+path}","compare_url":"https://api.github.com/repos/workato/docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/workato/docs/merges","archive_url":"https://api.github.com/repos/workato/docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/workato/docs/downloads","issues_url":"https://api.github.com/repos/workato/docs/issues{/number}","pulls_url":"https://api.github.com/repos/workato/docs/pulls{/number}","milestones_url":"https://api.github.com/repos/workato/docs/milestones{/number}","notifications_url":"https://api.github.com/repos/workato/docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/workato/docs/labels{/name}","releases_url":"https://api.github.com/repos/workato/docs/releases{/id}","deployments_url":"https://api.github.com/repos/workato/docs/deployments","created_at":"2017-02-16T06:04:38Z","updated_at":"2018-08-13T15:31:38Z","pushed_at":"2018-08-15T10:37:06Z","git_url":"git://github.com/workato/docs.git","ssh_url":"git@github.com:workato/docs.git","clone_url":"https://github.com/workato/docs.git","svn_url":"https://github.com/workato/docs","homepage":null,"size":394055,"stargazers_count":2,"watchers_count":2,"language":"HTML","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":12,"mirror_url":null,"archived":false,"open_issues_count":145,"license":null,"forks":12,"open_issues":145,"watchers":2,"default_branch":"master"}},"base":{"label":"workato:master","ref":"master","sha":"c473b6c1fec1d5600a04a95619d15ffc91d2099f","user":{"login":"workato","id":5629924,"node_id":"MDEyOk9yZ2FuaXphdGlvbjU2Mjk5MjQ=","avatar_url":"https://avatars3.githubusercontent.com/u/5629924?v=4","gravatar_id":"","url":"https://api.github.com/users/workato","html_url":"https://github.com/workato","followers_url":"https://api.github.com/users/workato/followers","following_url":"https://api.github.com/users/workato/following{/other_user}","gists_url":"https://api.github.com/users/workato/gists{/gist_id}","starred_url":"https://api.github.com/users/workato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/workato/subscriptions","organizations_url":"https://api.github.com/users/workato/orgs","repos_url":"https://api.github.com/users/workato/repos","events_url":"https://api.github.com/users/workato/events{/privacy}","received_events_url":"https://api.github.com/users/workato/received_events","type":"Organization","site_admin":false},"repo":{"id":82145434,"node_id":"MDEwOlJlcG9zaXRvcnk4MjE0NTQzNA==","name":"docs","full_name":"workato/docs","owner":{"login":"workato","id":5629924,"node_id":"MDEyOk9yZ2FuaXphdGlvbjU2Mjk5MjQ=","avatar_url":"https://avatars3.githubusercontent.com/u/5629924?v=4","gravatar_id":"","url":"https://api.github.com/users/workato","html_url":"https://github.com/workato","followers_url":"https://api.github.com/users/workato/followers","following_url":"https://api.github.com/users/workato/following{/other_user}","gists_url":"https://api.github.com/users/workato/gists{/gist_id}","starred_url":"https://api.github.com/users/workato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/workato/subscriptions","organizations_url":"https://api.github.com/users/workato/orgs","repos_url":"https://api.github.com/users/workato/repos","events_url":"https://api.github.com/users/workato/events{/privacy}","received_events_url":"https://api.github.com/users/workato/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/workato/docs","description":null,"fork":false,"url":"https://api.github.com/repos/workato/docs","forks_url":"https://api.github.com/repos/workato/docs/forks","keys_url":"https://api.github.com/repos/workato/docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/workato/docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/workato/docs/teams","hooks_url":"https://api.github.com/repos/workato/docs/hooks","issue_events_url":"https://api.github.com/repos/workato/docs/issues/events{/number}","events_url":"https://api.github.com/repos/workato/docs/events","assignees_url":"https://api.github.com/repos/workato/docs/assignees{/user}","branches_url":"https://api.github.com/repos/workato/docs/branches{/branch}","tags_url":"https://api.github.com/repos/workato/docs/tags","blobs_url":"https://api.github.com/repos/workato/docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/workato/docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/workato/docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/workato/docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/workato/docs/statuses/{sha}","languages_url":"https://api.github.com/repos/workato/docs/languages","stargazers_url":"https://api.github.com/repos/workato/docs/stargazers","contributors_url":"https://api.github.com/repos/workato/docs/contributors","subscribers_url":"https://api.github.com/repos/workato/docs/subscribers","subscription_url":"https://api.github.com/repos/workato/docs/subscription","commits_url":"https://api.github.com/repos/workato/docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/workato/docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/workato/docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/workato/docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/workato/docs/contents/{+path}","compare_url":"https://api.github.com/repos/workato/docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/workato/docs/merges","archive_url":"https://api.github.com/repos/workato/docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/workato/docs/downloads","issues_url":"https://api.github.com/repos/workato/docs/issues{/number}","pulls_url":"https://api.github.com/repos/workato/docs/pulls{/number}","milestones_url":"https://api.github.com/repos/workato/docs/milestones{/number}","notifications_url":"https://api.github.com/repos/workato/docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/workato/docs/labels{/name}","releases_url":"https://api.github.com/repos/workato/docs/releases{/id}","deployments_url":"https://api.github.com/repos/workato/docs/deployments","created_at":"2017-02-16T06:04:38Z","updated_at":"2018-08-13T15:31:38Z","pushed_at":"2018-08-15T10:37:06Z","git_url":"git://github.com/workato/docs.git","ssh_url":"git@github.com:workato/docs.git","clone_url":"https://github.com/workato/docs.git","svn_url":"https://github.com/workato/docs","homepage":null,"size":394055,"stargazers_count":2,"watchers_count":2,"language":"HTML","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":12,"mirror_url":null,"archived":false,"open_issues_count":145,"license":null,"forks":12,"open_issues":145,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/workato/docs/pulls/569"},"html":{"href":"https://github.com/workato/docs/pull/569"},"issue":{"href":"https://api.github.com/repos/workato/docs/issues/569"},"comments":{"href":"https://api.github.com/repos/workato/docs/issues/569/comments"},"review_comments":{"href":"https://api.github.com/repos/workato/docs/pulls/569/comments"},"review_comment":{"href":"https://api.github.com/repos/workato/docs/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/workato/docs/pulls/569/commits"},"statuses":{"href":"https://api.github.com/repos/workato/docs/statuses/0e1850ee6575bd59a296e23e3e27d7d54c8a9c00"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"graceliching"}}