There are infinite use cases for sending data from Clay into Google Sheets.  

This integration unlocks your ability to add, lookup, and update data to Google Sheets. A few examples of interesting use cases are:

• Analyze post engagement from your influencers on LinkedIn using Google Sheets
• Generate target ICPs using AI and Google Sheets

‍

First, we'll walk through how to connect Clay to your Google Sheets account. Then we'll use an example workflow on how each Action works with the Google sheets integration. The available actions are: 

1. Add Row - You can add a row into Google Sheet
2. Lookup Row - You can lookup if a row already exists in Google Sheet
3. Lookup, Add, or Update Row - You can update an existing row in Google Sheet

Now, let's make all of your Google Spreadsheet dreams come true.

Step 1: Connect your Google Sheets account

‍

‍

Follow the steps in this interactive tutorial to connect your account:   

‍

• Click Add Enrichment
• Search for "Google Sheets" 
• Click on any Google Sheets action
• Click Add Acount and sign into your Google account
• Type a name for your account and click Save

‍

You're connected! Now, we'll create simple workflow to data into Google Sheets.

2. Add rows into Google Sheets

The most simple action in the Google Sheets integration isAdd Row.

This allows you to, you guessed it, add a row into Google Sheets. We'll illustrate how this works with an example you can follow along with to experience how it works.

First, copy this simple Clay template.

There are three columns in this Clay table that we'll send to Google Sheets

• The Domain of the company
• The City where company is located
• Their LinkedIn Company URL

‍

Next, create a new Google Sheet with these columns:

Now, follow this interactive tutorial and you'll have a completed sheet! 

‍

• Click Add Enrichment
• Search for "Google Sheets" 
• Click on the Add Row action
• Paste your Google Sheets URL
• Select the sheet name
• Type / and select the relevant column(s)
• Click Save

‍

After following the tutorial, your Clay table will look like this: 

Let's click over to your Google Sheets. You'll see it populated with data from Clay: 

Yes, we know, it feels like magic. You're welcome.

Step 3: Lookup rows in Google Sheets

‍

Next, we're going to use the Lookup Row action in Google Sheets. This allows you to, you guessed it again, look up a row in Google Sheets.

Follow this step-by-step tutorial: 

‍

After following the tutorial, your Clay table will look like this: 

Next, we'll add a new value from Clay about this company and update that in Google Sheets.

Step 4: Update rows in Google Sheets

‍

The third and final action in our Google Sheets integration is Lookup, Add, or Update Row.

This action unlocks your ability to change data that's in an existing Google Sheet. You can search for a specific row 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.

Let's walk through an example with an interactive tutorial: 

Share what you built LinkedIn!

Finally, we'd love to see what you're building with the Google Sheets integration.

If you tag @Clay on LinkedIn we'll reach out to publish your example on our clay.com/templates page. Or maybe even our clay.com/claybooks page if it's extra special.

We love to see creative examples from the Clay community. ❤️

API Documentation

‍

Clay uses the Google Sheets API which can be found here - https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append

If you have additional questions please ask our support team for assistance.

Frequently Asked Questions

‍

Find example questions and answers about our Google Sheets integration below.

If you need help chat with our support team. Additionally, you can hire a Clay expert to build a custom Google Sheets workflow for you.

Q: How do I import data from a Google Sheet into Clay?

The easiest way to is to export a CSV file from Google Sheets and upload into Clay. Follow this lesson for more guidance on how to do that.

Q: How do I export data from a Google Sheet into Clay?

You always have the option to export a CSV from Clay and import in Google Sheets. Alternatively, you can follow the options in this lesson to

• Add a row
• Update a row

‍

‍

‍
The easiest way to is to export a CSV file from Google Sheets and upload into Clay. Follow this lesson for more guidance on how to do that.

‍