Clay Icon

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?

  • Avatar of Channeled
    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.

  • Avatar of Adarsh B.
    Adarsh B.
    Β·
    Β·

    How do I use the lookup in a blank table?

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·