Clay Icon
Join the Community
02 Support

CSV Upload Issue: Rows Not Populating in Clay from GSheets

Avatar of LucasLucas
·
·

Hi Clay team, I uploaded a csv list of list of companies from gsheets to clay, but some of the rows didnt populate. Ex "Northstar" is a company that is row 746 on my gsheet, and it seems like clay picks up "northstar" via search, but the text doesn't show up. Could I get some advice here? Ty

2 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    When importing CSV data, there are a few things to check to ensure proper data population:1. Column Mapping: During the import process, make sure your columns are correctly mapped to Clay's format. We automatically pull in all columns, but you may need to modify column names to ensure proper alignment. 2. Data Format: Some fields may appear differently in Clay compared to your original CSV: • Object fields won't display raw data values • Integration fields showing "run condition not met" will appear blankTo optimize your CSV import, try creating a dedicated view with only the essential raw values you need. This can help ensure cleaner data transfer and make it easier to identify any potential formatting issues. Sources: Import CSV [Clay 101] - Clay University Download as a CSV [Clay 101] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Lucas! This thread was recently closed by our Support team. If you have a moment, please share your feedback: