Clay Icon
Join the Community
02 Support

Help Needed: Google Sheet Integration with Clay Table

Avatar of BrayanBrayan
·
·

Hi team, im trying to add the google sheet to the clay table but it doesn't export automatically to the sheet I added please help thanks

5 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    It seems there might be a misunderstanding. Clay doesn't automatically export data from Google Sheets to Clay tables. Instead, we offer ways to add data from Clay to Google Sheets or import data from Google Sheets to Clay. To add data from Clay to Google Sheets: 1. In Clay, click "Add Enrichment" 2. Search for "Google Sheets" 3. Choose the "Add Row" action 4. Paste your Google Sheets URL 5. Select the sheet name 6. Map the relevant columns 7. Click "Save" This will add new rows from your Clay table to the specified Google Sheet. If you want to bring data from Google Sheets into Clay, you can export a CSV from Google Sheets and import it into Clay. Here's how: 1. Export your data as CSV from Google Sheets 2. In Clay, click "Create New" > "table" 3. Type "CSV" and select "Import from CSV" 4. Upload your file If you need more help, please request human assistance by clicking on "Talk to a person".

  • Avatar of Brayan
    Brayan
    ·
    ·

    this the clay table im trying to export to the google sheet, i added the action but it doesnt show anything when i run the column

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Hey there, thanks for reaching out! ☺️ First, you need to make the sheet public, it's private now. Secondly, you need to map in the values like so:

    (238 kB)
    Image

    Let me know if this resolves that for you! If not, happy to dive deeper! :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·