Lookup, Add, or Update a Row In Google Sheets with Clay

Automating your Google Sheets can be a ridiculously powerful growth hack- instead of manually updating complicated spreadsheets every time you get new information, just have Clay do it for you! Clay’s Lookup/Add/Update Row in Google Sheets integration does just that. Here’s how to do it:

First, navigate to the “Enrich Data” tab on the top right of your Clay table and find the “Lookup, Add, or Update Row” Google Sheets integration. Then, you need to connect your Google Sheets account to Clay- this is a short process that takes place within the integration. Then, select the sheet and page you’d like to input, map out the fields you would like to lookup/add/update, and then click “Run”

The fields that you specified will update, and within seconds you can check the Google Sheet and see the results. We hope this helps, feel free to reach out to us if you have any questions, and happy prospecting!

‍