All docs
/
Export
/
Google Sheets integration

Google Sheets integration

Cloud-based spreadsheet for real-time collaboration.

Overview

Google Sheets in Clay enables seamless integration between your Clay tables and Google Sheets, allowing you to easily sync and manage data across both platforms.

Enriching data with Google Sheets

  1. While in a Clay table, click Actions and search for Google Sheets.
  2. Under Enrichments, select one of the Google Sheets options.
  3. In the modal, you will be asked to Select Google Sheets account.
    • If you haven't already connected your Google Sheets, click + Add account and go through authentication.

Action Add row

Add a row to a Google Sheet via its URL.

Inputs

  • Google Spreadsheet URL

Action Look up row

Lookup a row in a Google Sheet using a column and a value.

Inputs

  • Google Spreadsheet URL

Action Update rows

Updates existing rows in a Google Sheet. Clay matches rows with a case-insensitive lookup on the column you choose, then writes your values into the columns you map.

Inputs

  • Required: Google Spreadsheet URL
  • Required: Sheet ID — the tab within the spreadsheet.
  • Required: Lookup column and Lookup value — together these identify which row to update.
  • Optional: Update multiple rows? — update every matching row. With this off, a lookup that matches more than one row fails instead of updating.
  • Optional: Update fields — the columns and values to write.
Note:

This action replaces the older Lookup, Add, or Update Row, which is now deprecated. The two don't behave the same way: the old action added a new row when the lookup found nothing, while this one only updates — if no row matches, it returns no data and your sheet is unchanged. Existing columns using the old action keep working, but use Update rows for anything new.

Run settings

Explore other docs

Gen AI

Clay MCP in ChatGPT

Connect the Clay MCP to ChatGPT, sign in to your workspace, and see what you can build and run from a chat on your plan.

View article
Settings & admin

Best practices before a member leaves your workspace

Audit admin access, billing, connections, automated work, and sequencer senders before you remove a member from your workspace.

View article
Getting started

Enhanced matching

Enhanced matching is Clay's hashed email enrichment: it finds the personal email identifiers ad platforms recognize, so more of your audience matches when you sync it.

View article
Signals & triggers

Ad lead form triggers

Send LinkedIn and Meta lead generation submissions into a Clay workflow, so each new lead is qualified, routed, or written to Audiences automatically.

View article
Export

Credit refunds

Learn when Clay refunds Actions and Data Credits, and which actions refund when a provider returns no data.

View article
Enrich

Definitive Healthcare integration

Find US hospitals in Clay and enrich them with executives, physicians, networks, payor mix, technology, and financial metrics.

View article
Enrich

Reusing saved enrichment data

Keep the data your enrichments return so later runs can reuse it instead of paying for the same answer twice.

View article

Other popular resources

Experts

Find a Clay Expert

Explore our network of Clay experts and agencies.

View experts
Community

Join our slack community

Find help in our slack community, and support channels.

Go to slack
Cohorts

Join a cohort, learn Clay fast!

The faster way to master Clay. Sign in if you're enrolled in a cohort (current or past) or apply!

Learn more about cohorts
Talents

Hire GTME Talent

Find and connect with GTM talent who've demonstrated expertise in building advanced workflows

Explore GTME talents