Troubleshooting Google Sheets Data Source Issues in Table Creation

hi everyone! having some trouble using google sheets as a data source for a table, it just doesn't show up in my sources. I've made sure the connection is active. Can't use a CSV as I need it to automatically add new rows. Any idea why it won't show up?

4 comments

Channeled
APP
·
·
Google Sheets isn't typically used as a data source to populate Clay tables. Instead, it's an integration that allows you to sync data from Clay to Google Sheets. To use Google Sheets with Clay, you'll need to set it up as an action, not a source. You can use it to: 1. Add rows to a Google Sheet 2. Lookup rows in a Google Sheet 3. Lookup, add, or update rows in a Google Sheet If you need to bring data into Clay, consider using other data sources like Salesforce or our Find People feature. If you need further assistance, please request human help by clicking on "Talk to a person" in this chat.
Sources: Google Sheets integration overview | Documentation | Clay University Table sources overview | Documentation | Clay University
Adarsh B.
·
·
How do I use the lookup in a blank table?
Channeled
APP
·
·
To use the lookup feature in a blank table, you'll need to set up a "Lookup Rows" action. Here's a quick guide: 1. Add a new column to your blank table. 2. Choose "Add Enrichment" for that column. 3. Search for and select "Lookup Rows" action. 4. Choose between "Lookup Single Row" or "Lookup Multiple Rows" based on your needs. 5. Specify the following: • Table to Search (the table you want to lookup data from) • Target Column (the column in the other table to match against) • Filter Operator (e.g., exact match, contains) • Row Value (the value to search for) For multiple row lookups, you can also set a limit on the number of rows to return. If you need more detailed assistance, please request human help by clicking on "Talk to a person" in this chat.
Sources: Google Sheets integration overview | Documentation | Clay University Lookup Rows | Documentation | Clay University
Channeled
APP
·
·

Troubleshooting Google Sheets Data Source Issues in Table Creation | Clay