Introduction
This integration enables users to retrieve specific rows from Google Sheets based on a column and value match. It works with any Google Sheet the user has read access to, including public sheets. The Lookup Row action streamlines data retrieval, allowing for efficient integration of Google Sheets data into Clay workflows. This functionality leverages Google Sheets' API to perform targeted data lookups.
Provider: https://sheets.google.com
API Documentation: https://support.google.com/docs/answer/3256570
Input
Name | Is Optional | Description | Type |
Google Spreadsheet URL | This can be any Google Spreadsheet you have read access to, including a public one. e.g. https://docs.google.com/spreadsheets/d/1s6-hGBh0_tqa-jd23fsdYuwbmS8UPmElPqaH-Rnoa_A/ | text | |
true | dynamicFields |