Introduction
This integration enables users to interact with Google Sheets directly from Clay. The Lookup, Add, or Update Row action allows for searching a specific row in a Google Sheet using a column and value. If no matching row is found, a new row can be added. Alternatively, if a match is found, the existing row can be updated with new information.
Provider: https://sheets.google.com
API Documentation: https://docs.clay.com/enrichments-and-providers/enrichments/all-providers/google-sheets/lookup-add-or-update-row-in-google-sheet
Input
Name | Is Optional | Description | Type |
Google Spreadsheet URL | This can be any Google Spreadsheet you have edit access to. e.g. https://docs.google.com/spreadsheets/d/1s6-hGBh0_tqa-jd23fsdYuwbmS8UPmElPqaH-Rnoa_A/ | text | |
true | dynamicFields |